Parameter is not Valid

Question

0.00/5 (No votes)

See more:

I am using this code for printing Crystal report with Button Click event its giving me this error while printing

Parameter is not valid.

this my code

C#

protected void Button3_Click(object sender, EventArgs e)
{
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataTable dt = new DataTable();
    DataTable dt1 = new DataTable();

    string query;
   
        con.Open();
        query = "select * from Transactions where id='" + TextBox1.Text + "'";
        cmd = new SqlCommand(query, con);
        cmd.Parameters.Add("@id", SqlDbType.Decimal).Value = TextBox1.Text;
        da = new SqlDataAdapter(cmd);
        dt.Clear();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
           
            ReportDocument Report = new ReportDocument();
            Report.Load(Server.MapPath("~/CrystalReport.rpt"));
            Report.SetDataSource(dt);
            TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            Tables CrTables;
            Report.SetDatabaseLogon("sa", "123456789", @"server", "report");
            CrystalReportViewer1.ReportSource = Report;
            CrystalReportViewer1.ReportSource = Report;
            CrystalReportViewer1.DataBind();
            CrTables = Report.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
            {
                crtableLogoninfo = CrTable.LogOnInfo;
                crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                CrTable.ApplyLogOnInfo(crtableLogoninfo);
            }

            Report.Refresh();
            Report.PrintToPrinter(1, true, 1, 1); // ERROR : Parameter is not valid 
        }
    }

Posted 27-Nov-12 0:02am

Mohammed Abdul Muqeet

Updated 27-Nov-12 0:06am

Karthik Harve

v2

Add a Solution

Comments

Karthik Harve 27-Nov-12 6:06am

[Edit] pre tags added.

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)

OriginalGriff · Answer 1 · 2012-11-27T00:11:00

Solution 1

You aren't using the parameter:

C#

query = "select * from Transactions where id='" + TextBox1.Text + "'";
cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@id", SqlDbType.Decimal).Value = TextBox1.Text;

In this case, the parameter is @id which you don't refer to and which desn't contain a Decimal value - it is text. Change it to:

C#

query = "select * from Transactions where id=@id";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", TextBox1.Text);

And it should solve your problem.

Posted 27-Nov-12 0:11am

OriginalGriff

Comments

Mohammed Abdul Muqeet 27-Nov-12 6:53am

i tried this still same error
Parameter is not valid.

Mohammed Abdul Muqeet 27-Nov-12 6:55am

the crystal report is Hidden i just want the print out of the crystal report ..
when i try visible crystal report its giving me this error

Microsoft JScript runtime error: 'Sys.Application' is null or not an object

Mohd. Mukhtar · Answer 2 · 2012-11-27T00:13:00

Hi,

Write your code as below.

C#

protected void Button3_Click(object sender, EventArgs e)
{
    SqlCommand cmd = null
    SqlDataAdapter da = null;
    DataTable dt = new DataTable();
    DataTable dt1 = new DataTable();
 
    string query;
   
        con.Open();
        query = "select * from Transactions where id='" + TextBox1.Text + "'";
        cmd = new SqlCommand(query, con);        
        da = new SqlDataAdapter(cmd);
        dt.Clear();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
           
            ReportDocument Report = new ReportDocument();
            Report.Load(Server.MapPath("~/CrystalReport.rpt"));
            Report.SetDataSource(dt);
            TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            Tables CrTables;
            Report.SetDatabaseLogon("sa", "123456789", @"server", "report");
            CrystalReportViewer1.ReportSource = Report;
            CrystalReportViewer1.ReportSource = Report;
            CrystalReportViewer1.DataBind();
            CrTables = Report.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
            {
                crtableLogoninfo = CrTable.LogOnInfo;
                crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                CrTable.ApplyLogOnInfo(crtableLogoninfo);
            }
 
            Report.Refresh();
            Report.PrintToPrinter(1, true, 0, 0); 
        }
    }