The generated report is displaying fine in ReportViewer 10.0 and when am trying to export the same into Excel, am getting alignment issues in the exported spreadsheet(.xls).
I have mentioned below the UI alignment issues. Please get me clue to how to fix this issue.
1. Table borders are collapsed.
2. Footer content is missing.
in every control, set allow height to increase to unchecked, and make sure the controls are not overlapping each other.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
When we make this property then the preview and print layout will never works when the page contents are increasing beyond the standard. Page contents are not static in my case.
This is an issue with reportviewer export functionalities (already reported to MS) and i revealed that we have to override the in-built events for exporting (excel, word, pdf) functionalities to make it working properly.
thanks for your suggestion.
Marked as answer by karthikeyankasi on Jul 26, 2011 08:20 PM
karthikeyank...
Member
321 Points
73 Posts
Alignment issues when Exporting the report to Excel from RDLC
Jul 08, 2011 11:32 AM|LINK
Hi,
The generated report is displaying fine in ReportViewer 10.0 and when am trying to export the same into Excel, am getting alignment issues in the exported spreadsheet(.xls).
I have mentioned below the UI alignment issues. Please get me clue to how to fix this issue.
1. Table borders are collapsed.
2. Footer content is missing.
Thanks,
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Alignment issues when Exporting the report to Excel from RDLC
Jul 08, 2011 01:24 PM|LINK
in every control, set allow height to increase to unchecked, and make sure the controls are not overlapping each other.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
karthikeyank...
Member
321 Points
73 Posts
Re: Alignment issues when Exporting the report to Excel from RDLC
Jul 26, 2011 08:20 PM|LINK
When we make this property then the preview and print layout will never works when the page contents are increasing beyond the standard. Page contents are not static in my case.
This is an issue with reportviewer export functionalities (already reported to MS) and i revealed that we have to override the in-built events for exporting (excel, word, pdf) functionalities to make it working properly.
thanks for your suggestion.
SunilRathod8...
Member
10 Points
10 Posts
Re: Alignment issues when Exporting the report to Excel from RDLC
Jul 27, 2012 10:57 AM|LINK
Hi,
I am facing same issue. Is there any work around for this? What kind of changes are you talking about in bult in events?