Crystal Reports and xsd

[blar9]

I have a DataSet xsd that has a few tableadapters I want to be able to use with crystal. The tableadapters take 3 parameters how do I tell crystal to use those queries and 1 pass prameters to crystal then have crystal use the values to query the tableadapters?

Thanks

 

[jmeckley]

instead of crystal pulling the data from the dataset you need to push the data to the report. The XSD only informs Crystal of the data structure.

Use the ReportDocument.SetDataSource() function to append the dataset to the report. something like this

MyDataSet ds = new MyDataSet();
newSqlDataAdapter.Fill(ds);
MyReportDocument.SetDataSource(ds);

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[blar9]

how does it work if the report needs more than 1 currently the report gets information from 5 temp tables that are created. I wanted to not create the temp tables and have it be queries that returned the information needed.

Thanks for your help

 

[jmeckley]

by temp tables do you mean db temp tables, or System.Data.DataTables?

5 queries would populate 5 DataTables within 1 DataSet. Then pass the DataSet the to ReportDocument.

Jason Meckley
Programmer
Specialty Bakers, Inc.