locheve
Technical User
- Jan 4, 2013
- 12
Hi, when creating a cross tab it is possible to create a drill down? so, if you were to click on a piece of data in the cross tab it would display the chosen data related to it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Reports - Can you create a drill down in a cross tab
- Thread starter locheve
- Start date
- Status
As far as I know this is not possible with the regular cross-tab. You can create a manual cross-tab or use an OLAP grid.
I don't know if this will be a solution for your scenario, but you can also use an Ad-hoc query with a pivot table similar to Excel pivot table. It supports details natively. If this might work here is a video, which shows the same report developed using Crystal crosstab and Ad-hoc pivot: video
Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.
I don't know if this will be a solution for your scenario, but you can also use an Ad-hoc query with a pivot table similar to Excel pivot table. It supports details natively. If this might work here is a video, which shows the same report developed using Crystal crosstab and Ad-hoc pivot: video
Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question