Hi,
Is there any possibility that I can adjust DEFAULT_ALIAS and DESCRIPTION of columns according to chosen language in gui?
https://reportserver.net/blog/2016/08/09/the-metadata-datasource-for-dynamic-lists/
How should I write such a script? What to write in Metadata query?
Another question is how to adapt parameter name and description added to Report with current language?
When it comes to column default alias and description I found a post:
https://forum.reportserver.net/viewtopic.php?id=605
Maybe it’s a good direction to solve problem but I rather prefer saving column alisas and description in database because I will have a lot of different reports with two languages.
I wonder now how can I adjust parameter name and description according to language? Now this seems to be a problem. In the worst case I would have to create two reports, one for each language…
Hi Patryx,
multilanguage parameters are not yet supported. We have a ticket for this: RS-3476
Regards,
Eduardo
Hi Patryx,
nevertheless, you should be able to create a script datasource that depending on the language selects the right columns (mycolumn_de, mycolumn_en, mycolumn_pl, etc). Similar as here: https://forum.reportserver.net/viewtopic.php?pid=2424#p2424
Then use this script datasource as a metadata datasource in your report.
This only works for column names and descriptions, not for parameters. For parameters, we have the ticket I mentioned above.
Regards,
Eduardo
Hi Eduardo,
I understand.
Is it possible if this ticket is done in next version 3.0.8?
I hope you issue next version very soon because I am still working on a preview version of 3.0.8 
Till that time I will adapt my columns depending on current languages.
Is there or will be any possibility in future:
I think these two features will help users a lot and simplify a lot of questions.
Hi Patryx,
I raised 3 tickets for related multilanguage features:
RS-3484: Multilanguage Report Metadata
RS-3485: Multilanguage Datasource Parameter
RS-3486: Multilanguage Parameter
I also raised:
RS-3487: Make locale available to query wrapper
I am not sure if they will make it to 3.0.8 , but these tickets are open they are interesting feature requests. I will update here when I have more information.
Regards,
Eduardo
Hi Eduardo,
It sounds perfect!
I keep my fingers crossed and I hope to see such features in 3.0.8
P.S.
“RS-3486: Make locale available to query wrapper” I suppose you meant “RS-3487…”
Hi Patryx,
yes, I corrected the ticket number 
Regards,
Eduardo
You can also include in ticket to make ‘locale’ available also to QUERY for data, not only for METADATA - in both it would be helpful!
Hi Patryx,
yes, RS-3488: make locale available to query
Regards,
Eduardo
OK, perfect
Hi Patryx,
I just wanted to let you know: we are currently working on making some standard parameters available to all queries (metadata query, normal query, query wrappers, etc). This includes locale, current username, etc. The default parameters will be included in a menu, so they will be very easy to select.
When this is finished, you will be able to easily create a metadata query that depends on locale:
select * from mytable where locale = ${_RS_locale} or similar. I will update here when I have more information.
Regards,
Eduardo
Hi!
It’s great to hear it!
It would be a really useful feature in your ReportServer which makes easier for user to create many reports!
Thank you.
P.S. Please have a look at https://forum.reportserver.net/viewtopic.php?id=1452 - it seems to be easy to correct and a bit connected with this one.
Hi Eduardo,
Just for your information, nowadays in my version I can use in query ${_RS_LOCALE} and it works
Only in windows of administration Execute of Metadata Query doesn’t work but when I open Execution View it works as I expected (get English aliases of coulmn from metadata query)
Hi Patryx,
please test the following in your metadata datasource:
select * from mytable where locale = ${_RS_LOCALE}
This should already work. The only missing part is showing a list to the user in the GUI with all available default parameters But if you write the parameter directly into the query, it should work. Please confirm.
With this, you can already translate default alias and description
Regarding the other ticket, yes, we will take a look, it seems related as well.
Regards,
Eduardo
Hi Patryx,
for your reference, here is a list of the default parameters that should already work:
_RS_USER_LASTNAME
_RS_USER_USERNAME
_RS_REPORT_NAME
_RS_USER_EMAIL
_RS_REPORT_KEY
_RS_LOCALE_USER
_RS_REPORT_DESCRIPTION
_RS_USER_FIRSTNAME
_RS_REPORT_ID
_RS_LOCALE_SYS
_RS_USER_ID
_RS_USER_TITLE
_RS_LOCALE
Regards,
Eduardo
Hi Patryx,
these are documented here:
https://reportserver.net/en/guides/admin/chapters/using-parameters/
We are adding them to the GUI so it is easier for the user to add the parameters without referring to the documentation
Regards,
Eduardo
Great!
But take a look on button Execute in Query for Metadata in Administration of ReportServer because only there I got en error using ${_RS_LOCALE}
Hi Patryx,
thanks for letting me know. We will correct this in RS-3500.
Regards,
Eduardo
One more thing
_RS_REPORT_KEY
This one doesn’t work well.
If I open base report I expect base report key. If I open variant I expect variant report key.
Unfortunately this doesn’t work. _RS_REPORT_ID and _RS_REPORT_NAME work as expected, so only _RS_REPORT_KEY is a problem.
What’s interesting in Administration, if I click button Execute on data query I see the key of base report, but in Execution View this column value is empty.
Could you check why _RS_REPORT_KEY doesn’t work?