SSRS show parameter values in header
I am trying to add an expression in header section, which would display parameter value chosen by users (if everything selected, display "ALL" instead). I am having trouble with "Property" parameter.
Report structure: Report is a matrix report that shows data by year and grouped by refBuildingID. Parameter "Property" is based on RefBuildingID. I want to show these parameter values in header when users run this report.
Expression:
=IIF(Countrows("BuildingID")=(Parameters!refBuildingID.Count),"All",Join(Parameters!refBuildingID.Value,", "))
Error: The Value expression for the text box ‘Textbox31’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
Is there a way to get around this error?
Try this method:
=IIF(Count("BuildingID")=Count(Parameters!refBuildingID.Value),"All",Join(Parameters!refBuildingID.Value,", "))
- How to create dynamic lambda join query using expression in C#?
- Transform LINQ IQueryable into a paged IQueryable using LINQ to NHibernate
- Can't convert ICollection<t> to IEnumerable<t>
- Why does Python evaluate this expression incorrectly?
- Getting the name which is not defined from NameError in python
- Regular expression for duplicate character sequences
- How to add axis text in ggplot2 including both a symbol and linebreak that is centered correctly
- How does the logical `and` operator work with integers?
- What is the difference between an expression and a statement in Java?
- Wrap Expression in Expression.TryCatch
- Expressions in C. Are assignments expressions despite semicolons?
- Compiling LINQ expressions
- Add geom_text with x bar and round values
- Is it possible to extract properties and values from Action<T>?
- Expression parsing: how to tokenize
- Expression function
- Scraping data from data.gov.uk / Regular Expression
- Why does my Access control source expression treat the drop-down field selection as a number rather than string?
- Possible to Stringize a Polars Expression?
- Get property value with Expression without knowing target type at compile time
- Compiled lambda expression leading to new delegate allocations, whereas non-expression version does not
- How do you add both data frame values and math operators to geom_text in R?
- Lines that have three upper case characters in parenthesis like (LTI) - remember to escape certain characters
- Pass an Expression into another Expression as parameter
- Building a generic search for RavenDb - failing to create Expression<Func<T,object>>
- Expression Visitor access property on parameter representing local variable
- SSIS How to get part of a string by separator
- How to trigger implicit pointer conversion inline in a C macro?
- make a portion of ggplot legend bold
- Combining or appending to pyarrow.dataset.expressions