Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio >> Visual Studio Report Controls

Grouping by quarter

If I Group on =MonthName(Month(Fields!CreatedDate.Value)) I group my Report on Month. How can I group it by Quater.

/Anders

[126 byte] By [andersb79] at [2008-2-25]
«« EXE Bootstrapper
»» Winform standards for UI Design? Help.
# 1

Use this group expression to group on quarters:

=Choose(Month(Fields!CreatedDate.Value), 1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4)

It will map the twelve months to 4 distinct values (i.e. quarters).

-- Robert

RobertBrucknerMSFT at 2007-9-9 > top of Msdn Tech,Visual Studio,Visual Studio Report Controls...
Visual Studio
Visual Studio Report Controls

Visual Studio Hot Topic

Visual Studio New Topic

Visual Studio

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified