Reporting only totals 1

[keithm2008]

I have a reports that has two groups. Group1 is mgr and group2 is cust. I already have the details suppressed as requested in the specs, so cust is effectively the detail section. Now, they want the same report with the group2 (cust) suppressed. When I suppress and/or hide this section I lose most of the group2 subtotals. I say *most* because just one of the columns in the group1 is a simple sum of a database field (amt billed) and is not affected by the suppression. The other two are data from subreports(a/r billing and tkt amt). Can anyone explain how I can get this group2 data back and displayed in the report? I have included some of the existing report below to help explain what I already have.
Mgr Cust Amt A/R Tkt Real Staff
Billed Billing Amt Pct Rev
GH1 JVC
GF2a DenX 3253 300 3253
GF2b 9.22 300
GF2a ALLS 6100 3150 6100
GF2b 51.64 3150
GF1 JVC 9353 3350 9353 3350

 

[IanWaterman]

When you suppress group the SR does not eval.

I assume you are passing data from SR using a shared Variable.

Just make group a small as possible and check underlay following sections Minimise the SR too. But do not suppress group.

This will allow SR to execute but have no visible impact on Report layout.

Ian

 

[keithm2008]

Thanks, Ian, for the prompt reply. I think that will work for viewing online and printing, but I know the user wants to export the report into Excel for further manipulation. I think I am going to have to approach this from a different angle.

keith

 

[IanWaterman]

The other way to do this is replace action of subreport with a command or a view.

You could take the SQL from SR and make into a coomand and then just link it into main report using same links as you used for SR.

Ian

 

[keithm2008]

Ian, unfortunately SQL is not available to me. The database I am accessing is a Btrieve file structure and SQL is not supported.

 

[lbass]

Depending upon your CR version, you could pass the results from the subs in shared variables, and then suppress all sections within the subreport. Suppress all other fields within the group section, but do not suppress the group itself. Instead format the section to "suppress blank section". Also format the subreport to "suppress blank subreport", but do not suppress the subreport object itself.

Still not sure whether exporting will work.

Otherwise, you might try eliminating the subs and bringing the tables directly into the report. You could then use running totals to get around any duplicate data.

-LB