Asked by:
SSRS Tab Name with No data

Question
-
Hi all,
I have an issue- I have this report which consists of 4 tables.
Each one I have added a page break and gone onto Tablix Member and changed page name to what I want the tabs to be called on Excel when exported. This works fine when each Table has DATA inside it.
However when there is NO DATA in one of the tables, it just takes the name of the previous tab and calls it (2)-as you can see below:
How do I make sure, even if there is NO DATA for a particular tab it still gives me the name of the tab I put down under page name?
Many thanks
All replies
-
Hi Taz,
How have you set the value for these page names? It sees you could set them with fixed string, and they will be exported with that name? We need to know more specifically how your design was made, to offer better support.
One other suggest is , you could set some hidden textbox, use its value for the page break. This won't be changed whether there are values in the table or not.
Regards,
Lukas
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
-
-
If it were set fixed string, it should remain that string regardless whether there were data or not, right?
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
-
-
That's weird. My test works as we thought. Did you have any special setting that may be notable?
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
-
-
Just in my test, the tab name in exported excel stayed as the string I set, no matter whether there is data or not.
I'm testing with ssrs 2017.
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Proposed as answer by Lukas DreiKleinMicrosoft contingent staff Friday, November 15, 2019 7:50 AM