Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass multiple values from subreport to main report to be used in a different subreport?

Status
Not open for further replies.

nicmcd77

Technical User
Oct 11, 2016
17
US
Hi all, I am using CR2008 and am lost. The first issue, is that I have a subreport that may have 1 or many values (Lot Number). I created this variable in the subreport and have it in the report footer

Lot Number subreport
WhilePrintingRecords;
shared stringvar VNteardown;
VNteardown:= {F4111.ILLOTN}

And this in the main report:
shared stringvar VNteardown;
VNteardown

I should be getting 3 values back in the main report but am only seeing 1 value. How do I change the formulas for my variables as sometimes it could be 1 lot number or multiple?

The second question is. I then need those Lot Numbers passed to the main report to be used in a different subreport. Is that even possible? I can pass the 1 value I'm getting back right now to a different subreport but wasn't sure if I could pass multiple? Please help!!
 
You need to use a Shared Stringvar array with 3 elements

Your variable is being overwritten and will only hold the last lot number found.

Please use crystal help or google use as I do not have enough time to explain in detail. Happy to review your code once you come up with a plan.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top