?
Solved

Dataset field Displaying previous month instead of current month in SSRS

Posted on 2011-03-25
6
Medium Priority
?
631 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

762 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