Laurie Kennedy
asked on
Report Builder 3.0 parameter value to select ALL
Hello,
I'm working in SQL Report Builder 3.0, and I'm attempting to create an expression that will essentially say to return ALL values.
When the report is run there will be multiple values for the parameter, which will return the rows for based on the values selected.
I wanted to create a value called "ALL" that will return all values when selected.
Attached is a screenshot is what I'm looking at:
I'm working in SQL Report Builder 3.0, and I'm attempting to create an expression that will essentially say to return ALL values.
When the report is run there will be multiple values for the parameter, which will return the rows for based on the values selected.
I wanted to create a value called "ALL" that will return all values when selected.
Attached is a screenshot is what I'm looking at:
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The CAML query is already selecting the field from the appropriate table (sharepoint list).
With the parameter created, I figured I could just enter code in the expression to specific the values.
If I use one value, for example "Test" it returns all rows with the value for contract as "test."
But what if I say ="Test" & "Test2"?
You would think it would return all records with both values, correct?