Change BAQ in Microsoft Report Builder

Epicor ERP 10
1

I have a report that I want to copy/modify. I created a new BAQ. I want to use a report that is already created (ABC.rdl) and change the BAQ associated. I’ve saved it as DEF.rdl. How do I change the associated BAQ in DEF.rdl?

2

Change the filename of ABC.rdl to DEF.rdl, and in BAQ Report Designer, Actions > Upload SSRS Report. This will pull in the report format from ABC, but it will also pull in the original BAQ and datasets from ABC.

To fix this, open Report Style. Locate your DEF BAQ Report. Click Actions > Synchronize Dataset for BAQ Report. This will replace the BAQ and dataset in the RDL with the correct data from the DEF BAQ.

Now, go back into BAQ Report Designer, Actions > Download SSRS. Now you have an RDL with the same format as ABC, but with the BAQ and datasets from DEF.

This process works, but it can be finicky. Make sure to make backups of your ABC.rdl before you rename it. Good Luck!
Nate

3

Thank you!