?
Solved

how to change the  date format on the X-axis  - ssrs

Posted on 2010-01-05
1
Medium Priority
?
908 Views
Last Modified: 2012-06-21
I have a "Weekly" interval set on the X-axis on the chart of my SSRS report.

now, I want to show the week number and not the actual date.

How, do I do this?
0
Comment
Question by:manivineet
1 Comment
 
LVL 10

Accepted Solution

by:
lof earned 2000 total points
ID: 26188316
use function

instead of using

=Fields!ColumnWithDate.Value

use

=DatePart(DateInterval.WeekOfYear, Fields!ColumnWithDate.Value)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

621 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