Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
How to handle NULL date
Migrateduser
<p>[color=#000080;][font="georgia, serif;"]Hi All,[/color][/font]</p><p> </p><p> </p><p>[color=#000080;][font="georgia, serif;"]If there is null value in database for a particulat field we can display text "N/A" in report instead of null for String data types as below.[/color][/font]</p><p> </p><p>[color=#000080;][font="georgia, serif;"]datasetrow[attributename] || "N/A"[/color][/font]</p><p> </p><p> </p><p>[color=#000080;][font="georgia, serif;"]But how can we display string "N/A" for Date data types if there is NULL value in database for date filed?[/color][/font]</p><p>[color=#000080;][font="georgia, serif;"]Any help...................
[/color][/font]</p><p> </p><p> </p><p> </p><p>[color=#000080;][font="georgia, serif;"]Thanks.[/color][/font]</p>
Find more posts tagged with
Comments
There are no comments yet