<div>
Not entirely sure what you are asking us, but SQL Server does not have any capabilities to automatically translate text to a different language. &nbsp;What it can do is define different columns based on a collation (i.e. language, case sensitivity, access sensitivity), then have those tables.columns populated with those languages, and developers have the ability to write code to point to the appropriate table.column based on those languages. <br />
<br />
For example, my current client is a travel rewards program. &nbsp;We have an English database that describes hotels around the world, and multiple other databases with the same exact schema but different collations, and translators that write the same values but translated into those various languages. &nbsp; Then front-end apps identify the language used, and functions pull data from the appropriate database.table.column.
</div>


<div>
Sorry for the confusion. We have been able to translate what we needed for the content of the reports by using a localization table in our SQL database and pointing to that. What I am trying to figure out is whether or not there is somewhere withing SSRS to translate the default of (Select All) in a multi-value parameter.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w15/1156618/Capture.JPG" target="_blank" title="Select All default (14 KB)"><img alt="Select All default" class="file-block lazyload" style="max-width: 310px;" data-src="https://filedb.experts-exchange.com/incoming/2017/04_w15/1156618/Capture.JPG" /></a>
</div>


Capture.JPG

<div>
Oh that. It is one of several recurring issues with the parameter UI (ever since SSRS was originally released). I don't know of any solution other than writing your own parameter UI code and suppressing what is in Report Viewer. If you want a clean UI, that is the way to go. I'm not saying it is easy to do that, but the Report Viewer parameter UI has significant issues that have no direct workarounds.
</div>


<div>
You can<a href="https://docs.microsoft.com/en-us/sql/reporting-services/report-design/set-the-locale-for-a-report-or-text-box-reporting-services" rel="ugc"> set the locale</a> for a report. I haven't used this feature, and I don't know off the top of my head if it is an RDL-only setting or something that can be set using an expression.
</div>


<div>
I have tried to set the locale for the report but when I change it to Spanish and then run it, nothing happens. Either I am not doing it right (most likely) or it doesn't work.
</div>


<div>
It is surprisingly hard to find information about this. I am going to do a little experimenting, later today. Something is trying to come back to memory. :-)
</div>


Localized-Report-Viewer.png

<div>
THANK YOU!! Now I will hand this solution over to the development team in charge of those options.
</div>


<div>
<div class="content wysiwyg-content">
Hello experts - <br />
<br />
We are in the process of localizing our SSRS reports and have run into an issue that I don't think is solvable at the user level. When you have a report with a multi-select parameter, SSRS automatically displays a '(Select All)' parameter as a choice. Is there a way to translate that choice into Spanish at the report level?<br />
<br />
Thank you.<br />
<br />
-- Lisa
</div>
</div>


Hello experts - 

We are in the process of localizing our SSRS reports and have run into an issue that I don't think is solvable at the user level. When you have a report with a multi-select parameter, SSRS automatically displays a '(Select All)' parameter as a choice. Is there a way to translate that choice into Spanish at the report level?

Thank you.

-- Lisa

SSRS 2008 Spanish Translation

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.