handle null DateTime in database (sql server 2008)
hi my dear friends ...
i am using asp.net web app with csharp in vs 2008...
i have a class to localize calendar and datetime in my project and when i call it in page load , so every date in my report will be show as my own culture(persian - farsi)...
i have a date column in my database (sql server 2008) that is nullable and some field are null about it....
when i browse a page that contains a report with that DATE column , so i get an error...
how can i tell my report when that date column is null then show something and if not null so show it ?
what can i do about this problem step by step?
really thanks for your support and your attention...
i am using asp.net web app with csharp in vs 2008...
i have a class to localize calendar and datetime in my project and when i call it in page load , so every date in my report will be show as my own culture(persian - farsi)...
i have a date column in my database (sql server 2008) that is nullable and some field are null about it....
when i browse a page that contains a report with that DATE column , so i get an error...
how can i tell my report when that date column is null then show something and if not null so show it ?
what can i do about this problem step by step?
really thanks for your support and your attention...
Comments
FastReport automatically converts null date values to dates like 1.1.0001. To hide zero dates in a TextObject, use the HideZeros property (it works for numeric and date values).