Advanced BAQ Reports: is it possible to use a report criteria (BAQ parameter) in a subquery calculation?

Epicor ERP 10
,
1

We are on the cloud. I’ve designed a fairly complex BAQ (two subqueries, lots of calculations, BAQ parameters used as table criteria as well as in the calculations - fiscal year and period, for example). The BAQ itself runs fine and gives me the expected data.

I used the BAQ in a new RDD, added my parameters as criteria in the RDD and created a report/report style. I can get the report to run, but my subquery that uses the parameter (both as table criteria and in the calculations) won’t output any data. It doesn’t error, just outputs blank cells. Other tables in the query that don’t use the parameter display just fine.

I feel like I’m missing a step. Can anyone help me?

Thanks!

2

@LauraPearce Have you added the parameter here?

image
image317×626 54.1 KB

3

No I didn’t! I assumed that the report creation step from the report style accomplished the tie to the parameter. Do I just need to add the parameter there, or do I need to tie it in elsewhere in the .rdl (like the data set query)?

4

Honestly, it’s really hard to say without knowing much about your report or how it’s set up. But you probably will need the parameter in the query, so add it in and try to run it.