Modify the default name of the Excel sheet in SSRS

  • Hi all!

    I have been looking for this topics in the forum. It's true that exists several posts with the same problem. But I have thought that the are too old for re-open them.
    So, I am sorry if this is not the exact way to write this post.

    I have a reporting services whit several sheets in the excel. I wan to change the default name of them ("Sheet1", "Sheet2", ...) for a "personalize" name.

    I have a 2012 version of SSRS .

    Could we do that? Is it impossible in SSRS or is there other newer version to do that?

    Regards
    And sorry again if it was a better option to re-open a very old post!::doze:

  • On your tablix, set the Page Name Property, in the Properties Pane, to the Value/Expression you want.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Thom A - Friday, March 10, 2017 3:53 AM

    On your tablix, set the Page Name Property, in the Properties Pane, to the Value/Expression you want.

    Thank you for the information.

    Finally I have found the microsoft web help Pagination in Reporting Services (Report Builder and SSRS).

    But I don't understand the meaning of this:

    Page Breaks and Page Names

    A report might be more readable and its data easier to audit and export when the report has page names. Reporting Services provides properties for reports and tablix data regions (table, matrix, and list), groups, and rectangles in the report to control pagination, reset page numbers, and provide new report page names on page breaks. These features can enhance reports regardless of the format in which reports are rendered, but are especially useful when exporting reports to Excel workbooks.

    The InitialPageName property provides the initial page name of the report. If your report does not include page names for page breaks, then the initial page name is used for all the new pages created by page breaks. It is not required to use an initial page name.

    A rendered report can provide a new page name for the new page that a page break causes. To provide the page name, you set the PageName property of a table, matrix, list, group, or rectangle. It is not required that you specify page names on breaks. If you do not, the value of InitialPageName is used instead. If InitialPageName is also blank, the new page has no name.

    Tablix data regions (table, matrix, and list), groups, and rectangles support page breaks.

    Must I have to put a value in a determined column in properties or I have to add a function in the parameters?

    Thank you!!

  • It all depends on what your page breaking on. If it's specific places, undefined by data, then just need to enter a value. This can be an expression, for example, say you want it to be today's date in a specific format:
    ="Sales - " & format(today(),"yyyy, MMMM dd")This would name the sheet "Sales - 2017, March 10".

    If it's a group, and you want it to be the name of the group, then you would use an expression that returns the value of your group field:
    =Fields!YourGroupField.ValueAnd, of course, you can combine the two.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply