Solved

How to show NULL datetime field in SSRS report?

Posted on 2014-01-21
4
1,210 Views
Last Modified: 2014-01-26
How to show NULL datetime field in SSRS report? Please do suggest.
0
Comment
Question by:Easwaran Paramasivam
  • 3
4 Comments
 
LVL 19

Expert Comment

by:Amandeep Singh Bhullar
ID: 39796577
Option i can suggest is send the empty result from SQL query using isNull.
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39796683
=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.
0
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 0 total points
ID: 39796968
=Convert.ToDateTime(IIF(IsNothing(Fields!LastPasswordDtm.Value),DateTime.MinValue,Fields!LastPasswordDtm.Value).ToString()).ToString().Replace(DateTime.MinValue.ToString(),string.Empty)

Open in new window


Above code solves the issue.
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 39809811
Accepting as solution for tracking purpose.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question