How to sort the BIRT trend report templates based on the specified sorting in the SQL query?

0 Likes

Problem:

How to sort the BIRT trend report templates based on the specified sorting in the SQL query?

Resolution:

The sorting on the BIRT report templates "Customer Measure Trend Report", "Overall Page-Time Trend Report", and "Overall Transaction Busy-Time Trend Report" is made by the ExecutionTimeStamp but not from the specified sorting in the SQL query.


Removing the sorting in the BIRT report templates as in the modified report templates attached should now use the sorting order specified in the SQL query (same as in the data).


Exchange the existing report templates with the attached templates and verify that this fixes the sorting issue with the BIRT report templates. Ensure that you back up the original report templates.



Related documents:


Custom measure trend report.zip
Overall transaction busy-time trend report.zip
Overall page-time trend report.zip
Old KB# 25182
Comment List
Anonymous
Related Discussions
Recommended