|
Home > Archive > MS SQL Server Reporting Services > November 2005 > Bar Chart Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Bar Chart Question
|
|
| Johnny C 2005-11-30, 9:23 am |
| I am creating a bar chart which contains a category for days of the week and
various values for data. I need to add a total bar that sums values for the
week. Total is not available from the dataset and the category, which is a
field from the dataset doesn't have a value for total either. Has anybody out
there attempted to built something like this?
| |
|
| I did a similar thing.
I made it available in the dataset by doing a
union select 'Total', Sum[theData]
This will add total to the column with the single value names which will
have the total value in the value column.
then it will automatically be in your graph.
Hopw that helps, explanation was a bit rubbish
"Johnny C" <JohnnyC@discussions.microsoft.com> wrote in message
news:8DD592D3-6FD8-4CCB-B9F2- E2918B29C9DA@microso
ft.com...
>I am creating a bar chart which contains a category for days of the week
>and
> various values for data. I need to add a total bar that sums values for
> the
> week. Total is not available from the dataset and the category, which is a
> field from the dataset doesn't have a value for total either. Has anybody
> out
> there attempted to built something like this?
|
|
|
|
|