Running Macro - Verify records exists

[mrpauly]

Hello,

Using macros, I've automated the process to run about 50 reports passing parameters via prompts. My question is I would like to export to PDF the report only if records are found.

Is there a method to verify records exists?

Thanks - Paul

 

[griffindm]

Paul,

See thread401-165889. You can use GetDataValue to query the report. It will return an error if no rows are found. You can trap this error by setting a variable to a constant before the GetDataValue call, and then change the variable value with this call. Bypass the error by using On Error Resume Next and check the variable value after the call. If it hasn't changed from the original constant, no rows were returned.

An alternative is to replicate the report filter in a SQL query and use SQLExecute and SQLRetrieve to get a row count. In either case, just don't print or output the report if it is empty.

Hope this helps,

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

http://www.decisionsupportgroup.com

 

[Jful23]

You're welcome! I too was so relieved when I figured out this was the solution.