Skip to Content
0

Drill down in crosstab report

Mar 13, 2017 at 08:50 PM

62

avatar image
Former Member

Hi experts,

I'm trying to drilldown in a crosstab and I followed Abhilash Kumar instruction but in my crosstab report I don't see any hyperlink (neither mouse pointer changes when I hove the mouse over the summary field nor I see summary field as underlined) to be able to launch the drilldown report.

To be clear instead on fields from dataset I'm using formulas to group rows and columns in crosstab and drilldown target report. Is there any workaround?

The procedure I followed is

Using ‘Another Report Object’:

  • 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 looks like:

    "/"+GridRowColumnValue("@RPRowGroup1")+"/"+GridRowColumnValue("@RPRowGroup2")+"/"+GridRowColumnValue("@RPColGroup1")+"/"+GridRowColumnValue("@RPColGroup2")

    Where “@RPRowGroup1” and “@RPRowGroup2” are rows in the Crosstab, “@RPColGroup1” and “@RPColGroup2” are columns in the crosstab.

    Similarly, all four above mentioned formulas are groups on the target report.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers