Report With Multiple Criteria Statements - Help Needed

Yes I define the type when adding it to the RDD. As soon as I added in include non nettable it crashes with the same result. Do I need to add the criteria into the report parameter query or something?

If it runs without those criteria, Iā€™d think thtat the RDL is okay. All those criteria should do is limit the data in the temp data tables (DatasourceName_GUID).

I do think you can pass the prompt values to the RDL, but inless your RDL is using them, they shouldnā€™t be an issue.

Iā€™m trying to duplicate what youā€™re doing, but I canā€™t seem to create the Criteria mappings. I should be able to do this without the RDL correct?

Yea, all the criteria mapping I have done up to this point is here on the RDD:

Okay, this can be thrown out as a witch hunt. I just rebuilt it again and did all three criteria at once and it works exactly as intended. Thank you @cfinley and @ckrusen for helping with this!! Sorry for the trouble.

1 Like

I think the order of building the BAQ and RDD is important. If you add a field to the BAQ after the RDD is built, it might have issues finding that new field.

While I was testing, I couldnā€™t even get it tp add any mappings
:man_shrugging: