We have a SSRS report in SQL Server 2005 and it when exported using Aspose.words (TXT format) it exports fine. When we export the same report in SQL Server 2014 using same Aspose.words (TXT format) the formatting is totally messed up. See three attachment (1) how reports looks in web browser, (2) how it looks when exported from SSRS 2005 using Aspose.word (txt format), and (3) how it looks when exported from SSRS 2015 using the same Aspose.word (txt format). What can be done so that when report is exported from SSRS 2014 it doesn’t lose any formatting.
The Aspose.word was installed in SQL Server 2005 long time ago by someone else. I installed trial version of Aspose.WOrds in SQL Server 2014. May be we are missing some configuration (or post-install settings) related to Aspose.words in SQL Server 2014 which might have already been done in SQL Server 2005
Also attached is the .RDL file
Hi there,
- Please use the select statement (to populate the data) inside your RDL file and share it.
- Please attach the output text file that shows the undesired behavior.
- Please attach the output text file that shows the desired behavior.
<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;”>>
Please find attached the exported output of the report from SSRS 2005 and from SSRS 2014. The one from SSRS 2005 is good and one from SSRS 2015 is not good. On the report data is being retrieved from a stored procedures which talks to multiple databases using dynamics statements and grabs data from multiple tables.
For the sake of testing and explaining the issue, I have modified the report to use a single table. Attached is the updated report and the database backup (test database, and single table mytable). THat’s all you will need to test.
Hi there,
Please find attached the script to create table and insert data in the table.
Also attached the data in the csv file
I am glad to know that you are able to reproduce the issue. Would it be possible to provide a rough time estimate when you think this issue would be resolved?
Please note that, as I mentioned earlier, the same report exports fine in SSRS 2005.
Thanks.
Please note that our whole system upgrade is on hold because this issue. We would really appreciate if this can be escalated with high priority.
Thanks.
Hi Tahir,
The resolution you provided worked for one report but didn’t work for another report. Please find attached the .zip file. It has the actual reports, the scrip to generate tables and sample data, the PDF which will show how report looks when exported to PDF (which is good), the .txt file which show how report look with totally messed up formatting when exported using ASPOSE TXT export, another text file which shows report export fine using TXT export but when exported in SSRS 2005. We are now using this report in SSRS 2014. What do we need to do so that report exports fine in text format.
Thanks. Is there any update as to when should we expect the fix? We are on a very tight schedule to get this thing done. An early fix will be greatly appreciated.
rkapoor:
The resolution you provided worked for one report but didn't work for another report. Please find attached the .zip file. It has the actual reports, the scrip to generate tables and sample data, the PDF which will show how report looks when exported to PDF (which is good), the .txt file which show how report look with totally messed up formatting when exported using ASPOSE TXT export, another text file which shows report export fine using TXT export but when exported in SSRS 2005. We are now using this report in SSRS 2014. What do we need to do so that report exports fine in text format.
I am glad to know that you were able to replicate the issue. Hope to get a quick resolution. Thanks in advance.