"No records selected" error on Dashboard Autoprint

Epicor ERP 10
1

Hello all,

I have a BAQ report (a label), that I have setup to print from a dashboard with a checkbox. It works fine. Sometimes. Other times, frequently, when I trigger the report, I get a “no records selected” error. There doesn’t seem to be any rhyme or reason to it.

image
image934×363 25.9 KB

image
image1030×261 23.9 KB

This is the BAQ. It has 2 parameters set (I originally started with only KEY1 as parameter but added KEY5 when I encountered this issue):

image
image1108×448 17.1 KB

image
image770×436 13.2 KB

I have set these fields as “Options” in the BAQ report builder. I have set my parameters on the data directive.

image
image751×496 16.8 KB

I can’t figure out what my issue is. Sometimes the report generates fine…hmmm.

Any input would be awesome. Thank you!

Alice

2

So with two parameters they must both be true.

Is the “Skip Condition when empty” box selected on either parameter?

3

Hi there,

I actually feel like I should be able to make this work with one parameter, as I had originally thought. KEY 1 is a datetime stamp that is set by BPM when a new record is added to UD20. Since they are all unique vales, am I right in thinking this should pass the dashboard line to the report every time?

1
11352×668 39.1 KB

The “skip condition” box is not checked, as there should always be a value set for KEY1.

4

What about Key5? Is its “Skip Condition…” checked?

5

Neither were checked. KEY 5 is jobNum which should also pass a value every time. But really, I dont see why I need more than one parameter. I just took off KEY 5 and am trying to troubleshoot with KEY 1 only. The report will generate for a line (or not) and then the same one wont generate if I come back 2 minutes later. Its a conundrum, as I was hoping to go live with this next week. But its wobbly.

6

Is it possible that all KEYs for the UD table need to be parameters?