Multiple detals sections in different parts of report? 1

[Scroller52]

Hi,

I'm using CR XI release 2 on a SQL server.

I have a subreport that is being grouped by Investor, Type and Entity. The data also types of transactions (Cash, Loan, Fees, etc.), their amounts and the date of the transaction.

Is it possible to show the details (by date) for 1 transaction, then have the report show the sum by Investor, Type and Entity, and then another transaction by date after that?

That is where I am stuck at right now. I cannot add a details section after the group footer sections where i have the sum of other transactions.

Here is a sample of the dataset that I am working with:

Investor Type Entity Date Cash Loan Distributions
Tom A Fund 1 2/1/11 10 0 0
Tom A Fund 1 3/1/11 0 10 0
Tom A Fund 1 4/1/11 30 50 30
Tom A Fund 1 6/1/11 10 20 40

So for example, the report for Tom - Type A - Fund 1, the report should read:

Details > Cash
2/1/11 10
4/1/11 30
6/1/11 10

Group Footer>
Loan 80

Details 2> Distributions
4/1/11 30
6/1/11 40


Any help is greatly appreciated. I'm starting to think this report design is not possible in CR.

 

[lbass]

You could add a separate crosstab for each of cash and distributions, where you use date as the row field and sum of cash (or distibrutions) as the summary field. These would be placed in the entity group footer, along with the summary for loans. You can remove the grid on the crosstabs and suppress/change the labels as you wish.

-LB

 

[Scroller52]

much thanks lbass. that solution worked perfectly!