Change the names of the tabs in excel from ssrs

Question

I have an ssrs that contains some tables in seperated sheets in excel. When one report is empty, the tab take the name from the previous tab.

The names are daclared in the tablix properties in 'PageName'

Answer 1

You can use a page break at start for all matrices except the first one.

If you want to avoid empty sheets, set the matrix visibility expression to something like

= CountRows("DataSet2")=0