Drill down on columns to get different set of data

[Former Member]

Hi All,

We have a report in which the columns in each row displays the revenue. There is a group created which makes drill down enabled. But when i click on different columns in the same row the data we need to display is different. Is this possible?. Currently a drill down on any of the columns in the same row will display the same data (Based on the group)

eg: columns will display quarter wise revenue (4 columns). When we click on each quarter the data should display the details of the revenue for that quarter (details of 3 months). So for every quarter the details is supposed to be different.t

Please let us know whether this is possible in crystal report or not.

Thanks in advance

Thara

[Former Member · Accepted solution]

Did you try adding four different details sections with data for each quarter (monthwise) meaning Details a will have Jan-Feb-March,Details B will have April-May-June,Details C will have July-Aug-Sep and Details d will have Oct-Nov-Dec.

Condionally suppress them based on the quarter value.

The other way is use four subreports (on demand) where the Quarter hyperlinks will open the four different reports.

Hope this helps!!!