<div>
If you are using a Stored Procedure or Query then the best way is to group your SQL statement by month and Year.<br />
Then the report will pick it up from there.
</div>


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.

<div>
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: &nbsp;&quot;Jan 2012&quot; &nbsp;I can get it to show in this format: &nbsp;&quot;1 - 2012&quot;<br />
<br />
Using this expression:<br />
<br />
=Month(Fields!tdate.Value)<wbr /> &amp;&quot;&nbsp;- &quot;&nbsp;&amp; Year (Fields!tdate.Value)
</div>


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)

<div>
is tdate a date field?<br />
If so them you could do this...<br />
<br />
=Format(Fields!tdate.Value<wbr />, &quot;MM-yyyy&quot;)
</div>


is tdate a date field?
If so them you could do this...

=Format(Fields!tdate.Value, "MM-yyyy")

<div>
When I use the expression above it looks like this:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/09_w37/603358/Date-Range.JPG" target="_blank" title="Example (36 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 687px;" data-src="https://filedb.experts-exchange.com/incoming/2012/09_w37/603358/Date-Range.JPG" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2012/09_w37/603359/Expression-1.JPG" target="_blank" title="Example 2 (35 KB)"><img alt="Example 2" class="file-block lazyload" style="max-width: 554px;" data-src="https://filedb.experts-exchange.com/incoming/2012/09_w37/603359/Expression-1.JPG" /></a>
</div>


When I use the expression above it looks like this:

Examplehttps://filedb.experts-exchange.com/incoming/2012/09_w37/603358/Date-Range.JPG
Example 2https://filedb.experts-exchange.com/incoming/2012/09_w37/603359/Expression-1.JPG

Expression-1.JPG

Date-Range.JPG

Capture.PNG

<div>
I have been gone, i will try this. sorry for the delay.
</div>


I have been gone, i will try this. sorry for the delay.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/09_w37/602302/Date-Range.JPG" target="_blank" title="Example (36 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 766px;" data-src="https://filedb.experts-exchange.com/incoming/2012/09_w37/602302/Date-Range.JPG" /></a>
</div>
</div>


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.



Show date ranges by month in SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.