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?
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: