Refresh dataset in Report builder

Epicor ERP 10
1

After creating a SSRS BAQ report using Report builder, I modified the BAQ to include an additional field. In report Builder, I added the missing query field to the dataset and pressed the Refresh Fields button. Generating the report does not produce valid data for the new field. What am I missing?

2

Are you using at least 10.1.400? If so, you can make adding new fields that were added to the BAQ into your BAQ report data source much easier by using Sync Dataset in Report Style Maintenance.

Pasted image1127×786 82.9 KB

3

If you manually add the field to the dataset, you also have to manually add the field to the query.

Pasted image1005×818 82.2 KB

4

Nathan,

Thank you. That worked perfectly. We are on 10.1.400.18.

5

Brian,

Thank you very much! Good information.