Dataset as Datasouce to Crystal Reports

Here is the sample code that compiles and excutes well however I still get error in report popup:

I have a Dataset.xsd in my solution that is used to Attach ffields on report header and details:

Here is the code:

DataSet results = new DataSet();
                    results.ReadXml(new StringReader(excelContent), XmlReadMode.InferSchema);

                    //results.Relations.Add("relation", results.Tables[0].Columns["evnt_id"], results.Tables[1].Columns["evnt_id"]);
                    //LoadReport(results);
                    //return;

                    //Load the report onto the report document. The path should be absolute.
                    oReport.Load(Server.MapPath("Reports/Test.rpt"));
                    //Set the datasource of the report document to the ADO.NET dataset we created
                    oReport.SetDataSource(results);

                    //To set vertical scroll in report
                    CrystalReportViewer1.SeparatePages = false;
                    CrystalReportViewer1.BestFitPage = false;
                    CrystalReportViewer1.Height = Unit.Percentage(dHeight);
                    CrystalReportViewer1.Width = Unit.Percentage(dWidth);
                    CrystalReportViewer1.EnableDrillDown = false;

Error:

Error in File C:\DOCUME~1\sharmv\LOCALS~1\Temp\6\Test {BB804005-7ABE-4AD3-8BB8-AC95709C855D}.rpt: Unable to connect: incorrect log on parameters.

Re: Dataset as Datasouce to Crystal Reports

Error shows that log on parameters are incorrect. Set correct logon parameters after loading the report.

oReport.SetDatabaseLogon("username", "password", "sql-server", "database");

Re: Dataset as Datasouce to Crystal Reports

hi,

I am not using any DB server here.i have a flat file that has a Dataset dump (created using Dataset.WriteXML with schema). I am able to regenerate teh data set on this page however when I bind it, I see only tool bar and this erro mentioning not able to acces file in temp location. Please suggest.

regards,

varun sharma

varun.y.sharma@gmail.com

Re: Dataset as Datasouce to Crystal Reports

try movin xml file to different location as D or E drive. There might be some security issue when communicating with the datasource. Also give some folder permission (read/write). (Right click on the folder>security)

Thanks