Hi Nay,
1. A column on the first DS can provide the (default) value for a
parameter. This parameter can be used in the second DS. Any input
parameters to the first DS need to be appear first in order.
2. You cant use output parameters directly, but can use some SQL to
call your sproc and then return the output as a resultset: SELECT @p1,
@p2 ...
[quoted text, click to view] Nay wrote:
> hi
> I have 2 problems:
> 1)I have a report the its datasources are 2 dataset, but the parameters of
> the eSP that populate the 2nd Dataset shgould be taken fri=om the first DS
> results?
> Is it possible to control the order and use it?
> A solution I thought about is instaed of use the 2nd DS, use a custom
> assembly, but than, where can I take the connection string from?
> 2)The sp I use Is a generic one and has output params, is it possible to use
> them in RS 2005?
>
> Thanks, Yanir
Consider using subreports.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
[quoted text, click to view] "Nay" <Nay@discussions.microsoft.com> wrote in message
news:AEB723D2-9D07-46C0-8373-3D5C88B3241F@microsoft.com...
> hi
> I have 2 problems:
> 1)I have a report the its datasources are 2 dataset, but the parameters of
> the eSP that populate the 2nd Dataset shgould be taken fri=om the first DS
> results?
> Is it possible to control the order and use it?
> A solution I thought about is instaed of use the 2nd DS, use a custom
> assembly, but than, where can I take the connection string from?
> 2)The sp I use Is a generic one and has output params, is it possible to
> use
> them in RS 2005?
>
> Thanks, Yanir
