Hi i am able to generate reports and able to export to pdf and excel. But i want excel page type to be set to Legal. And also when i export the page break functionality should not be considered, bcoz of which my excel look up is bad to go through every sheet. can we show them on single sheet except the report footer.
And for the print settings it is ok for the pdf but the data gets truncated when i directly print in excel. I want the paper type to be legal and data should be printed correctly. Please let me know how to set the print setting, layout setting for good exporting to excel and pdf formats in ssrs.