Creating reports and dashboards | Stimulsoft community forum

Hi....

i am passing the value to parameters in the report in the format:

stiSales_Order_Print.Complie();
stiSales_Order_Print.CompiledReport.DataSources["Sales_Order_Print"].Parameters["@SalesOrderNo"].ParameterValue = orderNumber;
stiSales_Order_Print.CompiledReport.DataSources["Sales_Order_Print"].Parameters["@SalesOrderDate"].ParameterValue = orderDate;
stiSales_Order_Print.CompiledReport.DataSources["Sales_Order_Print"].Parameters["@Customer"].ParameterValue = Customer;

N i am calling the stored procedure in my report and passing the values to stored procedure with the help for parameter....
it works fine...

Now some time i may be passing Null value also those parameters in the report as users may not provide any value and would like to genrate the report...How to do that???

Thanks....

Hello,

Use following code:

stiSales_Order_Print.CompiledReport.DataSources["Sales_Order_Print"].Parameters["@SalesOrderNo"].ParameterValue = DBNull.Value;

Thank you.