Dear Community, my scenario includes SSRS 2008R2/2012 and RDL reports

I need Excel 2010 sheets to be named; every Tablix a different sheet. The new Property PageName is perfect and works great.

But I dislike to manually type the name and I'm looking for a way to set the PageName dinamically... The Dataset name could be my solution; I use basic Tablix and just need to seek the name to set the Property.

I thought to the Custom Code. The (wrong) idea was to pass a field and retrieve the dataset name from it. No Success:

=Code.getDatasetName(Fields!myFLD.Value)

Public Function getDatasetName (byval myFLD As Field) As String
return myFLD.ParentName.ToString  'invented method
End Function

Thank in advance

pf

Hi pf,

If I understand correctly, you have several tablix in the report, and it has page break between each tablix.

As per my understanding, we need set the PageName property for each tablix manual. Since that, we have to manual type the dataset name for each tablix. If we have add page break in one tablix, we can use field value expression to display group values as sheet name in excel.
Reference: Naming Excel Worksheets

Regards,
Alisa Tang

If you have any feedback on our support, please click here.