Hii All,
Actually i have one query,i have to create a report which whenever its run ,the multiple sheet accordingly Item inventory posting group should be generated..What i done i create a option sheet where user put their date filter one report sheet and one sheet where i use NL(Sheet) function for multiple sheet according to inventory posting group..
Now my problem is that every sheet having a different kind of data and calculation so in my case whenever i run report sheet is generated but in design view there is only three sheet first options,REport and first sheet of firt inventory posting group..
So how and where i can define calculation and data for other sheet?? :( :cry: :?
Regards,
akhil
Date
Votes
2 comments
-
Jet Reports Historic Posts One option is to create a date filter in the options Sheet using the NP Datefilter function. Name the result using the Excel Named Range function to something like 'Date_Filter' and then use this named rage in your sheet calculation
I you are having problems with the inventory group filter try using the NL Filter function to create the Array of codes to use.
Regards
Malcolm -
Jet Reports Historic Posts Hi Akhil,
Normally the Sheets function is in the report sheet itself so that when the report is run the unique values from the sheet statements are used in all the calculations of the report. That means if you are creating sheets on inventory posting groups then the sheets result would be part of a filter so that all the data on the sheet is related to the sheet generated. I may just be missing the question, but it sounds like you have an options page, report page and sheets page which doesn't make sense to me. If you attach the report with more information we may be able to better help.
Also, you may want to take advantage of the Options page using the option keywords if you aren't already.
Creating an options window - http://kb.jetreports.com/article/AA-00864
Please sign in to leave a comment.