Link to home
Start Free TrialLog in
Avatar of Laurie Kennedy
Laurie KennedyFlag for United States of America

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:

User generated image
SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Laurie Kennedy

ASKER

Okay, thanks.

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?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial