Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining 2 reports

Status
Not open for further replies.

kela97

IS-IT--Management
Jul 28, 2003
7
US
Hello all,

I have 2 reports with headers, footers and detials. I just want to put the 2 reports together into one report.

If I put them as subreports in one report, the report header gets messed up and so does the totals and subtotals.

Is it just possible to combine to standalone Crystal report so that when we press one button, both are generated back to back. The second one after the first.
 
When you say generated, do you mean to say combined into one file?

Consider right clicking the report footer of one of the reports and select insert section below.

Place the other report inside the new section as a subreport, and change the Main report header based on the subreport section firing by setting a variable.

Excuting a subreport won't alter any totals within.

-k
 
Synapsevampire,

Thanks a lot. It worked.

Cheers,
Kela
 
CR9.0 from SQL
RH
PH
GH1 - grouped by Product id
D - Lot# Quantity
GF1 - Sum of Quantity by product id
RFa - Grand Total
RFb - subreport (archived info w/ Prodid, lot, quantity)

Basically trying to combine a archived report with the current report to get total quantity by product id and then a grand total.

Can I ask for some help on this one? This is exactly what I'm currently trying to do. I've done the first 2 things you suggested.
New at this could you explain a little more about this?

From prior post on this thread...

"Main report header based on the subreport section firing by setting a variable."

Thanks!
Dave

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top