Report With Multiple Criteria Statements - Help Needed

Epicor ERP 10
,
1

I have created an RDD using a BAQ and added a criteria set with three mandatory prompts. The first of these prompts show up automatically. How do I get the other two to show? All three of them are set to visible and have been linked to parameters within the BAQ. Thanks for the help!

image

image
image804×384 11.2 KB

2

Did you complete this step after adding the parameters

  • When you initially create the RDD with the BAQ inside of it, there should be entries in the below screen assuming you have parameters inside of your BAQ. Click the checkboxes on all the parameters you want to show on the print screen and select the control type. This will automatically create the Filter or Prompt depending on what you wanted. Click the big button and the parameters will show on your report.

image
image908×131 4.68 KB

3

Missed a step! Thanks again Chance!

1 Like
4

@cfinley,

I’m getting the following error now that those parameters are showing. Any ideas on what is causing this?

image
image1721×338 15.3 KB

5

Looks unrelated. “Query execution failed for dataset ‘StockStatusReserve’”

6

That’s extremely weird. If I run the baq it works just fine, and that report worked fine until I added those last two parameters. Maybe its something to do with formatting or I need to resync the dataset.

7

That error usually means something is wrong in your ssrs query

8

Could this be caused by me adding those last two criteria after setting up the report?

9

I mean its Epicor, but im still guessing it didn’t.

That field is in your SSRS query based on your error, so does it exist in your BAQ?

10

What field specifically? Im not seeing what field its asking about in the error.

11

Its complaining about that field. Is that in your BAQ or your SSRS dataset query?

12

OH! That’s the name of the BAQ as shown in the RDD.

image

I assume then it’s failing for the dataset itself.

13

Wow. I read that error wrong… time for another cup of coffee!

14

@ckrusen,
Any ideas on why this report has gone belly up?

15

So I had to delete the rdd and report and start from scratch but its back to working with the parameter of just the date field. How do I go about adding in two more parameters without breaking it this time?

16

Does it return to working when you remove those two new criteria prompts? If so, add them back in one at a time.

17

And are IncludeNonNetable and IncludeNonStock Boolean fields in your BAQ?

If so, that criteria would limit it to records that are Netable xor NonNettable (xor being exclusive, meaning you can’t have both)

18

Hey I want these parameters to be true false bit operators, but in the baq it says yes/no format should that be a 1/0 format instead?

19

@ckrusen,
Those boolean fields go into a calculated field that then determines whether or not those fields go to the final report. Kinda like what you did in another form post I saw.

1 Like
20

It’s been a while since I’ve played with RDD Criteria. Do you specify the type when defining it? If the prompt is a checkbox, then I’m pretty sure E10 will handle it okay, regardless of true/false, yes/no, or 1/0

BTW - In college I was taught the true was -1. Later the more general definitions of:

false = 0
true = !false (anything not false: 1, 10, -1, etc…)