By |
HTML Report by post time |
jager fury 1/25/2011 4:17:26 PM | How do I use System Definitions menu to get at my Customizeable HTML Report for the express purpose of displaying my report by post time?
Report Level Sorting is what I am refering to. Thank you for your assistance Jcapper message board.
|
JimG 1/25/2011 6:30:14 PM | Click system settings on menu
Click Factor set up tool
Click Next 4 times...this will take you to the last menu on this item.
Type in Report Level Sql expression is as follows:
SELECT * FROM RACEHEADINGSTODAY WHERE FIELDSIZE >= 1 ORDER BY POSTTIME
Be sure to click in the box just above the expression, then click on save and your sql html report will be in post time order.
Hope that helps.
Jim
|
jager fury 1/25/2011 7:27:22 PM | Wow. Yes, that helped. I backed right out of there:)
|
jeff 1/26/2011 5:09:19 PM | Also...
To enable sorting races on the html report by true post time, in Enhanced Settings, use the following setting:
PPs Post Time Display 0 Military Time
Otherwise the interface has no choice but to give you a text sort of the post times.
-jp
.
|