Best way to print a report variable "Date" only if it is not Null
Posted: Mon May 12, 2008 6:35 am
I have a report where i pass two report variables, "DateBegin" and "DateEnd" (these are the dates choosen by the user in my client interface). I want these two dates printed in the header in a format like "Dates choosen: from dd/mm/yy to dd/mm/yy", eg. "Dates choosen: from 01/05/08 to 12/05/08".
In the client interface the user can also not select any date: in this case the DateTime report variables are passed as NULL and obviously i don't want to print the whole string "Dates choosen:..."
How can i obtain this in design (not in code)? I've tried using Conditions (displaying the textbox only i date is not null) but without results, probably i'm missing something in the syntax.
Thanks.
In the client interface the user can also not select any date: in this case the DateTime report variables are passed as NULL and obviously i don't want to print the whole string "Dates choosen:..."
How can i obtain this in design (not in code)? I've tried using Conditions (displaying the textbox only i date is not null) but without results, probably i'm missing something in the syntax.
Thanks.