(PC) Support tip: In PC12.53P4, HTML report shows transaction numbers as text strings
In PC12.53P4 when you open the HTML report and look under the Analysis Summary ->Transactions section, the transaction data is getting created as a text or like an image in the report. Due to this, when we try to copy the transaction numbers from the report and paste it into Excel, it is treats them as a text string and adds a trailing space next to each number. This prevents the users from doing any numeric operations like sorting or conditional formatting or find max/min values etc on these transaction numbers
If it were numbers, then they will all be right aligned when copied to Excel but now they are showing as left aligned like text string
This is a regression introduced in Patch4 for PC12.53. Attached hotfix should fix this issue. After applying the fix, the report generates these transaction numbers as numeric data like in the past. The file needs to be extracted and copied to <PC install>\bin folder to replace the existing one and this needs to be applied on ALL the Controller Hosts and Data Processor machines
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.