sql server reporting services: Exporting to multiple sheets in Excel has limitations ? -- sql server reporting services

Exporting to multiple sheets in Excel has limitations ?

jhun_garma NO[at]SPAM hotmail.com
2/22/2006 11:53:28 PM

sql server reporting services: guys, I am exporting a report in excel that generates in different
sheets.
It seems that only 3 tab or sheets can be generated.

If the report exceeds 3 sheets all the rest of the sheets combined in
the last sheet.

Can anyone confirm this? Does it have any work around or I am just
doing something wrong?

thanks in advance

RE: Exporting to multiple sheets in Excel has limitations ?

hansemann
2/23/2006 2:08:31 AM

Hi, I am doing some testing on sending data to Excel myself. I just tested
this and was able to make 5 sheets when I made page brakes between rectagles
in the report. Have you used the device setting RemoveSpace when rendering
to Excel ?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.