Skip to Content
0
Former Member
Apr 14, 2009 at 01:50 PM

Specified Order Grouping of Data

20 Views

Hi All,

I have a report in CR 2008 that I would like to group dates by two names groups: One for "Current Quarter" and one for "Others". The "Current Quarter" would have to be dynamic based on a formula that if currentdate is in 1st quarter, group that data under the "Current Quarter" and all other data groups under "Others". I am having trouble with the formula that will work with this Specified Order Grouping under Group Expert.

How is it possible to use the Specified Order grouping to work with a formula of this sort so as to have a dynamic current quarter?

Thank you in advance.