Skip to Content
0
Former Member
Apr 01, 2010 at 08:12 PM

VB .NET Parameter Passing

151 Views

This is a report That I have been working on for quite some time. I am using Visual Studio VB .NET 2005, CR 2008, SQL Server 2008, BOBJ Edge 3.1.

I have created a report where the datasource comes from a SQL Server stored procedure. That sproc has parameters that are added to the parameter fields on the report automatically. I have created more parameters on the report side that are both optional and multiple value. I can run the report locally using many different variations of my report side parameters and everything works as expected. Example: If I add nothing to the optional parameters then I get expected results. If I add one value to the parameter(s) then I get expected results. If I add more than one parameter(s) then I get expected results.

I then save the report to the Edge Enterprise. I then schedule the report via my VB .NET program passing in parameters. As long as I pass parameters to the report side optional parameters everything runs fine. What I don't know how to do is get the report to run when nothing is sent to the optional parameters. The report comes back with no data.

Moved the code below to retain the formatting

Edited by: Don Williams on Apr 17, 2010 8:20 PM