Set Crystal Report Parameter in Loop

Question

0.00/5 (No votes)

See more:

hiii,

i want to know how to set paramater of Crystal Report in C# . and this parameter i want to set in Loop.

when i use :

C#

cr.SetParameterValue(0, ds.Tables[0].Rows[0][1].ToString());
cr.SetParameterValue(1, company_name);
cr.SetParameterValue(2, database_name);

this will display only one record but i want to display more record .

Thanks in Advance.
Mitesh

Posted 24-Jun-12 23:50pm

Mits Machhi

Updated 24-Jun-12 23:53pm

bhagirathimfs

v3

Add a Solution

Comments

Erik Rude 25-Jun-12 16:14pm

I don't know Crystal Reports, but maybe if you can work out what the [0][1] in
cr.SetParameterValue(0, ds.Tables[0].Rows[0][1].ToString());
means then you could be on to a winner?

Kschuler 25-Jun-12 17:19pm

This doesn't make a whole lot of sense. Typically paramters are used in a report just once. You can't add the SAME parameter multiple times. You could create a new report with different parameter values. Is that what you want? If not, then you probably need to redesign your report so that the data isn't filtered as much and you will see the records you want.

[no name] 26-Jun-12 0:12am

if i pass two code into report, the report must show that two report name.and i have three parameter used in report. so when i use query it execute for only once not for second. so what can i do to print both that records in Report ?
Please Help 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)

Savalia Manoj M · Accepted Answer · 2012-06-25T16:58:00

Solution 2

If You want to print multiple time same value then set datatable to source. And then print those field in detail section.
Crystal report not support dynamically parameter. Once you add parameter in crystal report that parameter you have to pass.
In your case you want to set it using loop. your datatable contain many record so you have to set it as source and print it in detail section.
Other wise give me your exact definition what you want to print. So i can help you..

Posted 25-Jun-12 16:58pm

Savalia Manoj M

Comments

[no name] 26-Jun-12 0:37am

how i set datatable value in detail section.

Savalia Manoj M 26-Jun-12 0:48am

Set report source as Datatable and then print field on report.

[no name] 26-Jun-12 1:14am

Thank you very much brother.........