sql server reporting services: Parameters for sp that depend on the current row fields -- sql server reporting services

Parameters for sp that depend on the current row fields

gchinl
6/23/2006 12:44:01 PM

sql server reporting services: How can I specify parameters to a store procedure that depend on a row
without using ado.net in code behind?
The problem is that I use 5 parameters for my store procedure. 2 are report
parameters, and I want other 3 to be specified by the fields of the current
row, in this way the returned value by the store procedure depends on certain
values of each row.
I currently use code behind with Ado.Net to specify the parameters but
opening and closing the connection takes some time (depending on the # of
rows), if I somewhat could call the sp from the given field in the row in
reporting services it would be way faster. Does someone knows of a way to do
this?

Re: Parameters for sp that depend on the current row fields

Bruce L-C [MVP]
6/23/2006 3:39:17 PM

You can embed a subreport in a field of the current row and pass those
fields and parameters to the subreport (I do this). Give it a try, should be
a lot easier and cleaner.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]