PDA

View Full Version : winning summary for all players



BornTuKill
10-12-2010, 12:30 AM
Anybody know how to filter a report to show all players winnings and losing for the day?Thanks

Cabbage
10-16-2010, 10:51 AM
Anybody know how to filter a report to show all players winnings and losing for the day?Thanks

Try the 'All player session profit and loss' SQL query here (http://www.iamalazybastard.com/)

BornTuKill
10-21-2010, 02:28 PM
Go to Start>Programs>PostgreSQL 8.x and click pgAdmin III

Double click the "PostgreSQL 8.x (localhost:5432) and you'll get a password popup. Enter the database password (usually 'postgrespass').

Expand 'Databases' and highlight your HEM database.

At the top of the window choose the 'Execute arbitrary SQL queries' icon.

In the new window delete everything from the 'SQL Editor' window and paste in your new query.

Hit 'Execute Query' and wait :)

Results will appear in the Output pane below.

this seems like a sql query, how do i actually view this in HEM?

Cabbage
10-27-2010, 02:51 PM
You could do it by creating an alias of all the players you are interested in, then checking 'group by: player' which you will find just under the Report Name.

As it'll involve so many players it'd probably be best to create the alias using something like RedLotus' method which is detailed here (http://forums.holdemmanager.com/custom-reports/37970-script-editing-adding-aliass.html#post183645)