SSRS Export to Excel with tabs ( How to Sort Tabs in Specific Order)

  • I have created a report that exports to multiple tabs in excel. That is working great. That tab names are the month and year. The issue I'm having is figuring out how to order the tabs in a specific order ( i.e. Jan 2018, Feb 2018, Mar 2018 etc.) Currently they are displaying in a random order.

    Any suggestions would be greatly appreciated!!!!
    Cervello

  • Sounds like you don't have an order on your Group. Set one in the Sorting pane in the Properties window. As an example:

    Thom~

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

  • You are awesome. That worked like a charm. Thank you!!!!

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

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