Prevent default "Enter Parameter Value" using C#

Question

0.00/5 (No votes)

See more:

I have a form with CrystalReportViewer and on the top there are two DateTimePickers with on button for generating a crystal report with the selected date range, this is my code its work, but my question is how can I Prevent default "Enter Parameter Value" dialog box display, because I want to use only my datetimepickers.

C#

private void button1_Click_1(object sender, EventArgs e)
        {
            ReportDocument RepDoc = new ReportDocument();
            RepDoc.Load(@"C:****I Put the path of report here");
            SqlConnection con = new SqlConnection(@"I Put the Data Source here");
            SqlDataAdapter sda = new SqlDataAdapter("Select * from Items", con);
            StockDBDataSet ds = new StockDBDataSet();
            sda.Fill(ds, "Items");
            RepDoc.SetDataSource(ds);
            ParameterFieldDefinitions ParameterFieldDefinitions;
            ParameterFieldDefinition ParameterFieldDefinition;
            ParameterValues ParameterValues = new ParameterValues();
            ParameterDiscreteValue ParameterDiscreteValue = new ParameterDiscreteValue();

            ParameterDiscreteValue.Value = dateTimePicker1.Value;
            ParameterFieldDefinitions = RepDoc.DataDefinition.ParameterFields;
            ParameterFieldDefinition = ParameterFieldDefinitions["Start_Date"];
            ParameterValues = ParameterFieldDefinition.CurrentValues;

            ParameterValues.Clear();
            ParameterValues.Add(ParameterDiscreteValue);
            ParameterFieldDefinition.ApplyCurrentValues(ParameterValues);

            ParameterDiscreteValue.Value = dateTimePicker2.Value;
            ParameterFieldDefinitions = RepDoc.DataDefinition.ParameterFields;
            ParameterFieldDefinition = ParameterFieldDefinitions["End_Date"];
            ParameterValues = ParameterFieldDefinition.CurrentValues;

            ParameterValues.Clear();
            ParameterValues.Add(ParameterDiscreteValue);
            ParameterFieldDefinition.ApplyCurrentValues(ParameterValues);

            crystalReportViewer1.ReportSource = RepDoc;
            crystalReportViewer1.Refresh();
        }

Posted 31-Oct-15 0:14am

R.M49

Add a Solution

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)

BillWoodruff · Answer 1 · 2015-10-31T01:25:00

Solution 1

CodeProject is your friend; the sooner you learn to use the search facility here, the more productive you'll be :) See Thatraja's answer here: [^].

And, since you know how to post a question on StackOverFlow, why not also easily find an answer there: [^].

Posted 31-Oct-15 1:25am

BillWoodruff

Comments

R.M49 31-Oct-15 7:34am

I copy this code and used it exactly but it also show the "Enter Parameter Value"

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-date-parameter.htm

**Debojyoti Saha** · Answer 2 · 2015-10-31T01:35:00

To set parameter on crystal I always do it this way:

C#

ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(reportPath);
reportDocument.SetParameterValue("@id", YourParameterValue);

if you want to convert your report to a pdf:

C#

var exportOptions = reportDocument.ExportOptions;
exportOptions.ExportDestinationType = ExportDestinationType.NoDestination;
exportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
var req = new ExportRequestContext {ExportInfo = exportOptions};
var stream = reportDocument.FormatEngine.ExportToStream(req);

this returns you back a filestream that you can open from the aspx page.