Summary Fields

[griffter]

Hi

I am trying to generate a report that will show the following

For all sites
Total Sites Activated
(Count of all records with a site status of 1)

Then sites for each country
Total Sites Activated
(Count of all records with a site status of 1 for this country)

I initially used a cross tab which worked fine but these reports get output as CSV files so I need to work this out manually.

Any ideas of the best way to do this?

 

[synapsevampire]

Group by the Country, drop the field in the details, right click it and select Insert->Summary and select by the Country group, and then do it again for the grand total. If you have CR8.5 or below you can do it all at once.

Now delete the field from the details, suppress the details section, and turn on the Perform Grouping on Server.

-k

 

[lbass]

You need to make a formula:

if {table.sitestatus} = 1 then 1

Then insert the summary (SUM, not count) on this at both the country group and the grand total level.

-LB