Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- HTML Report by post time

Home Register
Log In
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.

Reply
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

Reply
jager fury
1/25/2011
7:27:22 PM
Wow. Yes, that helped. I backed right out of there:)

Reply
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

.



Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com