Customizing The Axis Values
Apr 4, 2008
In the SQL SERVER 2008 Report Designer
i'm trying to configure the Axis Scale Interval with the Values of the dataset(Category Fields) and not a defined or a auto scale values, i want each graph bar have an Axis value.
In my Case i have in the Category Fields (the X Axis) day type Values and i want each graph bar with a day. I''d dropped the field date to category fields but i can't get the days all followed i only can get the days by some stupid axis auto interval.
how can i resolve this problem ?
View 1 Replies
ADVERTISEMENT
Jan 14, 2007
I have a simple-column chart and in the x-axis I put the date values and in the y-axis the sale price values.
The chart works perfectly in the case when there is only one sale price for the same date. But, when the price changes during the same day, then there is problem. In the following example
x y
1/1/2007 6.25
2/1/2007 7
2/1/2007 4
3/1/2007 8
the chart will have three columns and in the date 2/1/2007 will display the min or max of the two values. What I need is to represent all the values i.e. the chart must have four columns , as much as the rows of the dataset
Is it possible?
View 1 Replies
View Related
Oct 23, 2006
I will try to explain this best I can. I have a report where it shows total number of pieces over time. This range is from 0 to like 100 pieces. I have done a UNION query to add average accumulation (in inches).
If adding average accumulation to the "Data fields" section of the report in report designer, It shows the average accumulation on the bottom in releation to the number of pieces. (which is what I want.. But.. ) The numbers are not proportional obviously there wont be 60 inches of snow.. more like 1 or two inches.. So the line is very close to the bottom almost invisible..
Now that ive dont a muck up job of explaining.. This is what im looking for.. Some type of chart that will overlay the average accumulation but somehow be smart enough to show the different scale of precipitation vs pieces of equipment.
VS 2003 SQL Server 2000
View 8 Replies
View Related
Feb 28, 2008
Hello,
I need to know what means are available to change the Minimum and Maximum Y-Axis scale values rather than leave them simply as they are in the properties.
Right now whatever min/max values I enter into the scale for the Y-Axis are unchangeable.
I need to be able to change the min/max scale values based on the value of the data at run time.
Any help is appreciated.
Thanks.
View 6 Replies
View Related
Jul 19, 2007
All,
I have read through the following:
http://technet.microsoft.com/en-us/library/aa964128.aspx.
The relevant section of this document is :-
Question (X-axis): How does automatic x-axis label positioning work?
Answer: Currently, built-in Reporting Services charts only allow automatic positioning in order to avoid overlapping the x-axis labels. The label direction (horizontal/vertical) of the axis labels depends on the label string sizes and the available space. X-axis labels are either shown horizontally in one line, horizontally in multiple lines with line breaks, or vertically. Showing x-axis labels at an angle, or explicit manual control over individual x-axis label positions is currently not supported.
Note There are several third-party chart add-ins that enable more control over axis labels. These add-ins can be installed on top of Reporting Services 2005.
I have exactly the problem indicated above in that some sectors of my Pie Charts I am are trying to produce are small and are close together thus labels overlap in some cases. As it says above, only automatic placing of the labels is available, but there could be a solution through third party software.
Does anyone know of a 3rd party solution/add in or a workaround?
Thanks
Msuk
View 3 Replies
View Related
Aug 23, 2007
Hi,
in our development and testing environment we always use (nolock) on every table to minimize locks.
I have found out that we can do the following:
Go to Tools -> Options -> Query Execution -> SQL Server -> Advanced
Set the drop down box to READ UNCOMMITTED for SET TRANSACTION ISOLATION LEVEL
This removes the need to have the NOLOCK hint on every table.
However, I have some reservations about this. If I create a stored procedure in MS with these settings, will they apply on the production server when I deploy it? A window appeared when I changed the settings stating something like 'it would only affect the queries run on this instance of Management Studio, but I need to be sure.
A colleague suggested that sometimes setting session defaults like this causes them to be written into coded scripts and installed procedures written in management studio and this is not obvious therefore you get inconsistent results across users apparantly running the very same script.
Can anyone please advise me as to whether this setting is a good/bad idea in a development/testing/production environment?
View 2 Replies
View Related
Feb 28, 2007
one of the requirements is that if the report takes a long time to run the user can start report processing and later
when that report is processed user can see that in his 'My reports' section,
What will be the best way to do this, my main concerns are -
1 How can I use scheduling to accomplish this.
2 How to save the report, as snappshot or what...
3. How can I find in my Web app. that report is ready or not and show a link to it.
View 5 Replies
View Related
Mar 2, 2007
I need to place a jpeg image of our company logo in the middle section of the Report Manager heading between the wording of "reporting services" and Home | My Subscriptions | Site Settings | Help
I am using SQL Reporting Services 2005 with SQL Server 2005 SRV Pack 2
Can someone point me in the right direction?
View 3 Replies
View Related
Jan 17, 2007
I'm trying to convert an old chart to Reporting Services.
We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.
My question is: How can I get create a line chart using this dataset.
The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.
I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.
Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96
View 1 Replies
View Related
May 23, 2007
Is there any way to customize reporting services error and provide a user friendly message? We use Reporting Services 2000 and the error message is:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'dsasSource'. (rsErrorExecutingCommand) Get Online Help
View 1 Replies
View Related
Dec 17, 2007
We have the need to be able to send emails from our SQL 2005 server with the from address field determined at run time from a table. What are my options? We are running a clustered SQL 2005 x64 standard edition on Win 2003 Enterprise x64.
1. Database Mail - with all the hoopla about how nice it is to have a proper SMTP mailer in SQL, it still seems to lack this functionailty. IMHO a HUGE miss.
2. sp_send_cdosysmail - We used this when we had a SQL 2000 on W2K and it worked just fine. On our current environment, the stored procedure works for a period of time and then suddenly and out of no where we see this message in its log files:
CDO.Configuration.1 - A dynamic link library (DLL) initialization routine failed. sp_OAGetErrorInfo for sp_OASetPropery sendusing
After which no emails are sent until I restart the SQL Server service. We have tried both the sendusing method of 1 (local pickup) as well as 2 (remote SMTP server) and both are exhibiting the same behavior.
What other options do we have?
Alex.
View 3 Replies
View Related
Jul 17, 2007
How do i add a 2nd Y axis? i can't believe MS would leave out such an obvious feature?
View 6 Replies
View Related
Aug 6, 2007
Good day,
I would like to know if it is possible to add a second Y axis to a reporting services chart?
Please can someone advise on how this can be done
Thank you in advance
View 5 Replies
View Related
May 4, 2008
Hi All,
I am working on a line chart. The variable on the X- axis is DateTime. The requirement is to have the values displayed with an interval of 4 hours (or mabe 5 or 6 hours - basically every regular intervals). I am using a list control to Subreports to show around 10 reports.
HOW can I do this? The Major and MInor intervals only help in separating which samples will be displayed. But we cannot configure for regular intervals.
Please help.
Thanks in advance,
Manoj Deshpande.
View 1 Replies
View Related
Mar 22, 2008
my data fields are in seconds so my y-axis shows seconds. But i want to format Y-Axis so that instead of showing seconds it should show mm : ss so this is what i have tried, in the "format code" i put this :
=(Fields!Seconds.Value)/3600
to check if it shows the division result but it doesnt, t shows the exact same result as it was before. Further testing of something like:
=(Fields!Seconds.Value) & "%"
does display the percentage sign with the values but division isnt right.
I am new to this, can anyone tell me how this can be done?
View 3 Replies
View Related
Oct 17, 2007
I created a graph which retrieves value from database.And currently,my axis is in ranged 0-10.But i have a doubt that my value in will exceed my maximum y-axis value 10..My question is, could it be possible that i make my y-axis dynamic??Thanks!!
View 5 Replies
View Related
Jan 12, 2007
Hi,
In my report, I have StartDate and EndDate parameters.In my Line chart on x-axis i need to show the dates like this:Suppose startdate=1/1/2005 and enddate=12/31/2005 then x-axis labels like this:1/1/2005,4/1/2005,7/1/2005,10/1/2005,1/1/2006.In x-axis i put the Minimum value:Parameters.StartDate.Value and the Interval is 90( days),it is not working properly.
How to show quarter of the year on x-axis.
Please help me
Thanks in advance
View 9 Replies
View Related
Mar 29, 2007
Hi, how do I change the scale of x axis to a larger time scale than the data ?
Data is in quarters and I want that to be displayed in a line graph, but I want the labels to show hours
(it becomes messy otherwise when showing several days)
Thank You,
Regards
Göran
View 4 Replies
View Related
Sep 5, 2007
Friends, I would like to put employee name and type of leave on the y-axis and on the x-axis the date, so that users can select the date start and end and employee/employees and see the chart or leaves.
But how to do that?
My fields are: Name, LeaveDescription and Date.
The data with me is for each employee, for each date, leave codes are there.
View 4 Replies
View Related
Aug 17, 2007
I have a simple column chart where the x axis is a week number, and the y axis is percent of sales. There are four charts on one page, so this chart is very small. There are only two bars on the chart, and I would like to have the value of the y axis, say 7.2%, be displayed on the bar itself. Currently, I can't decipher the exact value of each bar. Does anybody know if, and how, this can be accomplished? Thank you!
View 1 Replies
View Related
Mar 1, 2007
I'm trying to plot some data with integer x-axis values ranging from 1 to 1000. And I can't get the first x-axis label to be 0 rather than 1. Since I'm incrementing by 100, the rest of the labels are now 101, 201, etc. How do I get these to start at 0? (or even 100...as long as all data shows up)
View 1 Replies
View Related
Dec 8, 2005
In Excel it is possible to have a primary and a secondary axis. This would allow for a chart to show to related data sets that have vastly different scales. Is this possible in Reporting Services.
View 4 Replies
View Related
Jun 5, 2008
I'm just getting into creating charts and one I'm working on could realy do with a prefix on its axis label, the symbol '£'.
I honestly have no idea how to do this and what syntax to use, can anyone help ?.
Also as the label could do with having a thousands seperator as well but as you can tell I'd have no idea how to do this either.
Thanks.
View 1 Replies
View Related
May 29, 2007
How is it possible to have the values on the chart x-axis to be shown vertically rather than horizantal?
Thanks
View 3 Replies
View Related
Nov 27, 2007
Hi!
In SSRS2005 I made an chart,
but on x-axis I only want date-part (if possible ISO-format yyyy-mm-dd).
The resulting chart shows date AND time-part. How to avoid this?
thanks.
View 5 Replies
View Related
Aug 11, 2015
PAGES axis of MDX queries?? Also does this require a specific driver at the client's end??
View 3 Replies
View Related
Mar 6, 2008
Hi,
I would like to know how to keep all values in a category/axis in a table or chart even when there are no values for that value.
Example:
Category value Data
A 11
B 13
C NULL
D NULL
E 14
Currently, category values C and D are disappearing from my tables and charts. I would like to keep them there in both and just show no data.
Any ideas on how to accomplish?
View 2 Replies
View Related
Jul 17, 2007
i put the formula day(Parameters!Parameter1.Value) into my y-axis's major gridlines interval value, and it doesn't obey the value i put in.
is this a bug or another "feature"?
when i just type in "31" is works as expected.
is there a work around for this?
View 4 Replies
View Related
Apr 4, 2007
Hi !
I have A question about the developpe of the axis on the graph.
I explain, when you use a matrix, you can developpe your group with a clic on (+) or (-)
, does it possible on a graph ?
For example, if I display on my axis few years, and if I want to developpe specially one, does it possible, the user clik on a (+) and my axis displays every month in my year...
I have another question, does it possible to have tooltip on a graph ?
Thank you for your answer...
View 1 Replies
View Related
Sep 30, 2007
Hi
I have a report where i am using line chart with date column for grouping.
For X axis i have choosen the "NUmeric or Timescale Values". In the Chart the dates are displayed in this format 1/1/2007 12:00:00 AM . I don't want Time part to be shown
If possible i want it to be shown as 1-Jan. The Chart should display Point even when there is no record returned from the query.
Say DATE Column
Date AMOUNT
1/1/2007 12:00:00 AM 10
1/3/2007 12:00:00 AM 20
1/4/2007 12:00:00 AM 30
Now the Chart should plot from 1/1/2007 to 1/4/2007 including 1/2/2007
Any help on this will be appreciated
Thanks
Smitha
View 1 Replies
View Related
May 21, 2007
I want to display a chart with a minimum y-axis of -10%. When use the value -0.10 the result is a minimum of -100%. Is this a bug?
-Jeroen
View 2 Replies
View Related
Jul 5, 2006
I have a horizontal barchart with integer values, both positive and negative. Major gridlines are shown and I have not specified the interval or the label format. Sometimes the gridline labels (Y axis) show decimal values. Is there anyway to format these? I have tried to format the labels as "#0" but then I see labels occuring twice. I have also played with the intervals, but then sometimes, depending on the values, the zero line is not being shown.
Does anybody have an idea?
Thanks in advance!
Joos
View 4 Replies
View Related
Jan 2, 2007
Hi!
How can I format number on chart's y axis? I wanto to show 1.000 instead of 1000.
Thank you!
View 1 Replies
View Related
