Editing LMS standard reports with Online Report Designer

[Phivas]

Hi all,

everytime I am adding new columns to any LMS standard report and make the necessary changes in the SQL query, I am uploading the new report onto my instance and then some columns like "Title" are cryptic and dont show the original course title anymore. What am I missing?

Kind regards

[Brian_Boegs]

Fields like item title are referenced to the language in your preferences.

Because of this, you need to add a little extra code to the output field in the report.

In the binding data for the cell, look in the expression field.

Example: The title will look like dataSetRow["CPNT_TITLE"]

But it should be like this:

reportContext.getMessage(dataSetRow["CPNT_TITLE"], reportContext.getLocale())