Format issue with Word Render in SSRS

Aspose.Words Product Family
1

We are evaluating the application of ASPOSE word in SSRS 2014 to generate a workable WORD document. The PDF generated by SSRS is perfect in terms of the layout. However, when the report is export as Word documents using the internal word render, lots of items were not positioned well, which is the reason why we try the evaluation from you. However, some issues were still not solved by your application.


Attached is the PDF, word documents exported using ASPOSE and you can tell the difference easily, especially pages of Cover Page, 2, 5, 13, 19. Chart on page has some items overlapped, and I don’t know if everything can be fixed to be exactly like the PDF file if the configuration file can be modified.

Attache also includes RDL file.

Please let me know if you have any comments. Thanks.
2

Hi there,

Thanks for your inquiry. We have opened the shared Word document in MS Word 2016 and have not found the shared issue. Could you please share the screenshots of problematic section of output document?


It would be great if you please use the select statement (to populate the data) inside your RDL file and share it here for testing. We will investigate the issue on our side and provide you more information.

Please check the following DataSet example with select statement for your kind reference:

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSets<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSet<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“DataSet”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Query<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSourceName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>DataSource</DataSourceName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>CommandText<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”>select 1 as value, ‘label1’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 2 as value, ‘label2’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 3 as value, ‘label3’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 4 as value, ‘label4’ as label<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>CommandText<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Query<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Fields<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“value”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataField<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>value</DataField>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>rd:TypeName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>System.Int32</rd:TypeName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“label”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataField<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>label</DataField>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>rd:TypeName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>System.String</rd:TypeName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”></<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Fields<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSet<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSets<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: blue;”>>

3

Thanks, Tahir, for the prompt response. Unfortunately, I did not find any Select Statement in the RDL file and could you let me know how I can find it. As you noticed, the RDL file is attached to the post, and it’s big in size, containing codes for images.


One of issues we have in the Word document is that some text boxes have been moved to the new page, though they are in the same page in PDF output. Attached please find the screenshot from the word document. Is there any way this can be corrected? Thanks.
4
Hi,

Thanks for sharing the detail. To reproduce this issue at our end, we need your data source. Please execute the SQL "select statement" shared in my previous post in SQL Server Management Studio to get the result. Please replace CommandText in RDL file with same type of "select statement".

You may also generate the SQL script with data and share it here. We will investigate the issue and provide you more information on it. Please check following link about generating sql script.
Generate script in SQL Server Management Studio