on 03-28-2012 2:48 PM
Hi Experts,
How can I show(drilldown) Details from Crosstab?
Thanks,
David
David,
CrossTabs do not have 'details'. They are just quick summaries of data. Drilldown only works on groups.
Debi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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:
{Country} = {?Country} and {Region} = {?Region} and {Customer Name} = {?Customer Name}
“/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
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.