Skip to Content
0
Former Member
Feb 26, 2009 at 07:38 PM

Variables and Arrays from main to subreport

22 Views

First of all, forgive me for my cumbersome way of explaining this.

I have report that shows monthly usage of inventory and a subreport that shows when each item was ordered. The main report is grouped by "sites", which is a formula field (@site). The subreport is grouped by location, (@POInvLoc) which is ultimately a different formula that creates the same "sites", except there is an account number associated with the site as well.

I have the reports linked together fine, except that an item could have been ordered in multiple sites. I want the subreport to only show orders for the site where the item was used. Do I need to create an array variable or just a variable? I'm having trouble creating either.

And can you pass a variable (or array) from a main report to a subreport? How do I do that?

Help!!

One more unrelated question.....I have a max date summary on the subreport to show the last date an item was ordered (for each site). If I want to show say the last 3 times an item was ordered, can I edit the formula to do so?

Thanks, Cindy