please help me solve this crystal report problem

Question

0.00/5 (No votes)

See more:

hi friends,

my code does not working properly.i searched for this problem very and i do not know where is the problem.

this is my code

CrystalReport2 objRpt = new CrystalReport2();
            SqlConnection cnn;
            string connectionString = null;
            string sql = textBox1.Text;
            connectionString="server=localhostDatabase=AhmadfamDatabaseTrusted_Connection=true";
            cnn = new SqlConnection(connectionString);
            cnn.Open();
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet1 ds = new DataSet1();
            dscmd.Fill(ds, "OmdeSell_Table");
            MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
            objRpt.SetDataSource(ds.Tables[1]);
            
            crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();

in the messagebox i can see rows count for example 320 but crystalreportviewer1 does not show any information. i added a property to the app.config file startup tag that is:

useLegacyV2RuntimeActivationPolicy="true"

when i remove this property an error occor that is

C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll

i do not know what to do to solve this problem.i am confused. please help me.

Posted 18-Apr-14 8:56am

_Starbug_

Updated 18-Apr-14 10:35am

v2

Add a Solution

Comments

Kschuler 18-Apr-14 17:15pm

If your report doesn't error out but isn't showing what you expect it to, I'd start with making sure it's setup properly. Is everything properly linked in the Database Expert of your Crystal Report? Are you doing anything special in the report like sub reports or graphs or anything?

_Starbug_ 18-Apr-14 17:31pm

first i added a crystal report to my project. then i select using wizard option for it then i select dataset1 as dataset from my project data(dataset has a datatable with 12 column) for it. and i do not added any information about sub report of group for it.

i added dataset1 for it. when i execute the code in the messagebox count of rows for my query are shown for example 320.

Mahesh@Dev 18-Apr-14 21:18pm

Your Sql query Missing Here...Write Your Full extracted Query For Get Record

_Starbug_ 19-Apr-14 4:41am

full extracted query?what is it? and where i must write it?

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)

Mahesh@Dev · Answer 1 · 2014-04-18T15:22:00

CrystalReport2 objRpt = new CrystalReport2();
SqlConnection cnn;
string connectionString = null;
string sql = "Select * from OmdeSell_Table where Id="+textBox1.text+"";
connectionString="server=localhostDatabase=AhmadfamDatabaseTrusted_Connection=true";
cnn = new SqlConnection(connectionString);
cnn.Open();
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
DataSet1 ds = new DataSet1();
dscmd.Fill(ds, "OmdeSell_Table");
MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
objRpt.SetDataSource(ds.Tables[1]);

crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();