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 Mike Lewis 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

Status
Not open for further replies.

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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top