I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
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?
I dont think it will accept an Expression. unless you have symbol like fx beside it,you cant enter any expression
neither it is bug nor feature.
Only Constants are accepted here.
others: please correct me if i am not correct
Thanks
|||for Y-axis , no expresions are available. Hence you can't have dynamic Y-axis|||no, not all fields with out the expression symbol won't accept expressions. the maximum and minimum fields will accept expressions. i guess that's what lead me to expect major gridlines option to accept it.
seems really stupid to not allow it.
as a side note, the dundas control which DOES show the expression field beside major gridlines also doesn't accept any formula, so it must be some internal failing on the part of RS
|||Hi Tim
The Major Gridlines Interval will accept expressions. I have spent some time working with this to get my charts to display the Y axis scale in consistent way. The key is to derive the maximum value that your chart is going to display dynamically and divide it by the number of gridlines you want displayed.
For example the expression =Ceiling(Max(Fields!Data.Value))/5 will give you five gridlines whose spacing is dependant on the the data selection chosen when the report is run.
In practice I have found that the interaction between Minimun, Maximum and Major Gridlines interval is complex and setting one can have an adverse effect on the other.
As a result I just set one value out of the three depending on what I am trying to achieve.
You can also use expressions containing code if you want to write you own scaling function, which I have found gives the best results.
Hope this helps
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?
I dont think it will accept an Expression. unless you have symbol like fx beside it,you cant enter any expression
neither it is bug nor feature.
Only Constants are accepted here.
others: please correct me if i am not correct
Thanks
|||for Y-axis , no expresions are available. Hence you can't have dynamic Y-axis|||no, not all fields with out the expression symbol won't accept expressions. the maximum and minimum fields will accept expressions. i guess that's what lead me to expect major gridlines option to accept it.
seems really stupid to not allow it.
as a side note, the dundas control which DOES show the expression field beside major gridlines also doesn't accept any formula, so it must be some internal failing on the part of RS
|||Hi Tim
The Major Gridlines Interval will accept expressions. I have spent some time working with this to get my charts to display the Y axis scale in consistent way. The key is to derive the maximum value that your chart is going to display dynamically and divide it by the number of gridlines you want displayed.
For example the expression =Ceiling(Max(Fields!Data.Value))/5 will give you five gridlines whose spacing is dependant on the the data selection chosen when the report is run.
In practice I have found that the interaction between Minimun, Maximum and Major Gridlines interval is complex and setting one can have an adverse effect on the other.
As a result I just set one value out of the three depending on what I am trying to achieve.
You can also use expressions containing code if you want to write you own scaling function, which I have found gives the best results.
Hope this helps
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... 96It looks as thought what I may need is to reset the dataset to look like this:
time events
00-14 1
15-29 2
30-44 0
...
The only way I could do that with the existing tables would be 96 unions.
96 Unions!
Microsoft I must say that I am not so impressed with reporting services. Dragging fields to a myesterous chart "category" or "series" was dumb to begin with.
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?
It sounds like your category grouping is based on the DateTime value. Therefore, data values with the same timestamp are grouped together.
You will need to change the category grouping similar to the "StepFunctionChart" sample discussed in the following whitepaper (near the end): http://msdn2.microsoft.com/en-us/library/aa964128.aspx - search for "StepFunctionChart".
Basically, you need a category grouping expression that will make sure every data row is its own group, e.g. by concatenation:
=Fields!Y.Value & "|" & Fields!TimeStamp.Value
-- Robert
