View Full Version : Grouping by Date Filter
TheZepper
07-19-2009, 05:01 PM
I'd like to create some custom reports grouped by the date filter - like row 1 = this month or last 5000 hands, row 2 = this year or last 50,000 hands, etc. Is this possible?
Thanks for any help..
fozzy71
07-22-2009, 02:12 PM
I will forward this to the developer for a reply.
Rvg72
07-23-2009, 06:30 PM
Yes, within the groupings section of the report file you can do something like:
<Groupings>
<Grouping FieldExpression="to_char(date_trunc('month', ph.handtimestamp), 'YYYY MM')" ColumnName="Month" ColumnHeader="Month" ColumnFormat="" ColumnWidth="100" ToolTip="" />
</Groupings>
TheZepper
07-23-2009, 11:15 PM
Beyond fantastic - Thanks.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.