Starting a sub-report from row label of cross table

[Former Member]

<p><strong><font face="arial,helvetica,sans-serif" size="1">Hello I am having a cross table on my report looking something like this:</font></strong></p><p><strong><font face="Arial" size="1"> jan feb mar total</font></strong></p><p><strong><font face="Arial" size="1">aaaaaa 1 2 4 7</font></strong></p><p><strong><font face="Arial" size="1">bbbbbb 0 3 3 6</font></strong></p><p><strong></strong></p><p><strong><font face="Arial" size="1">I would like to start a sub-report by clicking on &#39;aaaaaa&#39;</font></strong></p><p><strong><font face="Arial" size="1">Can that be done? and how do I do it.</font></strong></p>

[Former Member · Accepted solution]

<p>What are you trying to achieve ,You can create On-Demand subreport which will create a link and open sub-report .Are you planning to create a Linked subreport or unlinked subreport.</p><p>Rahul</p>

[Former Member · Accepted solution]

Rahul,Â

What I am trying to achieve, is to have a cross-tab report as shown and to show details of the selected invoice after clicking on the department name. A kind of drill-down idea from within my cross-tab.

HansL

[Former Member · Accepted solution]

HiÂ

I think you can create a Mock Cross Tab Report instead of Cross Tab Report and then use the DrillDownGroupLevel  function so that when the user clicks on the Department Name the Details for Invoice are displayed.

So you have to check for at Group Level *DrillDownGroupLevel > 1 *and in details section which will be for Invoice Details *DrillDownGroupLevel = 0 *

To enter the formulas right click Section Expert in the Group Section and Details Section and the Clink the formula button on Supress(No Drill-Down) and paste the formulas.

Thanks

Rahul