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

Hidden Column in Excel on Export Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hello,

I have created a new report in SSRS. The report has two tables.

The first table has columns

Sales Price, Difference, Commission, TotalClaim, DiffVat1, DiffVat2, DiffVat3,


The second table columns

AccNo, Customer PostCode, Ean Code, Prod desc, Pack, Invoice Num, InvoiceDate, PipCode


All of the First column tables are aligned with the second table up to the DiffVat31 and InvoiceDate.

Both tables are contained within a Rectangle.

When i export to excel cells A to H show and then I1 is hidden.

Column I appears to be blank. PipCode (Which is the second table) Column is then displayed in Column J.

Is there a way to prevent this from happening when designing the report. Or is there a way to prevent it on export.

I have attached a screenshot to show what is happening.

Regards




  Post Attachments 
image.png (12 views, 96.48 KB)
Post #1495565
Posted Wednesday, September 18, 2013 5:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:09 AM
Points: 243, Visits: 2,699
When Exporting to Excel, the column "arrangements" also takes the headers and footer of the report into account. I would take a look at aligning or removing those into order for everything to line up.
Post #1495849
Posted Friday, September 20, 2013 7:08 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: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Scott is correct. What I usually do with headers and footers is make sure they are the full width of the report. Assuming the headers and footers are ok, double check that the tables and all fields are in perfect alignment.

Have you tried removing the tables from the rectangles?
Post #1496869
Posted Friday, September 20, 2013 7:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hello,
I have solved this problem now. I used one table rather than two tables to use both datasets.

Regards
Post #1496881
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse