Set a fix locale in Plateau Report Designer

[UweStieglitz]

SF LRN standard reports as well as custom reports take the locale from the user who pulls the report. We want to develop reports where the locale of title, description and audience of item is fix and independent of the locale of the user.

Do you have done this already? Any suggestions?

Thanks a lot, 

Uwe

[UweStieglitz]

I found the answer:
Select

LocTitleEn.label_value as "Fix English Locale of Title"

From

pa_sched a

LEFT OUTER JOIN PA_I18N_LOCALIZED_LABEL LocTitleEn ON LocTitleEn.LABEL_ID = a.schd_desc AND LocTitleEn.LOCALE_ID = 'English'

This works fine, but I get some issues with the dynamic selection of filters when running the report in SF.

I mean: When I run the report in SF LRN and go into the search filters to define which classes I want to see in the report, then this works fine, whenever I eventually display all classes I want and select them. E. G.: I look for classes with title "ABC", display the results, select all found classes and run my report. So, this is basically a static search.

When I only add "ABC" as filter to the search without explicitely selecting the classes (so a dynamic search), the report fails. I have no idea...