How to create a report using dynamic sql

[sk8er1]

I have a form where the user selects zip code, city etc..and build a dataset on the fly that loads a datagrid.
How can I use that dataset for a crystal report.

 

[sk8er1]

I am looking at the COALESCE function, I will try to build a stored procedure and create the dataset for the crystal report. If that does not work....HELP!!! Am I on the right track?

 

[sk8er1]

I have built a selection criteria form. There are several text boxes which are filled and a SQL statement is built and a dataset created on the sql statement. Then I load that dataset into a datagrid. It works fine. I want to use that same dataset for a Crystal Report. How can I do that.

 

[Madawc]

Which Crystal? You can include the Stored Procedure along with other tables, though usually this needs a subreport because Crystal doesn't let you mix them directly.

In Crystal 10, use Database Expert, select a database but then use [Add Command] to add your SQL code.

Madawc Williams (East Anglia, UK)