Is there a way to accumulate a crosstab

rbuser

Hi,

I was tring to have a crosstab used a the summary. The detail traverses a
table and I have a crosstab there that calculates the values for each
record.
I want the crosstab in the summary to have the sum of all the values of all
the records.

I think I could do this if I could figure out how to stop the crosstab from
doing a reset. May be I could create a desendent of TppMatrix for the
purpose. I can't make a sql that is the values for the records I want.
Which records are included depends on a very complicated procedure.

Any suggestion?

Thanks,
Joseph Gordon

nicocizik

Joseph,

Try using a SubReport to display the summerized data. You shouldn't need
another crosstab to display this information.

--

rbuser

Hi,

I guess I don't undrstand. I have a report that does:

Customer 1 Name

CrossTab of Months By Fund

Customer 2 Name

CrossTab of Months By Fund

. . .

Customer n Name

CrossTab of Months By Fund


CrossTab of Months By Fund summerising the other crosstables.


I was hoping I could use 2 cross tabs one in detail and one in
the summary and that this would traverse that data only once.

You suggest I put in a sub report to get the summary. How do
I do that? Do I put in a crosstab in the sub report? I tried this
and all I get I another set of crosstabs instead of a single one
with the sum.

If I could change the crosstabs to have a desendent that did not
reset the values between customers and had a routine I could
call to 'add' in the records I could do it. In what procedure does
the crosstabs initialize the matrix to zero and where does it traverse
the table?

Thanks,
Joseph Gordon

nicocizik

Hi Joseph,

Ok, I didn't realize where you were placing your crosstabs. The easiest way
to do this would be to create a summary dataset separate from your initial
dataset and connect it to a subreport. Then, in the summary band of the
subreport, print the summary data that you want to show that relates to the
crosstab information. Be sure to leave the detail band of the subreport
empty.

--