Drilldown o cross tab

[neskin]

Hi,
i am wondering if i can do drilldown on crosstab in crystal XI

Regards,
nat

 

[lbass]

What are you trying to do? I think you would have to create a manual crosstab to do this.

-LB

 

[neskin]

The datasource is oracle stored procedure.
the sp returns already rows grouped by id and summ fields.in cross tab id used as columns and summ fields as summarized fileds (max value) .The user wants drill down by id for example click on id 1 and see extra info

id 1 2 3 4 .....

10 10 15 70
12 45 67 88


then click on 1

datetime field location
1/1 2006 a
2/5 2006 b
....

maybe subreport is a option or hyperlink

thanks in advance
Nat

 

[Madawc]

As far as I know, you can't 'click down' on a crosstab, which is a complete thing in itself. As lbass said, you need a mock-crosstab or manual crosstab. This is a set of running totals that look like a crosstab, but you have to define them all yourself, rather tediously. (Copying them to a dummy report, changing the name and copying back is a dodge for speeding the process.)

If your mock-crosstab totals are at group level and you have suppressed detail lines, you'll get something that appears to be a crosstab you can drill down on.

All of this is based on my knowledge of Crystal 10. Maybe 11 allows something more, but no one has mentioned anything.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

To get a different display for each column, I think you would have to use a manual crosstab where you use on-demand subreports for each column subtotal.

-LB

 

[neskin]

thank you guys for ideas the columns are not static. I should mention at the begining i also have a chart and client does 't mind to drill down on chart.It is changes of id and showing two values , two bars for one id .i know if it is only one value you can drill down using group chart.can I still drill down if two values(advanced chart).
Thank you