Solved

Dataset field Displaying previous month instead of current month in SSRS

Posted on 2011-03-25
6
612 Views
Last Modified: 2016-02-15
I need to used a dataset field month to display current month but the expression below is giving me February instead of March? How can I adjust the expression below to return current month i.e March?

Fields!Month.Value & ", " & Fields!Year.Value


--------------------------------------------------------------------------------
0
Comment
Question by:Projack
  • 5
6 Comments
 
LVL 2

Expert Comment

by:Micheal Hunt
ID: 35218479
If you just need the current month displayed, you can do something like add a field to the report containing month(Today) as a datasource.  Is that what you're trying to do, or do you need the date to come from a field in your dataset?
0
 

Author Comment

by:Projack
ID: 35218705
The Fields!Month.Value  is coming from this expression in the MDX query within the dataset;
[Dim Time].[Calendar].[Month].ALLMEMBERS
But instead of Fields!Month.Value  giving me March it gives February.
0
 

Accepted Solution

by:
Projack earned 0 total points
ID: 35218801
I found the solution I simply replace Fields!Month.Value with = MonthName(Month(Now())). And it worked. The SSAS was giving me default month in 2011 which was february but by assigning Month(now) into the MonthName function it return current month
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:Projack
ID: 35218860
I researched I solved the issue because I need to resolve it ASAP
0
 

Author Comment

by:Projack
ID: 35218866
I researched I solved the issue because I need to resolve it ASAP
0
 

Author Closing Comment

by:Projack
ID: 35252814
I researched I came out with solution becuase I need to resolved the issue before the COB
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question