Export to Excel last column is always put on separate page.
This seems to happen when the report is not 8.5 x 11 portrait. Any other size or orientation will cause it to put the column on the last page. Does anyone know why?
January 1st, 2008 12:10am

Hi, Yes it happens sometime to put some column on separate page . For that please check your page set up as well as page margin ,are they correct according to your page size? Make sure there should not be any overlapping of the columns or components and even you can check the last column width should be littile less than the page boundary . Hope you will get it solved. Anyway please let me know if you get the solution Thanks Mahasweta Happy New Year
Free Windows Admin Tool Kit Click here and download it now
January 1st, 2008 8:50am

No luck, I have to make the columns a couple of inches less to get it to go. Nothing is overlapping.
January 9th, 2008 4:26am

Hi, Do you have any hidden text box right to the table? What happens sometimes even if the text box or the componet is hidden still the lay out is being rendered ,you can check in that way. Anyway leyt me know if you get the solution Thanks Mahasweta
Free Windows Admin Tool Kit Click here and download it now
January 9th, 2008 1:54pm

is this somehting like the PDF experoting issues? u need to set the interactive size of ur report.
January 9th, 2008 3:18pm

Nothing is hidden on the report other than parameters. It is exporting to Excel, PDF is fine. Interactive size I have tried, 8.5 x 11 and 7.5 x 10 on an 8.5 x 11 size report. 8.5 x 11 reports are messed up as well, I found out.
Free Windows Admin Tool Kit Click here and download it now
January 11th, 2008 10:31pm

I'm having the same problem with my reports. I've also noticed that each column in the spreadsheet is a little bit wider in Excel than it is in SSRS. For example, my first column in SSRS is 0.75in (54pt), but in Excel it renders to 0.79in. Each of my 12 columns behave the same way, so by the time you get to the last column, you can be offset by a significant amount of space. Thanks for your help.
December 10th, 2010 10:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics