Dynamic Crystal report

Question

0.00/5 (No votes)

See more:

I am trying to create dynamic crystal report. First I took a dataset,then data table . Then I took a crystal report and bind it with the data Table,within the dataset. Now I am trying to retrieve data from a table at runtime and trying to display them in the crystal report. But I am unable to do that. If anybody help me,I will be great full to him for ever. Thank you

Edit: Added code from comment below.
I use the bellow code. I do not get any error message.

C#

SqlCommand com = new SqlCommand("query string", con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet1();
DataTable dt = new DataTable();
da.Fill(dt);
ds.Tables[0].Merge(dt);
ReportDocument rdoc = new ReportDocument();
rdoc.Load(Server.MapPath("CrystalReport4.rpt"));
if (ds.Tables[0].Rows.Count > 0)
{
   rdoc.SetDataSource(ds);
   CrystalReportViewer1.ReportSource = rdoc;
}

Posted 23-May-11 7:31am

manabjn

Updated 23-May-11 8:35am

Sander Rossel

v2

Add a Solution

Comments

thatraja 23-May-11 12:33pm

Any error message? if yes then include that in your question.

manabjn 23-May-11 13:24pm

Sir, i use the bellow code.I do not get any error message.
SqlCommand com = new SqlCommand("query string", con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet1();
DataTable dt = new DataTable();
da.Fill(dt);
ds.Tables[0].Merge(dt);
ReportDocument rdoc = new ReportDocument();
rdoc.Load(Server.MapPath("CrystalReport4.rpt"));
if (ds.Tables[0].Rows.Count > 0)
{
rdoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rdoc;
}
please help me

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-05-23T08:22:00

Have a look at these articles to get equipped with knowledge needed for it:
Idiot's Guide to Crystal Reports, Part I - Winforms[^]
Dynamic Crystal Reports Viewing[^]
Dynamic Crystal Report with C#[^]

Few features step-by-step:
Introductions to Crystal Reports in .NET[^]
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

Read and try!

thatraja · Answer 2 · 2011-05-23T09:08:00

OK Try my suggestions....

Verify database in the report
Confirm you have data in the dataset or datatable
Give the name for Dataset & Datatable same as in the report.

Table1

DataTable dt = new DataTable("Table1");

Dataset1

DataSet ds = new DataSet1("Dataset1");

Further reading
Crystal Report Blank / Empty / Not Displaying. No On-Screen Error, But Event Log ‘ConfigurationErrorsException’ Received[^]

Let me know....

Dynamic Crystal report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Dynamic Crystal report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us