"Carl Henthorn" wrote:

> This is actually very easy to do. First set your parameters up in the layout
> tab by going to Reports-->Report Parameters. Once they are set up, go back to
> your individual data sets, and click on the <...> button to the right of the
> name. Click on Parameters tab, then map your sproc parameters (left column)
> to the Report Parameters that you just set up (right column).
>
> "Aussie Matt" wrote:
>
> > Hello everyone,
> > I am wondering if someone can help me with the following,
> > I have a stored procdure that has 3 variables that need to be passed
> > @X, @Y and @EQ
> >
> > The first two are date serial numbers and the 3rd is a piece of equipment,
> >
> > my question is can I pass a variable to a text based dataset... rather then
> > make it a stored procedure, my reason for this is I want to use the same
> > stored proc to populate 4 different run charts, if I used it as a stored
> > procedure I can only run it once within the same instance, but if I create
> > multiple datasets it should allow me to use the same stored proc mutiple
> > times...
> >
> > so I was thinking the dataset would look somthing like
> > EXEC USP_FMSRX172 'Parameters!X.Value','Parameters!X.Value','SHE22'
> >
> > then to run it again
> > EXEC USP_FMSRX172 'Parameters!X.Value','Parameters!X.Value','SHE33'
> >
> > then again...
> > EXEC USP_FMSRX172 'Parameters!X.Value','Parameters!X.Value','SHE35'
> >
> > this dataset basically produces a table with enough information to create a
> > run chart.
> >
> > I want the Parameters to come from the UI so they can select the date range
> > for the report to run... but of course it's not that simple, is it a simple
> > syntax error I have trying to address it or is this just not possible ?
> >
> > Appreciate any help... or other idea's on how to deal with this
> >