Use of Crystal report parameter

Question

0.00/5 (No votes)

See more:

I can pass parameter from SQL QUERY to create crystal report. But in crystal report we can create parameters. When should we create parameter from crystal report instead of sql query. Which is the best. Please discuss details with example as I am new in crystal report.

Posted 23-Apr-13 21:02pm

Sumon562

Add a Solution

Comments

Prasad Khandekar 24-Apr-13 3:23am

I think you are getting confused between these two parammeters. The query parameters are generally used to filter out data. The crystal report parameters are used to supply the filter values to be used in the query written inside the Crystal Report Definition.

If we do not have such a mechanism then all queries inside Crystal Reports will become kind of static/fixed queries, Which may render them useless.

Sumon562 24-Apr-13 5:34am

Thank you Mr.Prasad Khandekar for your kind response. If you explain details it will be better for me.

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)

thatraja · Answer 1 · 2013-10-19T22:54:00

The difference is using SQL query you could only filter data but Parameter fields not only filter data, you could do some dynamic things like show/hide fields, etc.,
Agree with Prasad. Using Parameter fields you could filter the data easily & dynamically. Let me show you few examples.
C# Crystal Reports String parameter[^]
C# Crystal Reports Integer parameter[^]
C# Crystal Reports Date parameter[^]
C# Crystal Reports - Date to Date[^]
And you can't use SQL query way in PUSH method(C# Crystal Reports without database[^]), there you need parameter fields.
Also you could use parameter fields with other fields like formulas, etc.,