Can drilldown and sections be done in a Cross Tab??

[johnniechan]

Hi,

I'm trying to make a report using Crystal 9, which shows activity over time (last x months, by month) data eg:-

------|1/03|2/03|3/03|.....
----------------------.....
TeamA | 0 | 12 | 11 |
----------------------.....
TeamB | 0 | 10 | 13 |.....
----------------------.....

I would like to be able to drilldown to see activity for each member of the team and then also each client for each member.
I've down a similar report which didn't have the breakdown by month (thus not needing a crosstab).

Does anyone have any ideas on how this could be done? - if indeed it is at all possible? - I'm tending to think perhaps I need to use subreports... Any ideas?

Thanks in advance
JC

 

[kenhamady]

Two options. You could create a manual cross-tab which would allow you to drill down on any row, but you would get the same thing for every cell in that row. Manual cross-tabs are described in faq149-243.

Another option is to put an an on-demand subreport under each column of the manual cross-tab. That allows you to do a different drill-down on each 'cell'.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[checkai]

How can I insert a sub report link into each row of my cross tab report?

 

[synapsevampire]

If you use a manual crosstab, then the subreport would go into the crosstab grouping.

-k

 

[checkai]

I don't want to create the manual cross tab...the first reply made it sound like you could simply create a subreport and have it link to each row of data...possible?

 

[kenhamady]

Create a linked subreprot that links to the group field, and then make it an "on-demand" subreport. Because it is linked to the group field it will be different for each row. You cand also place several of these side by side, and make each slightly different, so that the drill-down on each column is different.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com