I have a report that uses a drop down for the user to make a choice. The
report works fine when choosing only one selection but I need the user to be
able to choose one or all choices. Can someone please point me in the right
direction?If it just 'one' choice and or 'All' choice then you can add 'All' option
to the returned resultset and in your query you can check using IIF clause
the parameter value and create query accordingly.
="SELECT * FROM tableName "
& IIF(Parameters!CNO.Value="ALL",""," WHERE (NO IN(" & Parameters!CNO.Value
& "))")
"Zach" <Zach@.discussions.microsoft.com> wrote in message
news:53EF814E-8A45-4326-89E4-7F4E06D0496E@.microsoft.com...
>I have a report that uses a drop down for the user to make a choice. The
> report works fine when choosing only one selection but I need the user to
> be
> able to choose one or all choices. Can someone please point me in the
> right
> direction?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment