New to creating reports: Me
Issue: Sorting appears to fail when viewed from the Web Interface only.
Details: I've got a report based on a custom poller that is correct in every way when viewed within the Report Writer. My selected fields are NodeID, NodeName, PollerID, PollerName, and Maximum Rate. The only field I sort on is "Maximum Rate, sort descending, function MAX". I'm showing only the Top 10 Records. Time Frame is Yesterday, and I'm Summarizing the Results by Date. I have two groups in this order: NodeName, Summary Date. It's a faily simple setup.
When I run the SQL query within Report Writer, the results are correct. The highest Maximum Rate appears first and is followed descending to the lowest rate - of the top 10. When I "preview the report" from Report Writer I get the same correct result. When I view the same report from the Web interface, I get one or two "Rates" that are out of order.
Is this a glitch? Should I see the same thing in both the Report Writer and the Web View of the Report? It's a pretty simple report. Or maybe it is something else? My poller is returning a rate; that rate is formatted as a Number-type in the report. Is there something I'm missing?