Display Query Summary Totals in MS Excel--Not the Details

 

Problem Statement:

How do I display only the summary totals in MS Excel and not the details information?   Can this be done with reports as well as queries?

Solution:

This can be done either via the ShowCase Query Excel Add-ins (if linking the query to an Excel sheet) or the Excel viewer within Query | Result Options.

Option 1: Using ShowCase Query Excel Add-ins.

1. Click View > Report Sections and clear Details to hide the details in the query
2. Link the query to an Excel sheet as usual, stop before creating the Query References
3. When adding the Query References, select Query Viewer data from the Category drop-down menu
4. Finish linking the query to Excel as needed.

Option 2: Using the Excel Viewer to run the query.

NOTES:

• Only the summary total will be shown in the Excel result file, and not the detail data. This only works for queries, not reports (.rpt).
• Report Writer simply sends raw query data to Excel, so, in general, it's best to use Query to move summary data into Excel, by copying the report's select statement into Query for this purpose.

1. Create the query, including break groups and summary totals
2. Click View | Report Sections and clear Details to hide the details in the query
3. Click Run | Result Options and Select Microsoft Excel  97-2003 Worksheet from the Viewer drop-down menu
4. Click the Options button and un-check the box for "Output report details only"
5. Click Tools | Options | File Output tab and un-check the box for "Output report details only"
6. 6. Run the query as usual.

For more information about query references or the viewer options, refer to other resolutions within this search or ShowCase online help (search words: QUERY REFERENCES or RESULT OPTIONS COMMAND

Ref#: 1475625