Paginated Reports Parameters

[Daviejoe]

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

[Daviejoe · Accepted solution]

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

[Daviejoe]

@amitchandak 

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 🙂

[amitchandak]

@Daviejoe , Kudos from My side. That what you can not give to your answer 😀

[Daviejoe]

Gratefully recieved my friend 😀👍

Stay Safe!

[Daviejoe]

I've managed to solve it, it appears my brain is still in my head 🙂