Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Null parameters and optimising SQL extraction
Thank you, for the reply. I ended up using, and ({SMDR.Country} = uppercase({?Country}) or trim({?Country}) = "" ) That generated the result I was after. Cheers, T- theodorez
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Null parameters and optimising SQL extraction
Thanks for the reply, however, my "convert null values" is greyed out because I have clicked "Perform grouping on the server". I am trying to make the extraction more efficient. Ideally, if the user enters a Country parameter, the SQL should show blah blah WHERE SMDR."Date" >= {d...- theodorez
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Null parameters and optimising SQL extraction
Hi, I'm using Crystal 8.5 and having all sorts of grief with null parameters. I have a rather large database > 1 Million records and want to optimise the SQL extraction so that it only extracts records matching some filters. I want crystal to create an SQL something like this SELECT...- theodorez
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 4 Other topics
