PDA

View Full Version : Re: How to do Sub reports with Shared variables.



Peter Donovan
22-May-2005, 05:14 PM
Hi To anyone searching this topic:

Doug McBrierty and I had the same problem and the download fix from Crystal
v7 didn't fix the problem, but afterwards we hit the solution:
You have to drop the subreport formula into the subreport total so it's
executed/evaluated. Then the totals returning to the main report aren't
zero.
We surpressed the subreport footer formulas so they wouldn't show.
Regards,
Peter Donovan
www.SonataSoftware.us



"tbrannen" <tbrannen@ate.net> wrote in message
news:C2F8E58C1F7D4A4CB525AC96D503B58E0CE3E7@bunyip .abacus-labs.com...
> Greetings All,
>
> I downloaded some sample reports from Crystal but they don't show HOW to
> pass the shared variables. Well, I'm sure the example has it in there
> somewhere, but I am too new at this to find it. 'Help' is no help either.
> Is
> there a kind hearted person out there who will share this knowledge with
> me?
> Please see simplified example below of what I am trying to do. (the
> example
> may be wrapped)
>
> Lead Status Report
> Lead No Lead Date Salesman Job Total Sold Date
> 001 01/01/03 Smith 100.00 01/05/03
> 003 01/02/03 Jones 125.00 01/06/03
> =====
> 225.00
>
> Job Total column is combined total of many JobCost child records
> Sold Date column is found in Status child records using the Lead No and
> Status of "SOLD" from all Status records for this Lead No. There are
> usually many Status records for a Lead, but only one 'SOLD' status.
> Looks like a subeport for the status and for the amount. But I can't get
> it to work.
>
>
> Thanks,
>
> Tod Brannen
>
>