Stacked Column Chart - Incorrect Aggregate ???

Question

Stacked Column Chart - Incorrect Aggregate ???

sgmunson

SSC Guru

Points: 110640
More actions
December 23, 2010 at 12:55 pm

#229883

I'm using SQL 2008 Reporting Services, and deploying the report from a SQL 2008 R2 Express version of BIDS, and I have a problem with a chart that appears in the Body of the report, where I use a date field representing a given month as the field within "CATEGORY GROUPS", and a text field within "SERIES GROUPS", and a numeric field that is "Summed" for the Y value for a stacked column chart.
The problem is that if you sum all the record values for the summed field for a given date and category group, the totals are WAY off, as if the CATEGORY GROUP had NO impact on the sum operation. Is this a feature or a bug, or is there some other consideration?
Steve
(aka sgmunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

This working too close to a holiday has to stop... I must be going nuts... I discovered my problem was self-inflicted. I had the WRONG FIELD selected, even though my Y value expression should have been correct, that just doesn't seem to apply if the field for the series isn't a match for the one in the expression.

As with the Mythbusters.... I, in particular, am BUSTED....

Gall dang, rassafrassin, sassa rassa ,,e$%#$#Q$Q#$#%#<#R% !!!

Oh well... another day, another lesson in humility...

Steve

(aka sgmunson)

:w00t::w00t::w00t:

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

LutzM SSC Guru Points: 107049 More actions · Answer 2

The good part of it: you catched it before the Holidays. So you don't have to worry about it anymore. And I'd be surprised if there would be a single person around saying "it never happend to me"...

Regarding your phrase "I discovered my problem was self-inflicted." we sometimes use the term "During a rather large investigation it has been proved the system worked as requested and the problem was in front of the screen, not behind it." 😛

Merry Christmas, Steve!!

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

sgmunson SSC Guru Points: 110640 More actions · Answer 3

Merry Christmas indeed !!!

P.S. - your description of the nature of the problem has an acronym:

PEBKAC (Problem Exists Between Keyboard And Chair)

:-D:-D:-D

Steve

(aka sgmunson)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)