Report help

[erosbandi]

I would like to modify custom report of "Hit flop with pairs" in a way that i would like to see that how many times I saw flop with each pairs. I wanted to put it in a new cloumn after times coloumn.
I tried with the following expression "id_holecard in (1, 26, 49, 70, 89, 106, 121, 134, 145, 154, 161, 166, 169) AND (flg_f_saw is true)" but I got an SQL error. How shloud I write this expression?
And my other problem would be that if I create a Filter with the Simple Filters option and I click OK the newly created filter wont appear in the Edit Report Filter window. Please give me a step-by-step instruction about its usage, since it looks like very useful, but based on the Custom Report Guide I was unable to use it...
Thanks in advanced,
Andras

[WhiteRider]

That id_holecard expression is actually used in the report filters, not in the columns - is that what you want to do?
If so, you can just add another filter for "flg_f_saw".
flg_f_saw is a boolean (true/false) value so you don't need "is true". (For reference, you would have to put "=true", although you don't need to do this for boolean values).

Simple filters don't appear in the edit report filters list - they are just in the simple filters window - you should see them listed above the report too, though.

[erosbandi]

It seems that I had not managed to express my problem well...so I would like to extend this report with a new coloumn where I can see how many times I saw flop with differnt PP's. Just like in SetOMeter, where in the rows PP's were listed and in the following coloumns were listed aswell:
- dealt
- SawFlop -------- i would like to have this information
- Flop a set
- win/loss

Where should I write this flg_f_saw filter? When I added this to the existing HitFlopWithPair report I got an SQL error, unfortunately I can not copy here...

[WhiteRider]

The 'hit flop with pair' report has been updated in the Repository and now (I understand, although I haven't had chance to try it myself yet) now has the information you want.

To add the new column yourself you will need to make a new statistic along the same lines as the ones already being shown in that report.
Have a look at the Custom Statistics and Reports FAQ and how the existing stats are built and you should be able to work it out. (or download the new report and have a look how it is done)

[erosbandi]

I have downloaded the new report, but I can not import it into PT3 because I got an exception and PT3 crashes. I am using PT3 beta 25.

[WhiteRider]

Ah, yes, sorry - I forgot about that. That has been fixed for Beta 26, which is due for release within the next few days.

[erosbandi]

Ok, thx. I will try it with the new release

[erosbandi]

Unfortunately the same result with the new (26) beta....

[WhiteRider]

Yes, I get an exception with that report too. I'll see if I can get the author to re-export it in Beta 26 and see if that helps.

[WhiteRider]

Thanks to the author (alonalbert) for re-exporting his reports and sending them to me - I can now import these reports and they are attached here.
I will try to get them updated in the Repository too.

Hit Flop.zip

You will need to extract the files from the zip before importing them into PT3.

(2.94 KiB) Downloaded 132 times