How To Slove This In CrystalReport

Question

1.00/5 (1 vote)

See more:

Hi, i have try to bind Crystal with using Datatable

My Code:

C#

cnn.Open();
            DataTable dt1 = new DataTable();
            dt1 = Dt_Args("select EmpNameC  from  ShiftTable where dated'01/Oct/2014'and empcodeC='18'"); // Dt_Args method to execute datatable

            DataSet ds = new DataSet();
            ds.Tables.Add(dt1);
           
            objRpt.SetDataSource(ds);
            crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();

it run without any issue but not showing in crystal report.

Posted 16-Oct-14 22:08pm

prasanna.raj

Updated 16-Oct-14 22:56pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

NaibedyaKar · Answer 1 · 2014-10-16T23:39:00

Solution 1

Can you try with this

C#

ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath("CrystalReportTest.rpt"));
rptDoc.SetDataSource(ds.Tables["YourTable"]);
crystalReportViewer1.ReportSource = rptDoc;
crystalReportViewer1.Refresh();

Posted 16-Oct-14 23:39pm

NaibedyaKar

Comments

prasanna.raj 17-Oct-14 5:49am

Still not showing to crystal Rpt

cnn.Open();
DataTable dt1 = new DataTable();
dt1 = Dt_Args("select EmpNameC from ShiftTable where dated = '01/Oct/2014'and empcodeC='18'"); // Dt_Args method to execute datatable
DataSet ds = new DataSet();
ds.Tables.Add(dt1);
rptDoc.Load(@"E:\Prasanna\WindowsApplication\DynamicCrys_SAMPLE\DynamicCrys_SAMPLE\CrystalReport1.rpt");
rptDoc.SetDataSource(ds.Tables["ShiftTable"]);
crystalReportViewer1.ReportSource = rptDoc;
crystalReportViewer1.Refresh();

NaibedyaKar 17-Oct-14 8:15am

Did you add the fields on the report viewer?

prasanna.raj 18-Oct-14 1:54am

Yes i Added..

NaibedyaKar 18-Oct-14 2:02am

Hmm, ok. Did you check the data in the table is coming fine?