SQLServerCentral.com / Reporting Services / Reporting Services / Hidden Column in Excel on Export / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 07:33:03 GMT20RE: Hidden Column in Excel on Exporthttp://www.sqlservercentral.com/Forums/Topic1495565-150-1.aspxHello,I have solved this problem now. I used one table rather than two tables to use both datasets.RegardsFri, 20 Sep 2013 07:20:02 GMTdbmanRE: Hidden Column in Excel on Exporthttp://www.sqlservercentral.com/Forums/Topic1495565-150-1.aspxScott 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?Fri, 20 Sep 2013 07:08:42 GMTTee TimeRE: Hidden Column in Excel on Exporthttp://www.sqlservercentral.com/Forums/Topic1495565-150-1.aspxWhen 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.Wed, 18 Sep 2013 05:10:33 GMTScott Murray-240410Hidden Column in Excel on Exporthttp://www.sqlservercentral.com/Forums/Topic1495565-150-1.aspxHello,I have created a new report in SSRS. The report has two tables.The first table has columnsSales Price, Difference, Commission, TotalClaim, DiffVat1, DiffVat2, DiffVat3, The second table columnsAccNo, Customer PostCode, Ean Code, Prod desc, Pack, Invoice Num, InvoiceDate, PipCodeAll 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.RegardsTue, 17 Sep 2013 09:49:22 GMTdbman