PDA

View Full Version : Report Error



jpalatt
08-28-2008, 02:29 PM
I keep receiving

"...ERROR: 42803: column "ph.netamountwon" must appear in GROUP BY clause or be used in an aggregate function" when I try to run my hole cards report.

Other reports still run fine. Advise?

morny
08-28-2008, 04:04 PM
Might be damaged try the attached file and put it in you reports folder and say yes when it asks do you want to replace it.

jpalatt
08-29-2008, 01:26 AM
Thanks, that worked, now the holecards report will run, but I get the same message with any of the "steal" filters, thanks again

Rvg72
08-29-2008, 01:57 AM
Thanks, that worked, now the holecards report will run, but I get the same message with any of the "steal" filters, thanks again

You need to keep the "$" amount as a stat in this report because that is the default sorting column. It's a bug but that is how you would avoid it

Roy

jpalatt
08-29-2008, 12:04 PM
easy fix, thanks

MindControl
12-29-2009, 05:43 AM
I tried to make my own report,but it gave the same error for the stat PH.FlopPlayerActionType_ID .Is there any way to make it work?
EDIT:fixed it somehow