On-demand subreport that displays on same page?

[Jerrycurl]

I would like the user to be able to click on a group heading to show/hide the details section for that group. The problem is that when I configure the details section for drill-down, the drilled-down subreport appears on it's own page. I would like it to appear within the current page, shifting the data below it down. Is this not possible?

 

[lbass]

One approach might be to add the details in a subreport which is linked to the group header and placed in the group header. In the main report, create a boolean parameter {?show details} and set the default to "false". In the main report, go to format->subreport->Uncheck "can grow" but in the x+2 formula area for "can grow" place:

{?show details} = true

Make the subreport small so that no details show when the parameter is false. The subreport will be populated when you first run the report, based on the parameter selection. If the user refreshes, he/she can choose to see the details or not.

-LB

 

[Jerrycurl]

But that would show the subreport for everyone. I only want the subreport to be visible for those group headings that the user clicks on.

 

[lbass]

You could also add a parameter for the group field to the conditional "can grow" formula, as in:

{?show details} = true and
{table.customerID} = {?custID}

...where {?custID} could be a multiple value parameter (or a distinct parameter) and {table.customerID} is the group field.

You could, of course, also do something like this without a subreport, where you conditionally suppress the detail section using the same parameters and the same formula.

-LB

 

[GJParker]

Crystal doesn't support the functionality you require, when you drill down into a report the details will always display on a seperate page.



Gary Parker
MIS Data Analyst
Manchester, England