How to display values and new char line (blank line)

[Former Member]

Hi,

In database, one field contains values followed by new character lines (blank lines) after blank lines there is no values. Finally, I would say the field contains values and blank lines. Every thing is fine in database.

In Crystal Reports the field is displaying only values. Need to display values and blank line.

User is asking after values new character lines (blank line) to be shown. They enter like that in an application. The user doubt is why report is not showing what they enter in the application.

In detail explanation, front end tool is ASP.NET and backend is SQL Server.

User enter some values in note field, after that they hit enter button in the same field, cursor will go next line...user may hit u2018enter buttonu2019 more than 5 times. So note field contain values and some blank lines which are created by after hitting enter button.

If user opens the application, they could see values plus blank lines in the note field.

They are fine with the application.

In Crystal Reports, the note field shows only values.

User is questioning that why we could not see in report we enter.

I checked in .Net application and SQL server database it is fine. It is displaying values and blank line.

Please help me out how to display values followed by blank lines in Crystal Reports - the way they enter in the application.

Thanks and Regards,

Manjunath N. Jogin

[Former Member · Accepted solution]

If I understand, the field has a value, then a return, creating a field that is 2 lines tall.

Setting the formating for the field "To Grow" may do it for you or you may have to do it manually by making the field two lines tall.

Debi.

[Former Member · Accepted solution]

Hi,

Sharonmat,

I tried as you suggested. It is still displaying only values.

I would like to explain again.

it is not exactly null values.

In .Net application it is called 'new char line'.

it shows those many lines look like null.

it is working fine in database.

Why it is not working in Crystal Reports? I am wondering...

Thanks for your suggestion.

Debi,

.

User may enter any number of blank lines or they may not enter blank lines.

That is the reason I can not always give more height or blank text object.

Thanks for your suggestion.

Please suggest me some more suggestions,

Thanks and Regards,

Manjunath N. Jogin

[Former Member · Accepted solution]

Did you try formating the field "TO GROW"?

Crystal may not recognise what is happening in the field. You may also try Report Options and selecting one or both "Convert Null Values to default."

Debi

[Former Member]

if you mean by blank line the null values you can try

go to file

report options

check off the null values boxes

it should pull in the null values