11/25/2024 5:38:40 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.
|
|
|
|
Hidden Criteria?
Posted: 02 Dec 09 10:45 AM
|
We have a report that is not returning all the data we want. I've found the problem in Show SQL. The WHERE clause contains an IN statement which excludes some of the wanted data. But the Record Selection Formula doesn't contain any criteria on this field.
This report only queries one table, so it is not a join issue. There are several groups, formulas and summary fields though. This also happens when the report is previewed in Crystal Designer, so it's not an SLX script passing in parameters.
Where else could that criteria be coming from? Is there an easy way to clean up possible corruption so that the SQL query WHERE clause is based only on the Record Selection Formula? |
|
|
|
Re: Hidden Criteria?
Posted: 02 Dec 09 10:54 AM
|
What tool are you using to check the SQL Statement? The SLX PRofiler or just within Crystal Report?
If you are looking at it with the SLX PRofiler, you can see both the Unparsed and Parsed SQL Statement, so if the IN clause is there before the parse, it is not being added by SLX.
By the same token, there is a way within Crystal to view the SQL statement, and if I am not mistaken, you can also modify the SQL from there. Have you tried to manually remove it?
|
|
|
|
Re: Hidden Criteria?
Posted: 02 Dec 09 11:39 AM
|
I am using the Show SQL menu item in Crystal, so the IN clause is there before it gets to SLX. Crystal 8.5 and earlier allowed direct editing of SQL statements, but by design, Crystal XI does not.
|
|
|
|
Re: Hidden Criteria?
Posted: 03 Dec 09 12:12 PM
|
In case anyone else finds this message because they are experiencing a similar issue, my solution was to create a new report hitting the same table, set up the same grouping, copy & paste all objects from the old report to the new, then copy & paste the selection criteria we do want from the old to the new. This brought over all of the functionality & formatting but left the corruption behind.
|
|
|
|
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!
|
|
|
|
|
|
|
|