I have created a BAQ report, worked fine for the user. But then, he asked if the query could be duplicated, and modified to add a parameter to ask the user, in order to filter.
So I did create copy of the query, then in BAQ report designer I created a new report and specified the same report.rdl file in the SSRS text box. (thinking it was logic for me to use the same report ! it was the same output as the original)
well not so fast. my original rdl file got replaced by a basic rdl (when we create a new report originaly) So I lost 2 days of work !!!
I did not expect this behavior… thought to let you all know NOT to do this !!!
Comes a question then: I want to use the same report for two queries, how should I have done this originally?
Instead of adding parameters on the query you can add filters on the BAQ report itself and use just one query and one BAQ report for different purposes. You can also use Options on the BAQ report. Use case will determine whether options or filters.
Thanks (this is my second BAQ report… ) I did not know this…
Now, I have modified the query , it has different fields (removed some added some) What is the process to follow in order to make this modified query use my report rdl file.?
My first tought was to name my modified query the same name as the original, and then, manually change the dataset in the report designer.
Is this the right way? Or maybe there is a better way?