Hey there, How do I make a report by certain games? Say all Saturday games (certain games by date)?

Statbook
2010-04-28 18:48

First, duplicate a report, for example one of the Overall reports. Then you would add something like the following to the 'Additional Instructions' field, assuming a game with the date exists:

WHERE g.GameDate = '2008-03-08'
GROUP BY p.ID

Or you could pick all games in March of 2008 with the following:

WHERE g.GameDate >= '2008-03-01' AND g.GameDate <= '2008-03-31'
GROUP BY p.ID

Or, selected games, like:

WHERE g.GameDate = '2008-03-01' AND g.GameDate = '2008-03-08' AND g.GameDate = '2008-03-10'
GROUP BY p.ID

Average rating: 0 (0 Votes)

You cannot comment on this entry