Page 1 of 1

Text + null values from db

Posted: Fri Dec 04, 2009 7:31 am
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).

Text + null values from db

Posted: Fri Dec 04, 2009 5:10 pm
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.

Text + null values from db

Posted: Mon Dec 07, 2009 12:26 am
by whythetorment
Change the type of that Date DataColumn to DateTime(Nullable).
Why must I change it to DateTime ? Its a string ?