Reporting Services 2000 Export Excel Issue

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
EricOn May 3, 2:52 pm, Eric <E...@.discussions.microsoft.com> wrote:
> 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
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