Insert alias in Datasource

[jserret]

Hello.

We are trying to localize the report datasource during the creation and edition of a report. We are providing to the report, programmatically using the MVC components, Datasets as a source of data.

Depending of the user language we want to translate the names of tables and fields using alias but keeping the same internal names in order to reuse the reports(Attached 1 and 2).


We have seen that we can use the properties “name” and “caption” for fields but we can’t find how to do the same for the tables (“Datos Personales” & “Personal Data” in the attached screen-caps).

Please, can you give as an example of how we can obtain this functionality using code?

[Lech Kulikowski]

Hello,

Unfortunately, there is no option Caption for DataTable.
As a way, you can set Alias property for StiDataSource
report.Dictionary.DataSources["xxxxxx"].Alias = "Alias";

Thank you.

[jserret]

Hi,

thanks, but not exist any other opcion por insert alias with DataTable similar to Caption?

[Ivan]

Hello,

Please try to use the DisplayExpression property of the DataTable.

Thank you.

[jserret]

Thanks has worked

[Andrew]

Hello,

Thank you for letting us know about this.

Have a nice day!

[jserret]

Hello!

Another question, is it possible through .NET code to make only the alias visible?

[Lech Kulikowski]

Hello,

You can use the following options:
StiOptions.Dictionary.ShowOnlyAliasFor...

Thank you.