August 11, 2016 at 12:15 pm
Hello,
I am connected to an Access DB through OLE DB. I have a report where I want to have two parameters. Basically a parameter for product ID and for division. Right now, I can set up the report with both parameters that will allow you to select one option from each parameter and will give you the data you request. My end result that I am wanting is to be able to select two product IDs and two Divisions and the report will show the multi values that I have selected.
I have looked online and come across very vague different ways of doing this. Each way however seems to give me a different error and will not run the report.
Any insight on what I might need to do to get the parameters to accept my multi values? Really frustrated here as I have spent quite some time today trying to figure this out.
Thanks
dpsql
August 11, 2016 at 6:28 pm
Did you check the "Allow Multiple values" in the Parameter properties? If not, it will default to single-select instead of Multi-select. (And then you under FILTERS, have to change [Field]= to [Field] IN ...
August 12, 2016 at 6:52 am
Wow.... That is what I was missing. I was not entering anything in the Filters section of the dataset parameters. Thank you!
Works like a charm now.
August 12, 2016 at 2:16 pm
It's one of those "features" they don't tell you about... Maybe check out Jessica Moss's articles on SSRS to see if there's anything there that's helpful.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply