Hello, I havent been able to set parameters with the reportexecutionservice.
I also need to send a multivalue parameter, any ideas?
ExecutionInfo execInfo;
execInfo = rs.LoadReport(path, null);
ReportParameter pEmpresa = new ReportParameter()
pEmpresa = (ReportParameter)DropDownList1.SelectedValue;
execInfo.Parameters[0] = pEmpresa;
execInfo.Parameters[1] = DropDownList2.SelectedValue;
//rs.SetExecutionParameters();
StringBuilder selectected = new StringBuilder();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items
.Selected)
{
selectected.Append(CheckBoxList1.SelectedValue);
selectected.Append(",");
}
}
execInfo.Parameters[2] = selectected;
But I have the following errors
Error 13 Cannot convert type 'string' to 'RSExecution.ReportParameter' C:\Inetpub\wwwroot\GescomDllo\Protected\01_Administradores\rpt_clasificacioncompetencias.aspx.cs 550 20 http://localhost/GescomDllo/
Error 14 Cannot implicitly convert type 'string' to 'RSExecution.ReportParameter' C:\Inetpub\wwwroot\GescomDllo\Protected\01_Administradores\rpt_clasificacioncompetencias.aspx.cs 553 34 http://localhost/GescomDllo/
Error 15 Cannot implicitly convert type 'System.Text.StringBuilder' to 'RSExecution.ReportParameter' C:\Inetpub\wwwroot\GescomDllo\Protected\01_Administradores\rpt_clasificacioncompetencias.aspx.cs 568 34 http://localhost/GescomDllo/
I solved it a little , but I am still having problems with multivalue parameters
ExecutionInfo execInfo;
execInfo = rs.LoadReport(path, null);
ParameterValue pNmEmpresa= new ParameterValue();
pNmEmpresa.Name = "NmEmpresa";
pNmEmpresa.Value = DropDownList1.SelectedValue;
ParameterValue pNmCiclo = new ParameterValue();
pNmCiclo.Name = "NmCiclo";
pNmCiclo.Value = DropDownList2.SelectedValue;
////rs.SetExecutionParameters();
StringBuilder selectected = new StringBuilder();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items.Selected)
{
selectected.Append(CheckBoxList1.SelectedValue);
selectected.Append(",");
}
}
ParameterValue pNmTiposCompetencia = new ParameterValue();
//pNmTiposCompetencia.Name = "NmTipoCompetencia";
//pNmTiposCompetencia.Value = "12";
string[] nmtiposcompetencia = selectected.ToString().Split(new char[] { ',' });
for (int i=0; i <= nmtiposcompetencia.Length ; i++)
{
pNmTiposCompetencia.Name = "NmTipoCompetencia";
pNmTiposCompetencia.Value = nmtiposcompetencia;
//pNmTiposCompetencia.Value = "12";
}
ParameterValue[] parametros = new ParameterValue[3]{pNmEmpresa,pNmCiclo,pNmTiposCompetencia};
rs.SetExecutionParameters(parametros, null);
|||
Almost done, I hardcoded the parameters and I saw that each value selected in the checkboxlist is a parameter, so thats a problem because I cant know the number of parameters
I am trying something like this with no luck yet,
I hope somebody to give me a hand.
The 2 constant is because I already know to parameters that come from two different dropdownlist.
StringBuilder selectected = new StringBuilder();
int TiposCompetenciasSeleccionadas = 0;
ArrayList al = new ArrayList();
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items.Selected)
{
selectected.Append(CheckBoxList1.SelectedValue);
selectected.Append(",");
al.Add(CheckBoxList1.SelectedValue);
TiposCompetenciasSeleccionadas++;
}
}
ParameterValue[] parametros = new ParameterValue[2 + TiposCompetenciasSeleccionadas] { pNmEmpresa, pNmCiclo };
for (int i = 0; i < parametros.Length; i++)
{
parametros[i+2].Name ="NmTipoCompetencia";
parametros[i+2].Value = al;
}
string[] nmtiposcompetencia = selectected.ToString().Split(new char[] { ',' });
rs.SetExecutionParameters(parametros, null);
