I created a BAQ, and an RDD and added the BAQ to that. Then I created a new report and report style, set the fields accordingly, edited the report in Report Builder, saved everything and ran it. It works great! Now, the issue is how to handle things if there are no rows returned in the BAQ. Current…

[image] jhecker: , I would like it to error out like other reports would, showing “No Records Returned” in the System Monitor. This is the way my emailed reports work. Maybe it is the method you created it? I write the BAQ, then use BAQ Report Designer to create the RDD and the Report Style. …

I did not know this was the typical behavior for an RDD with a BAQ as its data source. I am curious what others have to offer on the topic.

That could be. I could try to do it as a BAQ Report and see if that makes it work the way I am aiming for. FOLLOW UP: Yup…that worked. Thanks, @hackaphreaka !

So there is a built in functionality with BAQ reports that prevent sending an email if there is no report… but we’re saying that if you set up an RDD report with a BAQ as the data source and try to email that, it will send an empty email if there is no data returned? I still would be interested if t…

[image] dr_dan: prevent sending an email if there is no report So how do you email the report? Do you user Report routing or do you configure the report as an email then schedule it?

I have scheduled reports with the email format. I thought about configuring it using APR and then only send the email if there is data returned. But I’d have to re-do all the reports… not the end of the world. Just wondering if there was another way.

[image] dr_dan: But I’d have to re-do all the reports Just setup the routing on the report style and reschedule

[image] dr_dan: So there is a built in functionality with BAQ reports that prevent sending an email if there is no report… Maybe more happy accident than built in functionality. I think it just chokes when the query returns no records and just never gets to the emailing part of the process.

[image] Scheduled Email BAQ Report - Don't email if no data Epicor ERP 10 Its funny you bring this up. I find that if I create a BAQ report in the BAQ report designer, it fails with no records selected when there is no data. But if I create a regular report in the Report…

So what happened to the Idea… Friday is very close

Prevent Emailing Report if there are no records

Epicor ERP 10

aosemwengie1 (Alisa Osemwengie) May 2, 2024, 3:39pm 10

Topic		Replies	Views
Scheduled Email BAQ Report - Don't email if no data Epicor ERP 10 e10 , bpm , baq , ssrs , reports	14	1936	June 7, 2023
Empty reports Kinetic ERP ssrs , reports	7	1196	September 15, 2023
Scheduled BAQ Report even on no records Epicor ERP 10 ssrs , reports	8	936	February 28, 2020
BAQ Report - No Records Selected Epicor ERP 10 e10 , baq , reports	17	3659	February 3, 2022
Auto generated emails with report attachments via the System Task agent Epicor ERP 10 e10	6	849	September 15, 2020

Prevent Emailing Report if there are no records

Related topics