Solved

Dataset field Displaying previous month instead of current month in SSRS

Posted on 2011-03-25
6
609 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

947 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now