Reputation: 41
Dynamic Report title base on parameter selection in ssrs
Hi i have a report where i have 2 parameters and each parameter is populated by getting the value from their respective Data-set. Now i want to create the title of the Report in a way that if the User Select just one account number then i want to display that Account Number in the title; But if User select more that ONE account Number from the drop down then i want to display the value Select in the Second parameter which CUSTOMER NUMBER. Anyone can Help me please.
Upvotes: 0
Views: 1944
Answers (1)
Reputation: 41
Hi i have solved the query so i am posting my answer if in future anyone has the same question; in the placeholder expression i have to put the following expression: IIF(PARAMETERS!ACCOUNT.COUNT = 1, PARAMETERS!ACCOUNT.VALUE(0), PARAMETERS!CUSTOMER.VALUE(0))
Upvotes: 1
Related Questions
- Change value of SSRS report parameter based on the input of another parameter
- How to create a dynamic SSRS Report
- How to create label text based on report Parameter in SSRS
- SSRS: How to display a report title on the parameters page
- How to Display Title Dynamically in SSRS
- HOW can I have a SSRS parameter display or not display based on a prior parameter (dynamically)?
- Displaying a multivalue SSRS parameter in the report title
- Dynamically changing parameter based on another in an SSRS report
- Dynamic Reports using SSRS
- Reporting Services - setting a field value dynamically based on parameter