Hi experts,
i have a problem with my SSRS server that randomly can't connect to my data source . It works all the time but sometimes i get an error on my reports that indicate that the server fail to connect.
Any tips or leads to identify the source of this problem?
here is my connection ...
Xlbo thanks for reply.
First i don't want you to do the job for me. I explained that i tryed your solution and it dosen't work.Second i think that a picture worth more than 1000s word :) so i propose you to test yourself : Theory is not like practice.My example is very easy to implement and you...
Ok i try it and still have the same problem. Y-axis dont accept string format.
In your sollution the first of month still appear my client want just to see months in the Y-axis like Jan-2008 ( string format not real !!!)
I invite you to do the same with sample data. Can you make a pic-capture...
Ok no problem suppose that i have day granularity in my dataset(in europe format or us no matter) :
date_delevery| dateDue
01/11/1977 | 02/03/2015
21/03/2005 | 02/12/2013
01/11/1977 | 13/05/2015
........
....
...
..
for example (i can extract month name with function ...
Thanks for reply. The pic bellow explain what is my target-chart and my dataset
http://img15.hostingpics.net/pics/219062shemaGraphe.jpg
hope that is more clear now for you
the problem in your idea is that the axis will show intermediate real values for example between 200612 and 200701,
[200613,200614....200699,200700], for example wich are not a months ( months 13,14,...99 that's not exist month must be between 1 to 12).
The question is why Y-axis don't allow...
Thanks for reply.
I don't have date with format dd/mm/yyyy but months (NameMonth-Year) and my client want to see them like this.
do you mean by "Real" that months are like this : 012012 equivalent to jan_2012 ?
The problem of reporting services chart is that he didn't accept string format...
Hello All,
My problem is concerning a chart in reporting services.
My dataset is looking as below:
MonthDue MonthDeleviry
------------|----------------
Jan-2011 Mars-2011
Feb-2012 Jun_2013
Aug-2016 Oct-014
I want to make a graphique
MonthDue(Y-axis)...
Hello,
I have a [Product] dimension that is a hierarchy of product category.
I've created a new calculate members, such as:
CODE
With
Member [Product].[Category].[MyCar] as '[Product].[Category].[Ferari_Auto]'
Along with that, I've created a calculated measure that returns a price :
CODE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.