Hi, We are using Aspose.Words for .NET version 18.5 and Aspose.Words for Reporting Services Version 18.5 and we are facing issue where the paragraph text is longer is cutting of.
We use Reporting Service to generate the report and specify the format to be report generated in. When we use “AWDOC” format report is cutting data. Also for information if we use “WORD” format, everything works fine.
Any pointers or places to look for the clues will be helpful.
You are using old version of Aspose.Words for Reporting Services. Please try the latest version of Aspose.Words for Reporting Services 19.8 and let us know how it goes on your side.
If you still face problem, please ZIP and attach following resources here for testing.
We will investigate the issue and provide you more information on it. Please check the example of statement here:
<CommandText>select 1 as value, ‘label1’ as label
union all
select 2 as value, ‘label2’ as label
union all
select 3 as value, ‘label3’ as label
union all
select 4 as value, ‘label4’ as label
</CommandText>
Thanks for your cooperation.
Hi Tahir,
Thank you for the response.
We have tested with latest version 19.8 but still facing the issue.
RDL is using a procedure and we have checked the data/output of procedure is giving correct data. Also we previewed the RDL report with required parameters and it also shows correct data on report viewer.
Please see attached screenshot and documents with example. Example shows issue with “Follow up” text.
RDL Perview 1 and RDL Preview 2 shows complete text displayed in SQL Reporting Services RDL / Report File.
WORD Format DOC File shows perfectly generated report in WORD format using “WORD” as format.
AWDOC Format DOC File show issue for the report generated in AWDOC format.
As per my observation, issue happens when a paragraph text goes more then a page length it is cutting the text.
Please let me know if you need any additional information.
Thanks,
AshASPOSE Issue.zip (469.0 KB)
Thanks for sharing the detail. We need your RDL along with data source to reproduce this issue at our end. Please share these resources for testing purpose. We will investigate the issue and provide you more information on it.
Hi Tahir,
Please find the same with attached zip file. Thank you for your help and support.
Summary of Monitoring Activity.zip (39.3 KB)
We need your data source to test this case. Please embed the data source as suggested in my post here.
You may also export data in such a way that it can be imported in another database/system. Please refer to the following article.
Exporting data In SQL Server as INSERT INTO
You can also share the data source by exporting the data generated by store procedure into one table, export the table into new empty database and share that database with us.
Thanks for your cooperation.
Hi Tahir,
Apologize for the delay. Please find the SELECT statement with data values for the data of RDL report share previously. Hope this helps. Please let me know if you need any additional information.
Thanks
ASPOSE WORD ISSUE Dataset.zip (4.9 KB)
Thanks for sharing the detail. You have shared the SQL statement. It would be great if you please embed this SQL in your RDL and share it here for testing. You can use it in CommandText tag.
Moreover, please use the same RLD to export the document using the latest version of Aspose.Words for Reporting Services 19.8 and share the problematic output document.
Please also share the SQL Server version. Thanks for your cooperation.
Hi Tahir,
We were able to reproduce this issue with a new report and new database which has only one table and one field.
Steps…
Created new blank database with one table (FollowUp) and one field (Comments).Backup is attached with request.
Created new report RDL to display “Comments” field from “FollowUp” table.
Viewing RDL file preview, Preview looks correct and shows all data correctly. Please see attached screenshot.
Exported it to WORD and AWDOC format and AWDOC format is cutting text. Attached documents with this request.
We user SQL Server 2017.
Hope this helps.
Thanks
Ashish
ReportTest - AWDOC.zip (495.4 KB)
Thanks for sharing the detail. We have logged this problem in our issue tracking system as WORDSRS-277. You will be notified via this forum thread once this issue is resolved.
We apologize for your inconvenience.
Thank you Tahir for the updates. Will there be be any tentative timing or approximate timeline for the resolution of the same ?
We try our best to deal with every customer request in a timely fashion, we unfortunately cannot guarantee a delivery date to every customer issue. We work on issues on a first come, first served basis. We feel this is the fairest and most appropriate way to satisfy the needs of the majority of our customers.
Currently, your issue is pending for analysis and is in the queue. Once we complete the analysis of your issue, we will then be able to provide you an estimate.
Just wanted to follow up on this issue. Issue status is still showing NEW. Is there any workaround ?
Unfortunately, there is no workaround available for this issue.We will inform you via this forum thread once there is an update available on it. We apologize for your inconvenience.
Hi Aspose Team, Just wanted to follow up on this issue. Is there any update or fix? It has been more than a year and we are facing this issue consistently.
We regret to share with you that there is no update available on this issue. We are really very sorry for your inconvenience.
@ashkinni The mentioned issue is resolved in the latest version of Aspose.Words for reporting Services.
Thank you. We will download latest version and verify it.