Setting parameters on Crystal Report - Urgent

[Soren S. Jorgensen]

Hi,

I've got a Crystal Report that gets some data from a stored procedure and I
need to set some params of the proc at runtime.
But no matter what I do, I cannot get the report to eat the params - it
keeps showing an error that the proc needs to have it's params initialized.

Code's something like:

ConnectionInfo ci = new ConnectionInfo( );
ci.ServerName = sqlServer;
ci.DatabaseName = sqlDatabase;
ci.UserID = sqlUser;
ci.Password = sqlPassword;

TableLogOnInfo ti = new TableLogOnInfo( );
ti.ConnectionIn fo = ci;

ReportDocument doc = new ReportDocument( );
doc.Load(report Doc); // Some .rpt file
doc.SetDatabase Logon(sqlUser, sqlPassword);

foreach(Table t in doc.Database.Ta bles)
{
t.ApplyLogOnInf o(ti);
if(!t.TestConne ctivity())
{
return -2;
}
}

ParameterFieldD efinitions pfds = doc.DataDefinit ion.ParameterFi elds;
for(int i = 0; i < 3; i++)
{
string name = "";
string value = "";

switch(i)
{
case 0:
name = "@ItemName" ;
value = "ZZZZZ";
break;
case 1:
name = "@ItemCount ";
value = "10";
break;
case 2:
name = "@ItemOptio n";
value = "0";
break;
}

ParameterDiscre teValue pdv = new ParameterDiscre teValue();
pdv.Value = value;

ParameterValues pvs = new ParameterValues ();
pvs.Add(pdv);

ParameterFieldD efinition pfd = pfds[name];
pfd.ApplyCurren tValues(pvs);
}

_reportViewer.R eportSource = doc;

Running through the params before setting the report on the viewer tells me
that all params has a current value!
Where am I getting wrong, or what am I missing to do ??

Thanks in advance

Soren

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
I always use ReportDocument. SetParameterVal ue( "ParameterN ame" ,
par_value );

I have never have any problem with it.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Soren S. Jorgensen" <no****@nodomai n.com> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl...

Hi,

I've got a Crystal Report that gets some data from a stored procedure and
I need to set some params of the proc at runtime.
But no matter what I do, I cannot get the report to eat the params - it
keeps showing an error that the proc needs to have it's params
initialized.

Code's something like:

ConnectionInfo ci = new ConnectionInfo( );
ci.ServerName = sqlServer;
ci.DatabaseName = sqlDatabase;
ci.UserID = sqlUser;
ci.Password = sqlPassword;

TableLogOnInfo ti = new TableLogOnInfo( );
ti.ConnectionIn fo = ci;

ReportDocument doc = new ReportDocument( );
doc.Load(report Doc); // Some .rpt file
doc.SetDatabase Logon(sqlUser, sqlPassword);

foreach(Table t in doc.Database.Ta bles)
{
t.ApplyLogOnInf o(ti);
if(!t.TestConne ctivity())
{
return -2;
}
}

ParameterFieldD efinitions pfds = doc.DataDefinit ion.ParameterFi elds;
for(int i = 0; i < 3; i++)
{
string name = "";
string value = "";

switch(i)
{
case 0:
name = "@ItemName" ;
value = "ZZZZZ";
break;
case 1:
name = "@ItemCount ";
value = "10";
break;
case 2:
name = "@ItemOptio n";
value = "0";
break;
}

ParameterDiscre teValue pdv = new ParameterDiscre teValue();
pdv.Value = value;

ParameterValues pvs = new ParameterValues ();
pvs.Add(pdv);

ParameterFieldD efinition pfd = pfds[name];
pfd.ApplyCurren tValues(pvs);
}

_reportViewer.R eportSource = doc;

Running through the params before setting the report on the viewer tells
me that all params has a current value!
Where am I getting wrong, or what am I missing to do ??

Thanks in advance

Soren