When we export the SSRS report to excel, SSRS export report with
its default sheet name e.g Sheet1, Sheet2. Below is the example.
its default sheet name e.g Sheet1, Sheet2. Below is the example.
SSRS Report
When we export the same report into excel. It will export in
Sheet1 by default.
Sheet1 by default.
Exported Excel Report
Steps to give Name to
the Sheet(s)
the Sheet(s)
1)
Go to the property of the tablix by selecting
the tablix & press F4 button
Go to the property of the tablix by selecting
the tablix & press F4 button
2)
You can see the Page Name property, Give the
name that you would to display for sheet(s) while exporting to excel
You can see the Page Name property, Give the
name that you would to display for sheet(s) while exporting to excel
3)
Now Export the report. You can see the Name of
the Page given by you.
Now Export the report. You can see the Name of
the Page given by you.
This implementation is helpful when you
export multiple sheet(s) report. It is helpful in identifying the correct
report easily.
export multiple sheet(s) report. It is helpful in identifying the correct
report easily.
————————–End of
Article——————-
Article——————-