471,350 Members | 1,669 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

c# Crystal Report SetParameter question

Hi,

In my C# windows form project, it has a form frmReport and a crystal report
rptCustomer.
The rptCustomer has 2 parameters, CustID and CustName.
Saying now in my frmReport, I build a DataSet rDS on the runtime and it has
a DataTable MyTable which has data like this:

00000001 John Doe
00000002 Lio Smith
00000003 Mary Jordan

And this part of my code in frmReport:

for (int j=0; j<rDS.Tables["MyTable"].Rows.Count; j++)
{
rpt.SetParameterValue("CustID",rDS.Tables["MyTable"].Rows[j][0].ToString());
rpt.SetParameterValue("CustName",rDS.Tables["MyTable"].Rows[j][1].ToString());
}
crystalReportViewer1.ReportSource=rpt;

The result is in the rptCustomer it will show only the last data "0000003
Mary Jordan",
but the other record will not show up!
I am wondering how to let the other data "000000001 John Doe", "00000002 Lio
Smith" show up in the rptCustomer.
Thanks for help.
Jason
Feb 11 '06 #1
1 4157
Hi Jason,

Your code seems like you are overwriting the values everytime.
Alternate can be add the values to a Arraylist and call
SetParameterValue method. It would solve your problem.

Try the below link to solve for more information.

http://msdn2.microsoft.com/en-us/library/ms227722.aspx

Cheers,
Kris

Feb 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by rAGHU | last post: by
1 post views Thread by Stephan | last post: by
1 post views Thread by Jason Chan | last post: by
4 posts views Thread by Rick Thiel | last post: by
2 posts views Thread by aldous scotch | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.