Help on a report: multi column report

[sebsol]

Hello,

I've been playing with CR 9, I've done some nice things but I realize that I don't know how to create the report that I need.

Watch out, I think I'm asking a lot ;-)

Here's an example of the kind of report I want to create:
Rows of Account Number grouped by Group name (both fields come from 2 tables)
Columns of budget (field from a table), what has been paid (sum of expenses from a table with a formula), what hasn't been paid (sum of expenses from a table with a formula), the money that is left
(budget-what has been paid)
Budget Paid Engaged Left
Consultancy
622500 10000 $ 5400 $ 600 $ 4000 $
622600 12000 $ 200 $ 11800 $ 0 $
Total 22000 $ 5600 $ 12400 $ 18000 $
Communications
622500 12000 $ 400 $ 600 $ 11000 $
622600 15000 $ 200 $ 4800 $ 10000 $
Total 27000 $ 600 $ 5400 $ 21000 $

Gd total 49000 $ 6200 $ 17800 $ 39000 $

Is that clear enough ?

Then, to make it a bit trickier, I want to drill down on the Paid and on the Engaged column to obtain the details of expenses for each column.

Do you think it's possible and do you have any tips on how to do it ?
If you have a similar report, feel free to post it ;-)

Thanks a lot.

Seb

 

[IdoMillet]

The report itself can be done using a simple CrossTab.

The drilldown functionality you are describing may be possible using OnDemand subreports (but it's not clear if you are looking for one drilldown per column or different ones from each cell under that column.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sebsol]

Thanks IdoMillet.

Indeed, I've been looking into Crosstabs at the moment, but I can't figure out how to make the columns Paid, Budget...

And I need a different drill down for each column, but the same drill down for the whole column (no drill down on the totals though)

I'm gonna look into sub reports on demand. Any help will be more than useful.

Thanks a lot.

Seb