Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2008-08-26 : 13:09:30
|
| In my report I have a row of data that consists of Actual Revenue and Budget Revenue. I have 28 to 31 fields that represent the days of the month across this report.It is a daily revenue report that compares how we are doing against our budget. Report is working fine; however, I need to create a line chart that shows this (actual daily revenue vs. budget daily revenue). I don't know how to create a category that will separate or group this information. I'm new at this, but I believe to achieve what I need....I need two Series Groups in my chart.I tried creating two groups, one with a text box saying "Actual" and one with text box "Budget". I then placed the data in the appropriate grouping and re-formatted my report (at first I had two detail rows on my report, the top being actual and the bottom row being budget). When going into Chart properties and trying to add the two series groups off of the groups I created with text boxes, it doesn't work. If anyone can help me out I would appreciate it. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-27 : 00:11:28
|
| what have you given as expression for values & category groups? |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-08-27 : 11:24:15
|
| I don't have any fields from my SQL script that denote Category. On the SSRS side I merely created two groups. When looking at the groups the expression is ="Actual" and ="Budget".So when going into the Series Group part of Chart properties under data tab I really don't know what to put. I don't show any field "Actual" or "Budget" to select.I'm lost. I can't really figure out how to designate category in my back-end SQL script or I would. I guess I could convert integer to something and add a '-A' for all the actual numbers and a '-B' for all the budget numbers; but it seems like allot of converting going on? |
|
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-08-29 : 12:07:18
|
| I probably haven't explained this problem very well. I will try again. I have a report that works and all is well. My data coming from SQL Server is grouped by Company and has 31 fields of Actual Revenue and 31 fields of Budgeted Revenue. So there are about 70 fields that I have and can put across my report.On the report I have one detail row showing the Company and then the 31 fields of Actual Revenue. I have another detail row hidden underneath this that has my Budgeted Revenue. I sum these two rows in two separate report footer rows. These two rows are what I'm trying to put in a line chart. When looking or choosing 'values' in chart properties I don't know how it differenciates between actual or budget since they are in the same list of values to choose from? Any help with this would be appreciated more than you could know. Thank you. |
|
|
|
|
|
|
Chart Trouble - Series Group issue