Link to home
Start Free TrialLog in
Avatar of Easwaran Paramasivam
Easwaran ParamasivamFlag for India

asked on

How to show NULL datetime field in SSRS report?

How to show NULL datetime field in SSRS report? Please do suggest.
Avatar of Amandeep Singh Bhullar
Amandeep Singh Bhullar
Flag of India image

Option i can suggest is send the empty result from SQL query using isNull.
Avatar of Easwaran Paramasivam

ASKER

=IIf(IsNothing(Fields!LastPasswordDtm.Value.DateTime),"",Fields!LastPasswordDtm.Value.DateTime)

Open in new window

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
Avatar of Easwaran Paramasivam
Easwaran Paramasivam
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Accepting as solution for tracking purpose.