• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2241
  • Last Modified:

Show date ranges by month in SSRS

I want to show totals (group) by month and year instead of each day. Is there an easy way to do this in report builder 3.0. I usually use crystal. thanks for any help.

Example
0
srodgers45
Asked:
srodgers45
  • 3
  • 2
1 Solution
 
planoczCommented:
If you are using a Stored Procedure or Query then the best way is to group your SQL statement by month and Year.
Then the report will pick it up from there.
0
 
srodgers45Author Commented:
I am not currently doing it that way, I was able to figure out the grouping, now I am having trouble displaying the Month Name and Year Example:  "Jan 2012"  I can get it to show in this format:  "1 - 2012"

Using this expression:

=Month(Fields!tdate.Value) &" - " & Year (Fields!tdate.Value)
0
 
planoczCommented:
is tdate a date field?
If so them you could do this...

=Format(Fields!tdate.Value, "MM-yyyy")
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
srodgers45Author Commented:
When I use the expression above it looks like this:

Example
Example 2
0
 
Alpesh PatelAssistant ConsultantCommented:
Report
Please create row / column group and do visibily based on requirement.
0
 
srodgers45Author Commented:
I have been gone, i will try this. sorry for the delay.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now