I am using Crystal Reports XI.

Ok, so I have a total in my main report, and a total in a subreport. (Nothing in the subreport except the total.) The main report total is scrapped parts, the subreport total is total parts made (including scrap), so I want to show what percentage of total parts made is scrap. Can you tell me how to do this simply, as I am thick.

How do I create a shared variable?

How do I assign the total in the subreport to the shared variable?

Thanks for this, haven't got it working yet though. I have created a formula in the subreport that is "shared numbervar total_made := {ProductionHistory.Qty} and this will show the correct qty but if I create a formula (in the subreport) that is just "shared numbervar total_made" I just get a load of zeros? (0.00)

thanks, I figured out that the formula that was showing the display wouldn't work unless the formula that had the assignment was actually inserted into the report.

Now though, I can't get 'shared variable total_made;' to show in the main report? That's exactly the formula I'm using.

hmmm, it definitely isn't though. If I just insert into the subreport the formula 'Display' which is:

shared numbervar total_made;
total_made;

I just get '0.00' in the preview. Noticeably I get the same amount of '0.00's as I get the correct amount (i.e. 223,355) if I insert the formula 'Variable':

shared numbervar total_made := Sum ({Productionhistory.Qty});

So it seems to be picking up the data but not showing it??? i.e. both 'Variable' and 'Display' give me 8 pages of data but the one shows me 223,355, and the other 0.00?



Edited by MrCastalum - 16 Mar 2010 at 11:36pm