This is a migrated thread and some comments may be shown as answers.

Stored Procedure / Report Parameters

0 Answers 171 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 15 Mar 2012, 09:02 PM
* RESOLVED - Looks like this was a PEBKAC error.  I recreated the report this morning and it works great.  Thanks!

It doesn't look like my report parameters are being passed through to the stored procedure in the data source.  I'm on the trial version of Q1 2012.

Using the wizard, I created a simple report in an ASP.NET Web application that pulls data from a stored procedure with a single parameter.  In the properties of the SQLDataSource I selected, "<New Report Parameter>" and created a report parameter assigned to the stored procedure parameter.  At run time I display the report using the following code,

Dim _Report As New TSVStandardReports.Rpt_TelerikCustomersWithTwentyAccounts
DirectCast(_Report.DataSource, Telerik.Reporting.SqlDataSource).ConnectionString = sConnectionString
_Report.ReportParameters("BranchID").Value = "42"
ReportViewer1.Report = _Report


Seems pretty straight forward, but at run time the value "42" is not passed to my stored procedure.  What am I missing?

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
David
Top achievements
Rank 1
Share this question
or