business wants to export the result of an Report Definition into an Excel.
But there is one small problem. For one column, the Report Definition returns value like "Pending-ABC", "Pending-XYZ". Business does not want to see these values in the exported Excel spreadsheet. Business wants to see a generic value, for example "Pending" in the exported Excel.
We cannot find a place to update the report defintion result before exporting.
That is the problem we are facing
Basically, we want to find a way to convert "Pending-ABC" into "Pending" before exporting to excel