Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by iv8an » Tue Nov 04, 2008 2:55 pm
Hi! How can i create report that calculate for each player in my database tournament net? I can create report that calculates net won for all players all tournaments net won separately, but i want for each player one result: total net won for all played tournaments. Thank you!
Sorry for my poor english :)
-
iv8an
-
- Posts: 4
- Joined: Tue Oct 07, 2008 9:34 am
by kraada » Tue Nov 04, 2008 3:06 pm
Go to the Reports tab, choose Holdem Tournament Tournaments from the Section drop down, and add Player and Net Won to the report. Click "Filters" and make sure "Filter on active player" is not checked.
Save then run the report and that should do it.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by iv8an » Tue Nov 04, 2008 3:32 pm
I do that but then i got for one player more results (for each tournament one). I want total net won (one result) for each one player
-
iv8an
-
- Posts: 4
- Joined: Tue Oct 07, 2008 9:34 am
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 3 guests