Skip to Content
0
Former Member
Aug 05, 2015 at 04:04 PM

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

73 Views

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.