Mpho Serumola
asked on
parameter to include or exclude values in a table. Ssrs
How do I create parameter to include or exclude values in a table. Ssrs
I see this is your first question. Welcome to Experts Exchange.
The easiest way would be to have as your data source a SQL Server Stored Procedure (SP) that accepts a value as a parameter, and executes T-SQL that includes a WHERE clause that includes that parameter.
When SSRS runs the report it will detect this and prompt the user to enter a value, which is then passed to the SP.
For more details you'll need to provide a more detailed question.
The easiest way would be to have as your data source a SQL Server Stored Procedure (SP) that accepts a value as a parameter, and executes T-SQL that includes a WHERE clause that includes that parameter.
When SSRS runs the report it will detect this and prompt the user to enter a value, which is then passed to the SP.
For more details you'll need to provide a more detailed question.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Can you please explain your requirement more ?
Raj