Easwaran Paramasivam
asked on
How to show NULL datetime field in SSRS report?
How to show NULL datetime field in SSRS report? Please do suggest.
Option i can suggest is send the empty result from SQL query using isNull.
ASKER
=IIf(IsNothing(Fields!LastPasswordDtm.Value.DateTime),"",Fields!LastPasswordDtm.Value.DateTime)
I use above expression. It works fine for Non nullable columns but ERROR is shown for NULLABLE column. How to resolve it? Please do suggest.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Accepting as solution for tracking purpose.