I have created fairy simple report having a table in body section and Header, Footer. I have set the Report Properties
Orientation - Landscape
Paper Size - Custom
Width - 11in & Height - 8 in
Margins - Left 0.25 in , Right 0.25 in, Top 0.5 in, Botton 0.5 in
Issue NO 1: When i export the report to Excel, it takes margin as Left 0.75 in , Right 0.75 in, Top 1 in, Botton 1 in, because of this some part of my Report is cut. what should i do to keep margins of Excel as per margins set in RDL.
Issue No 2: In Footer excel shows Page 1 of 1 for all the pages
Expression used :
"Page" & Globals!PageNumber &
" of " & Globals!TotalPages;
Issue No 3: when i export the Report to word, it does not consider landscape and show only middle part of report, cut rest of the report data.
View Complete Post