BAQ Parameters Not Working on SSRS Report

Epicor ERP 10
, ,
11

You can edit the query expression for the BAQReportResult to join the Rpt Parameter table, like:

="SELECT T1.[PartTran_TranNum],T1.[PartTran_TranDate],T1.[PartTran_TranType],T1.[PartTran_PartNum],T1.[Calculated_TranDateYearPrior], T2.Option01 "
+ " FROM dbo.[BAQReportResult_" + Parameters!TableGuid.Value + "] AS T1"
+ " JOIN dbo.[BAQReportParameter_" + Parameters!TableGuid.Value + "] AS T2 ON 1=1"

edit

Just to be clear. I had to:

  1. Add the "AS T1" to the query’s original FROM clause
  2. Add "T1." in front of the original field names in the SELECT clause
  3. Add the the JOIN ... AS T2 ON 1=1 clause
  4. Add ", T2.Option01 " (don’t forget the comma, and trailing space) to the SELECT clause
  5. Add the field to the

Now you can refer to BAQReportResults.Option01 in the tablix’s filter.

1 Like