<div>
<p>The above parameters would "filter" your results FROM a date TO a date - has nothing to do with what you described so for that to work you'll need to A: Change the report filtes as you need/want B: add those criteria's to the existing FROM/TO.</p>
</div>


The above parameters would "filter" your results FROM a date TO a date - has nothing to do with what you described so for that to work you'll need to A: Change the report filtes as you need/want B: add those criteria's to the existing FROM/TO.

<div>
<p>Hi Iconhan</p><p><br></p><p>Sorry i meant to say the filters based not on the date but Current Smoker and &gt;=4ppm, based on these filters how do i create a parameter to filter the resultant table</p>
</div>


Hi Iconhan




Sorry i meant to say the filters based not on the date but Current Smoker and >=4ppm, based on these filters how do i create a parameter to filter the resultant table

Junior

route217

<div>
<div class="content wysiwyg-content fr-view">
<p>Hi Experts</p><p><br></p><p>How would you use a parameter or an alternative method in SSRS report bulider to filter the resulting table to based on you filter selection criteria.</p><p><br></p><p>See image</p><p><a href="https://filedb.experts-exchange.com/incoming/2022/11_w45/1605335/1667559360481.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2022/11_w45/1605335/1667559360481.png" class="fr-fic fr-dib"></a></p><p>So i want the end result table to show only those that are Current Smoker and those that have CO Level .=4ppm but my table show all the results,,,</p><p><br></p><p><br></p>
</div>
</div>


1667559360481.png


Hi Experts
How would you use a parameter or an alternative method in SSRS report bulider to filter the resulting table to based on you filter selection criteria.
See image
So i want the end result table to show only those that are Current Smoker and those that have CO Level .=4ppm but my table show all the results,,,

Filters SSRS Reports to filter end result table

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.