Hey there, How do I make a report by certain games? Say all Saturday games (certain games by date)?
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