Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Has to create a prompt on column havng NULL value Post Reply Post New Topic
Author Message
ishu1404
Newbie
Newbie


Joined: 03 Jan 2011
Location: India
Online Status: Offline
Posts: 12
Quote ishu1404 Replybullet Topic: Has to create a prompt on column havng NULL value
    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
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 23 Jun 2011 at 4:13am
you can just setup a formula in the select expert (isnull(value) or value=PROMPT)
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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?
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.