Drilldown from Crosstab

[Former Member]

Hi Experts,

How can I show(drilldown) Details from Crosstab?

Thanks,

David

[Former Member · Accepted solution]

David,

CrossTabs do not have 'details'. They are just quick summaries of data. Drilldown only works on groups.

Debi

[Former Member · Accepted solution]

Thanks Debi.

[abhilash_kumar · Accepted solution]

Hi David,

Here are a few ways you can drill-down into a cross-tab (all of them are workarounds by the way).

The first method is using Report Parts or ‘Another Report Object’ and the second method is using an ‘OpenDoc’ URL

Both the methods need the target report (report that is opened when drilled into) to have the same groups as the Crosstab

The ‘Another Report Object’ can be setup in the following way:

• The target report needs to saved to the BusinessObjects Platform first
• Open the target report in the Crystal Report designer from the ‘Repository’
• Assuming the groups have been setup properly, click on any field in the details section and ‘Copy’ (Ctrl+C)
• Open the Report with the Crosstab
• Right-click the Summary Field on the Crosstab and go to ‘Format Field’ > Hyperlink
• Then Check ‘Another Report Object’ and click on ‘Paste’
• All the required information should be populated automatically

This is how the Data Context should look like:

“/”+GridRowColumnValue(“Customer.Country”)+”/”+ GridRowColumnValue(“Customer.Region”)+”/”+ GridRowColumnValue(“Customer.Customer Name”)

Where “Country” and “Region” are rows in the Crosstab, “Customer Name” is a column in the crosstab.

Similarly, “Country”, “Region” and “Customer Name” are groups on the target report

So, the above formula would make sure the report drills-down to the last group

The next method using ‘OpenDoc’ makes use of the opendocument URL and passes values from the Crosstab to the target report’s parameters

Here’s how we can set this up:

• The basic design of the Main report and the target report would be the same as in above, however we would need to create parameters that correspond to the groups on the target report
• In this case, we would create three parameters – Country, Region and Customer Name
• We would use these parameters as filters on the target report and our record selection formula would look like this:

{Country} = {?Country} and {Region} = {?Region} and {Customer Name} = {?Customer Name}

• We would then link the Main reports ‘Country’, ‘Region’ and ‘Customer Name’ with these parameters
• Now on the Main report Right-click the Summary Field on the Crosstab and go to ‘Format Field’ > Hyperlink
• Check the option ‘A Website on the Internet’ and click on the formula button in ‘Hyperlink information:”; the formula should be as follows:

“/OpenDocument/opendoc/openDocument.jsp?iDocID=6472&lsSCountry=”&GridRowColumnValue(“Customer.Country”)&” &lsSRegion=”&GridRowColumnValue(“Customer.Region”)&” &lsSCustomer+Name=”&GridRowColumnValue(“Customer.Customer Name”)

When any summary value is clicked in the Cross-tab, the corresponding Country, Region and Customer Name are passed as values to the parameters of the target report

Hope this helps!

-Abhilash