sql server reporting services: Reporting Services 2000 Export Excel Issue -- sql server reporting services

Reporting Services 2000 Export Excel Issue

Eric
5/3/2007 12:52:02 PM

sql server reporting services:

Hello All,

I am currently creating a Reporting Services report whose total
page width is 33in. I use three data tables to simulate one very large table.
My issue is:
When I export this data to the EXCEL format, tables two and three are not
visible past the first sheet. Is there something that I should do to ensure
that all three tables are visible on every Excel WorkSheet?

Thanks
Eric

Re: Reporting Services 2000 Export Excel Issue

EMartinez
5/3/2007 7:31:21 PM

[quoted text, click to view]

I'm not sure about the maximum width of a report; however, you can try
adding all 3 table controls into a single rectangle control. This
should conserve width space. Also, make sure that the properties of
the table controls include 'Fit table on one page if possible.' Sorry
I could not be of further assistance.

Regards,

Enrique Martinez
Sr. Software Consultant