How to create tournament net won report

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

How to create tournament net won report

Postby 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

Re: How to create tournament net won report

Postby 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: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: How to create tournament net won report

Postby 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]

Who is online

Users browsing this forum: No registered users and 7 guests

cron