How to Localize Prompt String in Reporting Services

Hi,
I am working on SQL Reports using Microsoft SQL Server 2005 Reporting
Services.
These reports are intended to deploy in multilingual environment, for
that purpose, each and every thing has to be localized based on
culture.
1- I am able to localized the field labels by loading custom assembly
using expression .
2- But unable to localize the prompt strings.
3- In Report Designer, Report->Report Parameters, the text given for
prompt does not evaluate the expression, if given "=User!Language", it
prints as it is, next to the prompt for respective parameter.
Is there any way or workaround to localize the prompt string at
runtime?
Thanx in advance,
HariomOn 8 loka, 17:28, hariompandey...@.gmail.com wrote:
> Hi,
> I am working onSQLReports using MicrosoftSQLServer2005Reporting
> Services.
> These reports are intended to deploy in multilingual environment, for
> that purpose, each and every thing has to be localized based on
> culture.
> 1- I am able to localized the field labels by loading custom assembly
> using expression .
> 2- But unable tolocalizethepromptstrings.
> 3- InReportDesigner,Report->ReportParameters, the text given forpromptdoes not evaluate the expression, if given "=User!Language", it
> prints as it is, next to thepromptfor respectiveparameter.
> Is there any way or workaround tolocalizethepromptstring at
> runtime?
> Thanx in advance,
> Hariom
Hi Hariom,
Our company has customers all around the world. The localization
support in Reporting Services 2005 is not so good at the moment. Like
you did we also built a custom assembly to localize report fields.
We even built a custom HTTP module to localize the Report Manager to
any language (Microsoft provides few satellite assemblies to localize
it for few languages but not nearly enough, and you can't create your
own assembly, I asked Microsoft Gold partner support about it).
So what we do is that we go through each component on the web page and
check using reflection whether it has a Text property. If it does we
get the text and replace it with another text in another language.
This works great for Report Manager application.
Unfortunately this approach does not work with report parameter prompt
texts. Even if you change the Text property of these components, they
still render the text that is defined in the RDL for the prompt.
So to answer your question, after very extensive search we have not
found any way to localize them at runtime. We had to build a tool that
translates RDL files to different languages.
Best regards,
Juho Salo