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:
< Report Name="By Action Pre" OrderByExpression="Hands DESC" Version="1.1" >
< Groupings >
< Grouping FieldExpression="PH.preflopplayeractiontype_id" ColumnName="preflopplayeractiontype_id" ColumnHeader="Preflop" ColumnFormat="" ColumnWidth="100" >
< Ranges >
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. < = <, > = >
morny
09-30-2008, 06:33 PM
Change it to TotalHands instead of hands and it should be fine
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.