Crystal reports forms correct SQL query but doesn't show data with GUID column

[Former Member]

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.

[Former Member]

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.

[former_member1305491]

is this issue fixed?

[former_member183750]

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