SQL Expression for report

[netusepk]

Is there a way to create a report based on a select statement that the user writes, as I am having problems with visual linking but to the limitations with multiple DSNs use.
Thanks
Jack

 

[dcm]

netusepl: You can use the SQL Designer (a separate application which comes with Crystal Reports). This has the facility to take an input SQL statement and generate a result set. You can then use the result set as the basis of your report David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[netusepk]

But designer stores a static data and it get difficult working with it, as the report will be based on that static data. Correct me if I am wrong.
Thanks
Jack

 

[MalcolmW]

The SQL Designer stores a SQL query, and you also have the option of saving the query with a data set. Uncheck the option to Save data with query. This will cause the report to be based on fresh data from the SQL Query.
You should also uncheck the report option Save data with report. Malcolm

 

[Guest_imported]

and how do to filter the data when i call to the report? because y i´m rewriting the code in the SQL, Query property of the component when i call it
i probed to do the query with QueryDesign, but the problem is the filter