Print Page | Close Window

Has to create a prompt on column havng NULL value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13536
Printed Date: 04 May 2025 at 4:32am


Topic: Has to create a prompt on column havng NULL value
Posted By: ishu1404
Subject: Has to create a prompt on column havng NULL value
Date Posted: 19 Jun 2011 at 12:41am
Hi,

I am working on Crystal report XI. I have a report in which I need to have a prompt on the column which is having NULL values in the database.
Now the problem I am having is, since all the values for the particualar column is NULL i am not able to select Any value in the Prompt box and the report is not fetching any record.
Is there any way to fetch those NULL values in the report using the prompt. I have created prompt at the Data provider level and using universe to create the report.
 
In future I may get data in the column but right now only NULL values are there and only because of this prompt I am not getting data.
Please help!!

Thanks in advance

Regards
Ishu


Replies:
Posted By: comatt1
Date Posted: 23 Jun 2011 at 4:13am
you can just setup a formula in the select expert (isnull(value) or value=PROMPT)

Posted By: lockwelle
Date Posted: 11 Aug 2011 at 3:38am
haven't used parameters from CR in years, but can't you have the user check the box that says allow nulls?
 
 


Print Page | Close Window