Crystal XI Subreport Not processing when hiding section

[ttheobal]

My Manager wants a report that is delivered in an Excel Spreadsheet. The business requirements of the report meant that I needed to use several sub reports to collect the data required (due to re-cursive joins being required).

When I export the report to Excel Data Only, the subreport fields are places in column A of the next several rows, when I want all the data on one row.

My work around was to use shared variables, and create another section for the subreports and then hide that section. Problem is, when I hide the other section, then the report doesn't calculate the sub report, and the fields containing the shared variables remain blank.

Any suggestions?

 

[lbass]

Note that you should be using forum149.

Instead of hiding the subreports, format each subreport (format->subreport->subreport tab) to "suppress blank subreport}. Also suppress all sections WITHIN each subreport, and finally, you can go to the section expert->section sub is in and check "suppress blank section".

The shared variables will still process even though the subs no longer appear. Note that neither the section the subs are located in nor the subs themselves can be suppressed or hidden.

-LB