on 11-18-2008 3:11 PM
I am using Crystal Reports XI and I have a table that has customer names with "NULL" values. I am wanting to print all of those records in the table with the NULL value. Can someone help me with this issue.
Thanks Jim
HI Jim,
1) Goto > Report Options >Check the option "Convert Database Null Values to default".
And also check the option " Convert the other values to default".
2) Now goto > Record Selection Formula > Select "Default Values for null". and write the below formula
isnull(Database_Field)= true.
Hope this helps!
Regards,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just to throw my $.02 in, I never turn on the report option to change null values to default. it vastly complecates any other forumla you might want to write in the report, and can cause performance issues under certian circumstances.
I use 'default values for null' in the formula workshop for the select expert, or explicitly in formulas where I need that functionality.
Also, just a picky point, but asing "isnull() = true" is redundant. if the field is null, isnull evaluates to true, and then you're asking if true = true. If it isn't null you're asking if false=true which is clearly false. In cases such as these isnull() alone will suffice.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I ran across this while searching a solution for a simular problem i was having. When i used a select Formula
isnull({table.feild}) it was clearing my entire report of informaiton. I had used this on previous versions of Oracle and Crystal. I just recently was moved to Crystal 11 and I believe Oracle 11. The solution it turned out was the "=true" thus "isnull({table.feild}) = true"...... i don't know what is different but this was the only way I could get the desired effect of selecting the null records. Go figure
Edited by: Kschuett on Feb 10, 2012 12:18 AM
Thanks for the response, That worked.
Thanks Jim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the response, but it didnt select any records. I am trying to list all of the records where this field has a null value in the {CRD1.U_ShipName} field.
Thanks Jim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please try the following:
isnull({CRD1.U_ShipName})= true;
Regards,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I performed those steps, and added in the Reports Selection "isnull{CRD1.U_ShipName}= true" ,but I am receiving the following error, "The remaining text does not appear to be part of the formula". Im not sure what this error is.
Thanks Jim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
go to file, report options
check null value boxes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.