on 08-05-2015 5:04 PM
I have a table with a GUID column and a recordId (not a guid) column. I need my report to accept a GUID as a report parameter and the use if the Record Selection formula to make certain I only get the record Id's I need.
Since the report doesn't support passing a GUID parameter, I was able to convert the GUID to a string and pass it in without incident. If I generate the SQL query in Crystal Designer it looks good: The WHERE clause is properly formatted and if I run the query in SQL Designer it will find all the records I need to fetch. When I actually attempt to display the report however, it states that 0 records were found despite SQL Profiler also showing that the correct SQL was fired off.
Has anyone run into this? Is there any way to get the Record Selection formula to not drop the records when actually displaying the report?
I'm using 14.0.4 of the Crystal Designer if that helps.
Updated to Service Pack 11 for the designer and re-opened and saved the report. The report still forms the correct SQL Query but doesn't display any data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vernon
First thing you need to do is update to the latest Service Pack for CR 2011; SP 11 (you are currently on SP 4...).
SPs can be downloaded from here:
Downloads for SAP Crystal Reports and others
See if that helps.
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.