SQLTeam.com | Weblogs | Forums

SSRS output in two different sheet of same excel

sql2008

#1

Hello Techie.

may anyone please help me how to achieve.

i have two query refering to two different table

i am desgning a ssrs report, output of which are saved in path through window subscription

but challenge is i want to save output of 1st dataset to sheet 1 and 2nd dataset in sheet 2 of same excel

Thanks a ton.


#2

I'm not sure if this comment will get flagged or not, but check out this TechNet article. It may be what you're looking for: https://technet.microsoft.com/en-us/library/dd255278.aspx


#3

Put both tables on the same page in SSRS and in properties check the box "insert a page break after this table".

you can give the execl tab a title by creating a title in SSRS create a textbox above the table and then in the textbox properties select the navigation tab and in the document map lable write a title.