Share Crosstab Summaries in a Report Summary

[ClanLabCooker]

Version: 8.5
Source: read-only view

An existing report contains several crosstabs to display fiscal year receipts for agencies grouped by agency type.

How can I pass the summaries from each generated Fiscal Year column in each crosstab to the report footer to create a report summary? The crosstab is currently generating 3 fiscal year columns plus a summary column. They will soon be generating 4 fiscal year columns.

 

[rosemaryl]

Dear Clan Lab,

Well, one option would be to create another cross tab ... but without more information it is hard to know what to tell you.

The cross tabs in your report are based on the data so there should be no issue with creating a summary.

What do you want it to contain ...

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[ClanLabCooker]

Each of the crosstabs is actually in a separate subreport to control selection criteria. The crosstabs automatically create summaries of the total receipts for each agency (rows) and for each fiscal year (columns) as well as a Grand Total.

In need to capture each of the column summaries, from each subreport, and combine them into a single table summarizing the data from each subreport and providing "Grand Totals" for each fiscal year (column) and each subreport (rows).

Creating another crosstab might be the answer, but how do I get it to pull the summaries from each of the columns in each subreport?

 

[rosemaryl]

Dear Clan ...

Well, since you have separate subreports to return data for each fiscal year .. then it would seem that you need to do a subreport and use selection criteria that will grab all the data that is in the individual selection criterias ... in other words one criteria that encompasses the data.

You will actually need two crosstabs I think ... it is hard to say without seeing an example of the data the way it is and the data the way you want.


Regards,
ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762