Hi All,
I'm a total newbie to the forum and to jet reports and Nav
I've been feeling my way through using a lot of predefined templates that the company uses and I have one that essentially runs a stock movement report that has a definable Location as an option. If I enter mutiple locations into the field it will create mutiple sheets.
I'd like to remove the separate sheet function and just have the document return the list of items as a total so I can understand company wide stock consumption than by indivdual location
In the upper section of the document there is:
=NL("sheets","Location","Code","Code",Options!$G$10)
This is clearly what triggers the new sheet creation (and my searches on here confirm this)
If I delete the cell entirely the report won't run (no surprise there) so I know I have to adjust this somehow but I haven't an idea which way to go.
How do I stop the mutiple sheets?
I appreciate your help and patience.
Thanks.
Aggerz.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Aggerz,
So I'm assuming you have functions on the sheet which are depending on the location code existing in the cell where the NL(Sheets) formula is. You have several options here. You could just type a * in that cell which is a filter for all values. Then the formulas depending on that cell would just filter for all location codes. You could also filter for specific location codes like this: Location1|Location2|Location3.
Another option would be to change the NL(Sheets) to an NL(Rows=x) formula. The x tells Jet how many rows to replicate for each location code. I can't tell you how many you would need because it depends on how many rows below the NL(Sheets) formula there are in the report. If you count those, you will know what to put for x and the formula would look something like this:=NL("Rows=10","Location","Code","Code",Options!$G$10)
Another option would be to go through the formula(s) which depend on the location code being returned by the NL(Sheets) function and just delete the filter for location code from the formulas. Does one of these things help?
Regards,
Hughes -
Jet Reports Historic Posts Perfect. Thank you. Got it to do what I wanted, compiled the data I needed = Sucess!
I've been reading on here for a little while without posting and so thank you for all the forum contributions its really helped a lot.
Aggerz.
Please sign in to leave a comment.