BCA and "No Data to Fetch" 1

[khansen97]

In BCA I have set up reports to run and then distribute through email. I have found that when a report runs and no data is returned, the report still gets emailed out. I want it so that it DOES NOT email out, but still makes a record of the report running successfully, possibly in a log file.

I thought about a VBA macro, but I really am not too familaiar with BCA. Can I set up a VBA macro to check for data before it emails?

Does anybody have any other suggestions?

thanks

 

[skrandel]

You must be using a script for doing the email. So you are using VBA.

What you can do is use the condition at the bottom of the dialog box to check a report variable's value before the script gets executed.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com