Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Feb 24, 2014 9:09 pm**

Hi, my name is fabio and here I am new and I try this software for my company.

I build a report and I need add one or more parameters at runtime:

this is my code:

Code: Select all

                        rep.Dictionary.DataSources[indexDS].Parameters.Add(new StiDataParameter()
                        {
                            Name = name,
                            DataSource = rep.Dictionary.DataSources[indexDS],
                            ParameterValue = value
                        });

but this is not work fine.

message error:"exceps the parameter '@p1', which was not supplied."

can you help me?

thanks
Fabio

Posted: **Tue Feb 25, 2014 7:06 am**

Hello,

Can you please describe your issue in more details. Also please send us a sample which reproduce the issue for analysis.

Thank you.

Posted: **Tue Feb 25, 2014 8:49 am**

ok, I fix it

this is my new code:

Code: Select all

            (rep.Dictionary.DataSources[0] as Stimulsoft.Report.Dictionary.StiSqlSource).AddParameter("@p1", "", System.Data.SqlDbType.Decimal, 18);
            rep["@p1"] = 5d;

            var source = (rep.Dictionary.DataSources[0] as Stimulsoft.Report.Dictionary.StiSqlSource);
            source.SqlCommand = string.Format("{0} {1}", source.SqlCommand, " where pvendpub<=@p1");

thank you

Posted: **Tue Feb 25, 2014 10:48 am**

Hello,

Ok.
Let us know if you need any additional help.

Creating reports and dashboards | Stimulsoft community forum

issue for add parameter from code

issue for add parameter from code

Re: issue for add parameter from code

Re: issue for add parameter from code

Re: issue for add parameter from code