Grand Totals for Subreport

[bpvsc]

Greetings,
I have researched as much as possible for a solution to my dilema and do not see anything relative so I am posting for the pros....

I am trying to calculate grand totals from a sub report.
I have a report with a subreport retreiving data from a different data source:
Main Report = AS400
Linked Sub report = Different data source. A reference table for Options
The link is PKOPT. My report calcs are correct at the group level -PKOPT-
(?Pm-Sum of @Dozens}*{IXOPTN00.OPSLTM}
on the subreport but I want a grand total of all op codes that are relative from the subreport to the main report which is determined by date parameter. I have tried an additional sub report with the same link and using a grand total. My total still reflects the join of the 2 reports fields PKOPT = PKOPT at the group level

Any suggestions?

 

[synapsevampire]

Create a formula using a shared variable to return to the main report.

In the subreport, create the following formula:

shared numbervar SubNum:=SubNum+((?Pm-Sum of @Dozens}*{IXOPTN00.OPSLTM})

Now in the main report AFTER the subreport has run, you can use that variable, as in:

shared numbervar SubNum;
"The subreport returned: "+ totext(Subnum,0,"")

You can use it in calcs or whatever.

Hope this helped you to understand the basics, the help files cover this pretty well, as do many posts here.

-k

 

[crystalreporting]

Could you add a new subreport to the group footer, and link it to the date range in your main report. That way it would total for all Options, for the selected date range.

Peter Shirley

http://www.linkcorp.com

 

[crystalreporting]

Whoops - in the above post, swap report footer for group footer!

Peter Shirley

http://www.linkcorp.com

 

[synapsevampire]

Yep. Providing by Date Range you mean to say a Date Range Parameter.

You could place it anywhere if you're just going to leverage the Parameter.

When you set up the link, select the parameter from the main report, and then the field from the subreport.

-k

 

[bpvsc]

Thanks to all -

I used:
shared numbervar SubNum:=SubNum+((?Pm-Sum of @Dozens}*{IXOPTN00.OPSLTM})

Now in the main report AFTER the subreport has run, you can use that variable, as in:

shared numbervar SubNum;
=======
I was using a shared var but trying to create another subreport for the inital calc. Putting it in the 1st one was the trick.
Again Thanks