Crystal report without database (with dataset) - Error: The report you requested requieres further information

Question

Hello,

I am using VS2008 in order to create a web application. I try to create a crystal report.

In the class where I have put the crystalreportviewer, I have the next code:

            DataRow row;
            DataSet_Report ds = new DataSet_Report();

            row = ds.Tables["DataTable1"].NewRow();
            row["Column1"] = "Test 1";
            row["Column2"] = "Test 2";
            ds.Tables["DataTable1"].Rows.Add(row);

            CrystalReportViewer1 = new CrystalDecisions.Web.CrystalReportViewer();
            CReport obj_report = new CReport();
            obj_report.Load(Server.MapPath("CReport.rpt"));
            obj_report.SetDataSource(ds);
            CrystalReportViewer1.ReportSource = obj_report;

            CrystalReportViewer1.RefreshReport();

The problem is that when I execute the application, it appears the window where you have to introduce database name, user, password with the message: "The report you requested requieres further information", and I am not using any database...

Do you know where the problem could be?

Thank you very much!

Regards!

Answer 1

Hello!

I found something interesting:

If the dataset has just one table (like my case), then you have to pass just the table and not the dataset: obj_report.SetDataSource(ds.Tables[DataTable1]);

Now I have changed this line, so the code is:

            DataRow row;
            DataSet_Report ds = new DataSet_Report();

            row = ds.Tables["DataTable1"].NewRow();
            row["Column1"] = "Test 1";
            row["Column2"] = "Test 2";
            ds.Tables["DataTable1"].Rows.Add(row);

            CrystalReportViewer1 = new CrystalDecisions.Web.CrystalReportViewer();
            CReport obj_report = new CReport();
            obj_report.Load(Server.MapPath("CReport.rpt"));
            obj_report.SetDataSource(ds.Tables["DataTable1"]);
            CrystalReportViewer1.ReportSource = obj_report;

            CrystalReportViewer1.RefreshReport();

And now I receive other error:

Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:\DOKUME~1\pmike\LOKALE~1\Temp\CR_MyProject {DB7787A7-9EC3-47CB-A1C1-DCA1EF19F63C}.rpt: Unable to connect: incorrect log on parameters.

Do you know where the problem could be?


Thank you!

Answer 2

Hello,

After trying and searching about the problem, I got it:

The right code is:

 

            DataRow row;
            DataSet_Report ds = new DataSet_Report();

            row = ds.Tables["DataTable1"].NewRow();
            row["Column1"] = "Test 1";
            row["Column2"] = "Test 2";
            ds.Tables["DataTable1"].Rows.Add(row);

            CReport obj_report = new CReport();
            obj_report.SetDataSource(ds.Tables["DataTable1"]);
            CrystalReportViewer1.ReportSource = obj_report;

            

I hope it will be useful for others,

Regards!