sql server reporting services: Scatter Charts and aggregate functions -- sql server reporting services

Scatter Charts and aggregate functions

Senthil
8/18/2004 1:22:12 PM

sql server reporting services:

I'm trying to create a Scatter Chart to show a distribution based on data
from a database.

The x-axis is a time-series and the y-axis needs a running number (like
rownumber). However, the rownumber aggregate function does not work, or my
understaning of rownumber and how the chart uses it is wrong.

It seems that regardless of the what the expression is for the x-axis
Values, if I don't add a category, the chart shows a sum of the x-axis
values. I was not able to find any more information in the documentation
about this.

Any help would be appreciated.

Senthil

Re: Scatter Charts and aggregate functions

Robert Bruckner [MSFT]
8/21/2004 9:18:59 PM

Yes, there is a bug which prevents the RowNumber aggregate from working
correctly in charts when a series grouping is present.
You might want to try to replace the grouping that uses the RowNumber
aggregate function by an expression which groups on a field or a
concatenation of fields or a formula in case of numeric fields to create
some sort of "unique" id for the grouping (to simulate the RowNumber
aggregate functionality).

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

[quoted text, click to view]