Monday, February 12, 2018

Parameter screen in ssrs reports













Today i discuss the ssrs report paramter it is easy to deploy


Common Uses for Parameters

Here are some of the most common ways to use parameters.
Control Paginated and Mobile Report Data
  • Filter paginated report data at the data source by writing dataset queries that contain variables.
  • Filter data from a shared dataset. When you add a shared dataset to a paginated report, you cannot change the query. In the report, you can add a dataset filter that includes a reference to a report parameter that you create.
  • Filter data from a shared dataset in a SQL Server mobile report. See Create mobile reports with SQL Server Mobile Report Publisher for more information.
  • Enable users to specify values to customize the data in a paginated report. For example, provide two parameters for the start date and end date for sales data.
    Connect Related Reports
  • Use parameters to relate main reports to drillthrough reports, to subreports, and to linked reports. When you design a set of reports, you can design each report to answer certain questions. Each report can provide a different view or a different level of detail for related information. To provide a set of interrelated reports, create parameters for the related data on target reports.
  • Customize sets of parameters for multiple users. Create two linked reports based on a sales report on the report server. One linked report uses predefined parameter values for sales persons and the second linked report uses predefined parameter values for sales managers. Both reports use the same report definition.
    Vary Report Presentation
  • Send commands to a report server through a URL request, to customize the rendering of a report. For more information, see URL Access (SSRS) and Pass a Report Parameter Within a URL.
  • Enable users to specify values to help customize the appearance of a report. For example, provide a Boolean parameter to indicate whether to expand or collapse all nested row groups in a table.
  • Enable users to customize report data and appearance by including parameters in an expression.

1 comment:

  1. Thank you for your articles that you have shared with us. Hopefully you can give the article a good benefit to us. iManage corporate legal

    ReplyDelete