Grouping by Date Filter

[TheZepper]

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]

I will forward this to the developer for a reply.

[Rvg72]

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]

Beyond fantastic - Thanks.