Hi

Im trying to generate a crystal report at runtime based on datasubmitted from a webform. The report will come from the same tables always but the information from the webform is used in the SQL.

My current method is :

Query the database and use a dataadapter to store the info in a Dataset.
the dataset is not stored not the server as a file, it only exists during runtime (not .xsd)

Then i create a CR at design time pointing at the dataset created in the previous step as its source.

Only problem is the Dataset has no datatables in it to create the report from ! lol

I tryed to get round this using an xml file and writing the dataset to the server. However this isn't perfect as multiple people will be using the application and generating a new xml file for each user would soon take up alot of space

So to some up my question is ...

1) Is there a way in which dynamic crystal reports can be generated based on data submitted?

2) If a file has to be generated can this be removed afterwards?

3) Also i started tooking at hard coding the entire report, is it possible to add tables and data from a seperate SQL using objects in the Crystaldecisions.crystalReports namespace ?


Thanks for your time

Q