PDA

View Full Version : OrderByExpression



alpatters
09-29-2008, 05:00 PM
The example reports order by a named stat e.g. OrderByExpression="NetAmountWon DESC".

I have created a custom report with some default stats, and it adds the hands column as the first column. How do I order by the number of hands?

I tried OrderByExpression="Hands DESC" but that gave an error.

Thanks,
Alan

morny
09-30-2008, 05:39 PM
Can you attach the report please and ill see if i can fix it

alpatters
09-30-2008, 05:59 PM
Here is the first few lines of the report file:

&lt Report Name="By Action Pre" OrderByExpression="Hands DESC" Version="1.1" &gt
&lt Groupings &gt
&lt Grouping FieldExpression="PH.preflopplayeractiontype_id" ColumnName="preflopplayeractiontype_id" ColumnHeader="Preflop" ColumnFormat="" ColumnWidth="100" &gt
&lt Ranges &gt

With this I get an error due to the OrderByExpression="Hands DESC" entry:

"The following error occurred when running this report: ERROR: 42703: column "hands" does not exist"

Although if I remove the OrderByExpression line, the report works and has a column labelled Hands.

Thanks for any help,
Alan

obv. &lt = <, &gt = >

morny
09-30-2008, 06:33 PM
Change it to TotalHands instead of hands and it should be fine