11/25/2024 7:38:51 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
querying nulls
Posted: 09 Aug 06 4:17 AM
|
fiogf49gjkf0d I have tried all the usual SQL style statements for handling null fields in my database but Crystal reports doesn't seem to like them.
Is there a specific way of searching for null data within a crystal report.
Thanks. |
|
|
|
Re: querying nulls
Posted: 09 Aug 06 5:04 AM
|
fiogf49gjkf0d What about this, in a formula, in Crystal Syntax:
If IsNull({field.name}) = True Then ...
Unless I've missed the point?
Also, there is a feature in Crystal that a test for Null must be the first one if you have multiple tests for values on the same field.
|
|
|
|
Re: querying nulls
Posted: 10 Aug 06 3:24 AM
|
fiogf49gjkf0d Yes, in your Report Options - select Convert NULL Field Value to Default - eliminates the null issue. |
|
|
|
Re: querying nulls
Posted: 10 Aug 06 8:08 AM
|
fiogf49gjkf0d I've always tried using SPs (with parameters usually) or views in Crystal Reports vs. building the table structures up in Crystal. I find you have greater flexibility with SPs and views. I get the SP or view to give me exactly the data I need for the report.
In using them you also have the ability to get rid of all NULLs before the data gets to the report. I'll use either a ISNULL() or CASE statement to rid the data of all NULL values. I've found this to be the most efficient way of gathering data from the database for a report. Other benefits outside of getting rid of nulls is all of the processing happens on the server and only the required data for the report is transferred to the client. So what I am left with is just using Crystal to format and present the report.
John G. |
|
|
|
Re: querying nulls
Posted: 16 Aug 06 3:05 AM
|
fiogf49gjkf0d Thanks for all your replies i shall give them a try  |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|