<div>
You have to create Drop down source (separate by query). &nbsp;Assing the Text and Value. i.e. for Apples value should be all apple in list with comma separated.<br />
<br />
As this change you have to change the Report source (Query / SP) to cop up with the parameter change.
</div>


You have to create Drop down source (separate by query).  Assing the Text and Value. i.e. for Apples value should be all apple in list with comma separated.

As this change you have to change the Report source (Query / SP) to cop up with the parameter change.

<div>
Thanks Valentino. Really appreciable.
</div>


<div>
No worries! &nbsp;Thought I'd add a couple of words, meanwhile I enjoyed writing about fruit :)<br />
And it looks like it got appreciated by the asker as well, so mission accomplished!
</div>


No worries!  Thought I'd add a couple of words, meanwhile I enjoyed writing about fruit :)
And it looks like it got appreciated by the asker as well, so mission accomplished!

<div>
<div class="content wysiwyg-content">
I have a report with 10 items in a drop down list as a parameter. However, I want to combine certain items ahead of time and apply arithmetic &nbsp;to them and pass that calculated value as one of the items in the list. Basically, I have green apples, red apples, fuji apples, oranges, pears, peaches... In the list. I want all apples to appear as apples and sum all apples together versus each specific type. Should this be done ahead of time in my query or?
</div>
</div>


I have a report with 10 items in a drop down list as a parameter. However, I want to combine certain items ahead of time and apply arithmetic  to them and pass that calculated value as one of the items in the list. Basically, I have green apples, red apples, fuji apples, oranges, pears, peaches... In the list. I want all apples to appear as apples and sum all apples together versus each specific type. Should this be done ahead of time in my query or?

SSRS Parameter

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.