Chart problem with report - Series Group issue??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

p-rat - 26 Aug 2008 18:12 GMT

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.

Reply to this Message

Sean Boon - MSFT - 26 Aug 2008 21:07 GMT

If your data set is as follows.

Date Budget Actual
====== ===== =====
1/1/2008 5000 6000

with a row for each day, you can just add budget and actuals as values and
the date as the category grouping.

-Sean

Signature

Sean Boon
Program Manager, Reporting Services

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

> 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
[quoted text clipped - 17 lines]
>
> If anyone can help me out I would appreciate it. Thanks.

Reply to this Message

p-rat - 27 Aug 2008 16:37 GMT

On Aug 26, 3:07 pm, "Sean Boon - MSFT" <seanb...@online.microsoft.com>
wrote:

> If your data set is as follows.
>
[quoted text clipped - 38 lines]
>
> - Show quoted text -

Sorry. Here might be my row of data:

Company

Reply to this Message

p-rat - 27 Aug 2008 16:50 GMT

On Aug 26, 3:07 pm, "Sean Boon - MSFT" <seanb...@online.microsoft.com>
wrote:

> If your data set is as follows.
>
[quoted text clipped - 38 lines]
>
> - Show quoted text -

Sorry. Here is my row of data coming from SQL Script:

Company Day1Actual Day2Actual Day3Actual......... Day1Budget
Day2Budget Day3Budget
ABC 100 100
125 150 175 175
XYZ 100 150
150 200 200 200

Here is how I have it placed on report:
8/1/08 8/2/08 8/3/08 ,etc

--------------------------------------------------------------
detail row: ABC 100 100 125 (actual)
detail row: 150 175 175 (budget)
detail row: XYZ 100 150 150 (actual)
detail row: 200 200 200 (budget)

report footer (sum) 200 250 275 (actual)
report footer (sum) 350 375 375 (budget)

So I'm needing a line report that shows the 31 days across the bottom.
I need one Series group as actual and one series group as budget so
they are both running horizontally across the chart. Any ideas?

Reply to this Message