I have a report with an RDD that is fed by a BAQ (not a traditional BAQ report) to list open orders. This can be filtered by Sales Person, Account Rep, and Customer. In the RDL I set the Excel Sheet Title to the Customer Name for that Sheet. When run for large sets of data the first sheet will always have the incorrect Customer Name. There doesn’t seem to be a reason for which Customer Name it picks it’s just one from later on. Could my BAQ data sort happen after the first Excel sheet is named? Is there a way around this?
It’s been a while since I built an RDL that outputs to Excel with multiple tabs. I believe I used page breaks to separate them into different tabs and there was some field that would determine the tab name. Are users running the report and exporting to Excel or did you do something custom?
1 Like
What are your Groups? What happens if you take the First out? Do you have a value in the InitialPage property of the report?
Where do I find the InitialPage property? That sounds promising.
My guess would be under the Report Properties.
Actually I found it I was just being blind…
1 Like
I’m assuming that you are breaking on the Customer_Name1 group? Why is that not the field you have in the PageName?
I think the group name got messed up at some point it is the same field.
Fun thing is it works fine in our dev environment and doesn’t work in Production.
Initial Page name changed nothing unfortunately.
2 Likes
I am just going to hide now.
The BAQ sort was missing in Production.
3 Likes