Passing Parameter to dataset -- sql server reporting services

dean
3/10/2005 2:01:09 PM

I am trying to modify a MOM report that uses a function with a hardcoded
parameter to get @StartDate and @EndDate. I would like to add a report
parameter to be able to schedule daily, weekly and monthly reports. I have
created a parameter @Period and assigned it values but I can not pass the
parameter to the dataset.

I am wondering if I created the parameter correctly.

Thanks

Dean

The dataset is CurrentDate and its code is

SELECT *
FROM dbo.fn_GetDateRange(7) fn_GetDateRange

I would like make it
SELECT *
FROM dbo.fn_GetDateRange(@Period) fn_GetDateRange

where @Period could be
Daily 1
Weekly 7
Monthly 30

pmud
3/10/2005 2:37:04 PM

Hi Dean,
I dont think for scheduling weekly or monthly reports you need to add a
parameter in code. Did you have a look at the Swl reporting Services books
Online Walkthrough - Creating a Data-Driven Subscription? Try it. In the end
in the Report manager this walkthrough shows that you can check the box for
scheduling reports weekly or monthly...

I hope that helps..

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Passing Parameter to dataset