Tabs in Report Builder

  • Hi All,

    I currently have a report that i am creating in Report Builder using a stored procedure, the procedure includes a column with either a '1' or '2' in it. When the report is exported to excel its needs to be on two seperate tabs with the data split by the '1' or '2'.

    How do i split the report in Report Bulider?

    Thanks in advance...

  • Hi All,

    Managed to find the answer, if you create a group on the column and then go into the Group Properties you can put a page break between each group. When you export to excel a tab is created for each group.

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

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