no data is displaying in crystal report. where is error. ? help me with this. ThanX

Question

0.00/5 (No votes)

See more:

String query = "Select a.Account_No,d.Transaction_No,d.Amount_Debit,d.Debit_Date,d.Total_Amount_Debit,c.Transaction_No,c.Amount_Credit,c.Credit_Date,c.Total_Amount_Credit from Account_Debit d,Account_Credit c,Accounts a where c.Account_No=d.Account_No and d.Transaction_No=c.Transaction_No";

              da = new SqlDataAdapter(query, cn);
                   DataTable dt = new DataTable();
                   da.Fill(dt);
                   if (dt.Rows.Count == 0)
                   {
                       MessageBox.Show("The Complete Info of Account No'" + cboaccount1.Text + "-" + cboaccount2.Text + "'does not Exists!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                       cboaccount1.SelectAll();
                       cboaccount1.Focus();
                   }
                   else
                   {


                       DebitCrdit_rpt crt = new DebitCrdit_rpt();

                        crt.SetDataSource(dt);
                        Report_Viewer rpt = new Report_Viewer();
                        this.Close();
                        rpt.Show();
                        rpt.crystalReportViewer1.ReportSource = crt;
                        rpt.crystalReportViewer1.Refresh();
                        dt.Clear();
                        cn.Close();
                   }


               }
   }

Posted 6-Jan-13 23:37pm

zeshanazam

Add a Solution

Comments

bbirajdar 7-Jan-13 6:19am

I tried executing the query.. It seems the database table does not have any data.. So it is not displayed

2 solutions

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)

Aarti Meswania · Answer 1 · 2013-01-07T00:12:00

Solution 1

in else part...

VB

ReportDocument crt=New ReportDocument();
crt.Load("PUT CRYSTAL REPORT PATH HERE\DebitCrdit_rpt.rpt")
Report_Viewer rpt = new Report_Viewer();
crt.SetDataSource(dt);
crt.Database.Tables(0).SetDataSource(dt);
rpt.crystalReportViewer1.ReportSource = crt;
rpt.crystalReportViewer1.Refresh();
this.Close();
rpt.Show();
cn.Close();

Happy Coding!
:)

Posted 7-Jan-13 0:12am

Aarti Meswania

Updated 7-Jan-13 0:31am

v6

Comments

zeshanazam 7-Jan-13 6:17am

ThanX but same problem exists

Aarti Meswania 7-Jan-13 6:21am

please check updated solution
and make sure datatable Dt have records (debug and check)

zeshanazam 7-Jan-13 6:23am

datatable dt have records

zeshanazam 7-Jan-13 6:22am

Non-invocable member 'CrystalDecisions.CrystalReports.Engine.Database.Tables' cannot be used like a method.

Aarti Meswania 7-Jan-13 6:28am

sorry 'Database.Tables' used when accessing Reportdocument's object

zeshanazam 7-Jan-13 6:29am

same error

Aarti Meswania 7-Jan-13 6:32am

try now
if it still not support line
crt.Database.Tables(0).SetDataSource(dt);
then comment this line

Aarti Meswania 7-Jan-13 6:33am

also make sure you have give right path for report
in cr.Load(...)

zeshanazam 7-Jan-13 6:36am

not working :(

Aarti Meswania 7-Jan-13 6:36am

any error?

zeshanazam 7-Jan-13 6:38am

nope...dt is fill.. path is correct.....is there any error in query ???

Aarti Meswania 7-Jan-13 6:39am

you mean report is opened but not showing data?

zeshanazam 7-Jan-13 6:40am

yup, data is not showing..

Aarti Meswania 7-Jan-13 6:42am

have you dragdrop fields in report and saved it properly
check the report sections or fields are not suppressd

zeshanazam 7-Jan-13 6:55am

every thing is ok....Oh GOD...

zeshanazam 7-Jan-13 6:53am

yeah dragdropped......ok i m checking :)

Aarti Meswania 7-Jan-13 7:00am

ok now the last thing is remained to try

create constructor in your form Report_Viewer
that accepts datatable as argument
then inside that after InitializeComponent called.

ReportDocument crt=New ReportDocument();
crt.Load("PUT CRYSTAL REPORT PATH HERE\DebitCrdit_rpt.rpt")
crt.SetDataSource(dt);
crt.Database.Tables(0).SetDataSource(dt);
crystalReportViewer1.ReportSource = crt;
crystalReportViewer1.Refresh();

and now, in else part code will be...
Report_Viewer rpt = new Report_Viewer(dt);
this.Close();
rpt.Show();
dt.Clear();
cn.Close();

Hope it works :)

zeshanazam 7-Jan-13 7:01am

i created new report, but problem exists

Aarti Meswania 7-Jan-13 7:02am

try that code I have suggest just now in last comment

Bala Selvanayagam · Answer 2 · 2013-01-07T22:34:00

Could you replace your else part below

else
     {


         DebitCrdit_rpt crt = new DebitCrdit_rpt();

          crt.SetDataSource(dt);
          Report_Viewer rpt = new Report_Viewer();
          this.Close();
          rpt.Show();
          rpt.crystalReportViewer1.ReportSource = crt;
          rpt.crystalReportViewer1.Refresh();
          dt.Clear();
          cn.Close();
     }

with

else
                  {


                      DebitCrdit_rpt crt = new DebitCrdit_rpt();

                       crt.SetDataSource(dt);
                       rpt.crystalReportViewer1.ReportSource = crt;
                       rpt.crystalReportViewer1.Refresh();
                       dt.Clear();
                       cn.Close();
                  }

and should work, any issues let me kow