CODEWITHSUNDEEP
datereporting-servicesparametersdefaultmonthcalendar
DataWing
DataWing

Reputation: 27

SSRS Current Month Parameter

I have cascading date parameters year, month, date. I want SSRS to dynamically populate the current month automatically.

For year I used ="[Date].[Year].&["+CSTR(Year(Today))+"]" and worked fine. For Month I used ="[Date].[Month].&" & Format(Today(), "YYYYMMMM") and IS NOT working.

My Month Parameter format is: 2016 September

Thanks in advance for your help.

Upvotes: 0

Views: 1719

Answers (2)

Louie
Louie

Reputation: 538

You could probably try and use the CDATE function:

=Format(CDATE(Today()), "yyyy MMMM")

Upvotes: 0

alejandro zuleta
alejandro zuleta

Reputation: 14108

Try:

="[Date].[Year].[Month].&["+ Cstr(Today.Year) + " " +
StrConv(MonthNAme(Today.Month),vbProperCase) +"]"

Also this should work

="[Date].[Year].[Month].&["+ StrConv(FORMAT(Today(),"yyyy MMMM"),vbProperCase) +"]"

Let me know if this helps.

Upvotes: 0

Related Questions