What is the easiest way to create a report using some format like in the Item Card -> Item by Location, where items are in the row and locations in the columns?
when a user ask me this kind of report i use to make an export into excel instead of a print bicause in navision is not possible define a dinamic array so if you add some location the report don't work well
I had a customer with a lot of location and it was impossible print all in a page ( landscape orientation) so the only solution i suggest was export in excel.
the other problem is that you define a array with dimension 10 ( example) and after the location are 11 you colud have an error.
anyway it was only a suggestion for company with a lot of location .
That's right. I am agree with you.. it isn't a good idea to show this statistics in Report with a lot of location.
About the error, which error message do you have?
the error is about the dimension of array when you try to write in array[11] and dimension was 10, sometimes happen when user add location and you don't know.
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Because if you have more than hundred locations than you must have troubles to print it all :roll:
Ok.. the easiest way to create it: use array.. for an example, look at form 151.
or just see my code:
Selamat mencoba...
when a user ask me this kind of report i use to make an export into excel instead of a print bicause in navision is not possible define a dinamic array so if you add some location the report don't work well
I don't know what kind of problem do you have.
I have just tried my code in Cronus with 7 Locations and it works fine.
the other problem is that you define a array with dimension 10 ( example) and after the location are 11 you colud have an error.
anyway it was only a suggestion for company with a lot of location .
About the error, which error message do you have?