I have a report and a subreport within it. I had to place the subreport in a detailsB section because I want it to repeat it for every detail in the main report. That is working. But I want to pass a value from the detailsA in main report to subreport. I created a shared variable, but it isn't populating I only get 0. Just to see if the variable was working at all I changed it to another value in the main report(from the main report group header) and it worked. The report is for bills of materials and their components. It is first grouped by bill number then det A is populated with that bill's components. The subreport is the same setup but pulls the components of the DetA components. This is kinda how it looks:
Parameter-qty to produce= 100
grp header - item# info qtyperbill qtyreq qtyonhand
detA - 02124196 candleA 10 1000 50
detB (subreport) wax .25 250 100
The field that won't populate is 250. I am trying to share the qtyreq (1000) with the subreport and use it to calculate 250 (1000 X 0.25). But all I get is zero. I have tried placing the shared variable field all over the main report and it doesn't help. Is it because I am trying to share a value from the details? Or because I have put the subreport in the details?
Thanks in advance for any advice,
Sunny
Crystal 8.5, SQL db, MAS 3.71
Parameter-qty to produce= 100
grp header - item# info qtyperbill qtyreq qtyonhand
detA - 02124196 candleA 10 1000 50
detB (subreport) wax .25 250 100
The field that won't populate is 250. I am trying to share the qtyreq (1000) with the subreport and use it to calculate 250 (1000 X 0.25). But all I get is zero. I have tried placing the shared variable field all over the main report and it doesn't help. Is it because I am trying to share a value from the details? Or because I have put the subreport in the details?
Thanks in advance for any advice,
Sunny
Crystal 8.5, SQL db, MAS 3.71