pujain
SSCrazy
Points: 2903
More actions
October 13, 2008 at 12:23 pm
#199360
we need to have reports that export to excel with multiple sheets.
For making it simpler to understand :
Select * from [tablename1]
Select * from [tablename2]
I need output of these two different statemants in two tabs of Excel sheet automatically.
Michael Earl-395764
SSC Guru
Points: 53873
October 13, 2008 at 12:40 pm
#884297
SSIS and SSRS will both do this.
October 13, 2008 at 12:50 pm
#884305
It would be great help for me if you can guide me step to step to perform this task.
October 13, 2008 at 3:23 pm
#884345
Currently i m using a SP setwebtask to get the data in two files but i want it in one single file in two different tabs.
Need your expertise on this
Thanks in advance
Puneet
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply