Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

When Exporting a SSRS report to Excel getting extra columns Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 8:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 6:07 AM
Points: 8, Visits: 45
Hi,

Can someone help me here, when i am exporting a report to Excel . I am getting an Extra Column.

Thanks,
Mohan.
Post #1475056
Posted Thursday, July 18, 2013 8:42 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
If you have a field in the header, make sure its size is as wide as the report. If it ends in the middle of one of the report columns below, this will cause extra columns in Excel. Same for footers, I believe.
Post #1475064
Posted Saturday, August 10, 2013 2:38 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:41 PM
Points: 522, Visits: 234
Check exporting the report to pdf. If you still get an extra column, try setting textbox positions using property window, I mean left=xxx in; top=xxx in.
Post #1483059
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse