Hi Avihu,

Creating a report from a dataset is completely different than using a regular database. In a normal database, Crystal queries it with your user credentials, extracts the data, and prints the report. But this won't work with a dataset and you get the Database Login prompt b/c CR doesn't know how to handle it.

Here is a summary of what to do.
1. Create your dataset in memory and save it as an .XSD file using Dataset.WriteXmlSchema().
2. Create a new report, add a new connection and use the ADO.NET option and point it to your .XSD file. CR will read this file to get the record layout.
3. In your code, create the dataset file and assign it to the ReportDocument object using the SetDataSource() method.
4. Now your report has the data and you can preview it.

HTH,

Brian