say if i have a report that takes 2 parameters, StartDate & EndDate. and i want to publish/deploy this report for other users to run. Will the user be prompted to enter the 2 dates when they attempt to run the report?
sorry for the "what if" type question. ive been asked to do a bit of research on SQL Reporting Services
Cheers,
Craig
This depends on the report setup and on the method of access.
By report setup I mean the parameter. You can configure these with defaults and hence the users won't need to select the values but will still have the option to change the defaults.
By method of access I mean whether you are using the report manager (or some equivalent method of URL access) or the ReportServerWebService.Render method. By using URL access you get the "out of the box" export toolbar and parameter toolbar. By using the web service you pass in the paramaeter values but do not get the mentioned toolbars.
Remember, parameter defaults can be query based so for dates this can be made to return a dynamic value such as the current date.
No comments:
Post a Comment