Text + null values from db

Stimulsoft Reports.NET discussion
Post Reply
whythetorment
Posts: 20
Joined: Fri Nov 20, 2009 7:40 am

Text + null values from db

Post by whythetorment »

Hi,

Im trying to do something like the following : (Please note the bold on Priority)

Priority: {DataSource1.sPriority}

I've tried doing it in a normal text, but then it bolds the whole text, and not just Priority:

I've managed to get it right in a Richtext, but then the problem comes in if the value in the db is null. When the value for example is a date and it is null, then it does not display anything. If the value is null, then it must still display Priority:

I don't want to use two separate text fields next to each other because then the alignment is completely off and looks untidy. (our clients are very fussy regarding this).
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Text + null values from db

Post by Edward »

Hi

Please select 'Report' object in the Properties window and set ConvertNulls property in true.

Change the type of that Date DataColumn to DateTime(Nullable).

Thank you.
whythetorment
Posts: 20
Joined: Fri Nov 20, 2009 7:40 am

Text + null values from db

Post by whythetorment »

Change the type of that Date DataColumn to DateTime(Nullable).
Why must I change it to DateTime ? Its a string ?
Post Reply