[Solved] Crystal Report field not showing complete data in ASP.Net

AbdulHaque
 
on Jul 21, 2020 11:46 PM
8871 Views

Hi @everyone

I have designed a report using Crystal Report. I have many fields showing large amount of data like a paragraph string. I have one field name Job Title this field is appearing with incomplete data in report. I have setup all options like can grow width and height etc. Even deleted and recreated the field but still appearing incomplete. I tried a lot but unable to figure it out. Please help me getting out of this. Please consider the example below.

Ex: Stored Procedure Returns complete string like

"I have designed a report using Crystal Report. I have many fields showing large amount of data like a paragraph string."

Report field appears with incomplete string like

I have designed a report using Crystal Repot

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Jul 22, 2020 03:52 AM

Hi AbdulHaque,

You may check the database table for the data. If its size only varchar(20), you are able to save only 20 characters in the field.

If the data in the table is correct, you may check the crystal reports field size for that column. You may increase the width or reduce the font size or allow text wrapping for that field to display the contents in crystal reports.

Refer below link.

https://www.experts-exchange.com/questions/22228338/Text-fields-not-displaying-more-than-255-chars-on-Crystal-Reports-7-Report.html

 

AbdulHaque
 
on Jul 27, 2020 04:24 AM

I found the solution I made some changes in database then I did verify database on update then it came.

I really appreicate all of your suggestions many thanks.