In the Crystal Reports XI i can write a SQL query with the help of
SQL Expression workshop (just like Formula Workshop and parameter field)...
Am writing a query with this SQL Expression field and am using it in the reports.
And similarly i have a automated query running for the Report Generation parallel to the query which i created in SQL Expression field.
When this happens the Crysta Reports shows and error as the two queries are contradicting.
Will someone be able to explain what is the difference/similarity between the two queries : Automatically generated queries which creates the reports and the Queries which we create using the SQL Expression field.
Where can we use this SQL expression queries with out any errors.
Thank You !!