September 17, 2013 at 9:49 am
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
September 18, 2013 at 5:10 am
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.
September 20, 2013 at 7:08 am
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?
September 20, 2013 at 7:20 am
Hello,
I have solved this problem now. I used one table rather than two tables to use both datasets.
Regards
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply