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.