Forum Discussion
Paginated Reports Parameters
Hi,
I'm having issues trying to create parameters in my Paginated Report where I can allow the user to either SELECT ALL of the field values or multiple values. I have my parameters working for single select but I'm struggling to understand the logic on how to create a SELECT ALL or SELECT multiple values.
Any help would be massively appreciated.
David
In my dataset Query I was using
WHERE
Field.Line = (@Line)So i changed the Where clause to IN as per below
Field.Line IN (@Line)
Then went into my Report Parameter Properties and selected Allow Multiple Values
5 Replies
I've managed to solve it, it appears my brain is still in my head 🙂
In my dataset Query I was using
WHERE
Field.Line = (@Line)So i changed the Where clause to IN as per below
Field.Line IN (@Line)
Then went into my Report Parameter Properties and selected Allow Multiple Values
I did have to laugh when I've accepted my solution as the answer to my own question haha.
Thought it best to close it down as solved 🙂
Daviejoe , Kudos from My side. That what you can not give to your answer 😀
