SSRS-range bar chart axis label in quarters (Q1, Q2, Q3, Q4)

Question

I've created a range bar chart using SSRS 2008.

It is a date range

StartDate is =DateAdd("yyyy",-2,Today())

EndDate is =DateAdd("yyyy",2,Today())

Is there a way to format the Axis labels to show in Quarters?? I am able to display in "MMM-YY" format. But I want it in "Qq-yyyy" format.

Thanks!! Any help is appreciated.

Manoj · Answer 1 · 2014-12-22T09:51:37.190

0

use following format:

="Q"+Cstr(DatePart(DateInterval.Quarter,today()))+" - "+Cstr(Format(Today(),"yyyy"))

Output will be : "Q4 - 2014"

Put Your Date Field/Axis labels Filed instead of "Today()" in above expression.

edited Dec 22 '14 at 09:51

answered Dec 22 '14 at 09:19

Manoj

I'm getting `Q4-2014` for all the intervals. – damseldeebi Dec 22 '14 at 09:32
which field is in your Axis labels ?? – Manoj Dec 22 '14 at 09:43
Its a range bar chart having range between **StartDate** and **EndDate**. Doesn't take range from a field. Those date values is selected by user in parameters. – damseldeebi Dec 22 '14 at 10:08
I have the date... which is displayed in **"MMM-yy"** format – damseldeebi Dec 22 '14 at 16:09
so put the above expression on that Axis Label `="Q"+Cstr(DatePart(DateInterval.Quarter,))+" - "+Cstr(Format(,"yyyy"))` – Manoj Dec 23 '14 at 06:28
The problem is I don't have a date field. Its is the range that is date. – damseldeebi Dec 24 '14 at 09:31

1 Answers1