Drill Down in CrossTab???

[veronic]

I have a crosstab which show number of projects and amount for different departments by Project Status. Looks like:

Dep1 Dep2 dep3

Open $5000 $ 20 $0.00
7 2 0

On Hold $ 800 $0 $500
8 0 4..etc

My question:
I need to be able to click on number and get to detail report which will show info about each project..
Can I do this??

 

[synapsevampire]

Not using a conventional cross-tab, however you might create a manual cross-tab, and then when they drill into a group, have the appropriate underlying data.

Keep in mind that Crystal insn't an OLAP interface, so drill down means drilling into a group, not a number/data point.

-k

 

[lbass]

If you want to drilldown on a "cell" in a manual crosstab, you could insert a subreport in the group header or footer for each column that has a record selection formula limited to that column value, e.g., {table.dept} = "Dep1". You can format the subreport to be "on-demand" and use a formula as the subreport caption which is a text version of the summary for that group, e.g.:

totext(sum({table.amt},table.group}))

This text version of the summary becomes the link to the subreport that shows the elements contributing to that summary.

-LB