I added an additional calculated field into the existing BAQ that is used in a BAQ Report. Will this automatically be brought into the RDD to add that into the report builder by adding it to the report query? I am trying to not have to re-create a new BAQ Report ID or Report Style whenever just ad…

The sync data set button in Report Style Maintenance seems to work well for BAQ Reports, and clicking it should update the data set query in the rdl file to match your BAQ. I’ve noticed it doesn’t work for styles other than the original ‘Standard -SSRS’ style.

Yes, it is for a different style other than the ‘Standard-SSRS’ style. In those instances, did you simply create a new Report Style?

I would highly recommend never using the Sync Dataset button, for any report. It will cause less problems to add the fields manually into the SSRS report. As to answer you question @cchang , if you created a RDD BAQ Report, the only other place you should have to add the field is inside of the SSRS …

DO NOT CLICK THE SYNC BUTTON EVER THAT BUTTON IS THE DEVIL!!! Never not ever nope nope

I’m not sure if creating a new style would work since you would have to copy one of the old styles in order to create it, which may pull in the old rdd too, but I’m not sure. Whenever I had this issue I manually edited the data set query on the rdl file to include the new baq fields.

[image] RDD SSRS Adding a UD table, Sync Dataset? ERP 10 DO NOT EVER EVER EVER EVER …EVER Click Sync Data Set… Seriously Sync Dataset is evil… and should not exist. CC: @hkeric.wci

The only time it’s been useful for me is in this scenario when you have a BAQ report and add a new field to the BAQ, and just the Standard - SSRS report style. [image] Sync Dataset for BAQ Reports ERP 10 If I did not go to the RDL of the BAQRpt and add changes, or calcula…

[image] Asz0ka: manually edited the data set query on the rdl file to include the new baq fields. I was going to do this by manually editing the data set query in the report but wasn’t sure it would pick up the additional field automatically in the updated rdd.

I think all you have to do is save the BAQ with the new field in order for it to be in the RDD and you can add it to the query, but I don’t quite remember.

BAQ Report - Add additional field to RDD

Epicor ERP 10

josecgomez (Jose C Gomez) February 18, 2021, 6:20pm 7

Topic		Replies	Views
BAQ reports: Adding more BAQs to the RDD? Epicor ERP 10 e10 , reports , baq-reports	9	3074	May 19, 2020
Sync Dataset for BAQ Reports Epicor ERP 10 e10 , report	8	2649	September 16, 2020
Update BAQ Report Query? Epicor ERP 10 e10 , baq , ssrs , reports	10	4343	April 5, 2019
Adding new field from BAQ to SSRS Epicor ERP 10 ssrs	7	1878	February 4, 2021
Update Report Data Definition After Updating Underlying BAQs Kinetic ERP e10 , baq , rdd	2	507	November 8, 2023

BAQ Report - Add additional field to RDD

Related topics