Impromptu Report Query

[mrpauly]

Hi Everyone,

I want to run an Impromptu report to retrieve detailed records with (I think) a summary filter.

For example, at FedEx we would like to see detailed records for shippers who shipped 100 bills or more during the prior month. How can I do this? I added the fields I wanted then did a summary filter where count(records) >= 100. When running this query (group by Shipper) I get all information...as in Shippers who shipped more or LESS than 100.

Please help!
Paul

 

[griffindm]

Hi Paul,

You are on the right track. In the Report | Query | Filter tab click on the drop-down that says 'Detail' and select 'Summary', which is under it in the list. Then enter the filter using the Count(records) report object at the grouping level appropriate.

This should do it.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com