Crystal V.10 off a Sybase database.
I’ve got 2 tables joined and am trying to get a summary total in a Group Header for one of the data items that only exists in the one of two tables. Here is a sample of the data:
Detail Table:
TableA.Fld.Actual: $100
TableA.Fld.Actual: $100
TableA.Fld.Actual: $100
Summary Table:
TableB.Fld.Actual: $300
TableB.Fld.Budget: $500
Groupings:
Ledger
Account
I’ve place the TableA.Fld.Actual & TableB.Fld.Budget in the Detail section of the report and can use the summary function to calculate the Ledger Group Totals for the TableA.Fld.Actual and place that in my Ledger Group Header. However, when I place the TableB.Fld.Budget data in the Detail section, I get multiple records (since it only exists in the Table B). I’ve tried Running Total formulas and can get the correct summary of TableB.Fld.Budget to show in the Footer, but cannot figure out how to get it in the Header along with the Budget summary.
I’ve tried a Subreport, but I already have a subreport to drill down deeper to Invoice level and cannot have a subreport within a subreport.
I thought a WhilePrintingRecords formula might do the trick but that doesn’t seem to work in the GH either.
Any thoughts on how to get this to work would be greatly appreciated…I’ve racked my brain for a few days on this last hurdle to my report. I wish the dba would have included the TableB.Fld.Budget in TableA?!?!?
Thanks
-Ed
I’ve got 2 tables joined and am trying to get a summary total in a Group Header for one of the data items that only exists in the one of two tables. Here is a sample of the data:
Detail Table:
TableA.Fld.Actual: $100
TableA.Fld.Actual: $100
TableA.Fld.Actual: $100
Summary Table:
TableB.Fld.Actual: $300
TableB.Fld.Budget: $500
Groupings:
Ledger
Account
I’ve place the TableA.Fld.Actual & TableB.Fld.Budget in the Detail section of the report and can use the summary function to calculate the Ledger Group Totals for the TableA.Fld.Actual and place that in my Ledger Group Header. However, when I place the TableB.Fld.Budget data in the Detail section, I get multiple records (since it only exists in the Table B). I’ve tried Running Total formulas and can get the correct summary of TableB.Fld.Budget to show in the Footer, but cannot figure out how to get it in the Header along with the Budget summary.
I’ve tried a Subreport, but I already have a subreport to drill down deeper to Invoice level and cannot have a subreport within a subreport.
I thought a WhilePrintingRecords formula might do the trick but that doesn’t seem to work in the GH either.
Any thoughts on how to get this to work would be greatly appreciated…I’ve racked my brain for a few days on this last hurdle to my report. I wish the dba would have included the TableB.Fld.Budget in TableA?!?!?
Thanks
-Ed