Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sub Reports

New Member
Posts: 13
Country: USA

Sub Reports

I have 14 sub reports in one main report.  I would like to have a grand total of all of the sub report totals but cannot seem to find a solution.  Any advise?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sub Reports

My first comment is to question why you have 14 subreports. That sounds like a report design problem. 

 

That said it would be possible to get a total of all the subreports using some very complex Visual Basic script programming.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 13
Country: USA

Re: Sub Reports

I have 14 separate reports that we generate every week.  Now, they are asking for a total of all of those reports, so I placed them into one main report as "sub-reports".  I tried creating a Union Query and got the query to work, but how do I insert the union query number into the main report?

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sub Reports

Complex custom Visual Basic script programming.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 13
Country: USA

Re: Sub Reports

I have no ieade what that is... 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sub Reports

Please check your private messages, upper right corner of the screen.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129