bar chart problem

I have read through all posts regarding 'bar chart" or "column chart", but
did not find simliar situation which would resolve my problem, although it
looks simple.
A table/dataset cotains two columns, first ProductID, second
SalesAmountPercentageChange. I linked the bar chart with the dataset, I added
in "values" =!Field.SalesAmountPercentageChange, I added in "series groups"
=!Fields.ProductID. This way, I can have the bars displayed in different
color, which would be the same color if I add the !Fileds.ProductID into
"Category group".
Now the trouble is this, although the SalesAmoutPercentageChange is SAME for
different ProductID ( I have 5 product with 39% change for each) as designed,
the bar length VARIES (!!!) for different ProductID, which does not make
sense. Also, there are five 39% change corresponding to 5 products spread out
along the horizontal-axis (in my opinion should be named as X-axis, yet funny
enough it is actually Y-axis in RS).
I am quite confused. I tried many different combinations, turning things on
and off, still can not make it work. Any help will be greatly appreciated.
Also, I am trying to add into the bar chart another element
"TotalPercentageChange", not sure how to do that. It looks I can not simply
add a value2 on top of the value "!Field.SalesAmountPercentageChange". I
figured that it is necessary to pass a new dataset into chart, this new
dataset would contain the total + original table. Total is something
accessible in the report scope, the question is, where does it reside, how
can I use select statement to pick it out and combine it with original table
into a new one?
$10 for solving this problem, just give me your paypal account :).
--
SincerelyDid you get this resolved?
If not, can you post your RDL? In addition, if you have SP1 installed, there
should be a data cache file (.rdl.data) in the same directory as your .rdl
file. The .rdl.data would show the actual data values you are using.
Alternatively, it would help if you can reproduce the issue with the sample
databases (Northwind or Adventure Works) and post the corresponding RDL
file.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:247C97F2-9783-45C2-8ACA-E085075AFBDE@.microsoft.com...
> I have read through all posts regarding 'bar chart" or "column chart", but
> did not find simliar situation which would resolve my problem, although it
> looks simple.
> A table/dataset cotains two columns, first ProductID, second
> SalesAmountPercentageChange. I linked the bar chart with the dataset, I
added
> in "values" =!Field.SalesAmountPercentageChange, I added in "series
groups"
> =!Fields.ProductID. This way, I can have the bars displayed in different
> color, which would be the same color if I add the !Fileds.ProductID into
> "Category group".
> Now the trouble is this, although the SalesAmoutPercentageChange is SAME
for
> different ProductID ( I have 5 product with 39% change for each) as
designed,
> the bar length VARIES (!!!) for different ProductID, which does not make
> sense. Also, there are five 39% change corresponding to 5 products spread
out
> along the horizontal-axis (in my opinion should be named as X-axis, yet
funny
> enough it is actually Y-axis in RS).
> I am quite confused. I tried many different combinations, turning things
on
> and off, still can not make it work. Any help will be greatly appreciated.
> Also, I am trying to add into the bar chart another element
> "TotalPercentageChange", not sure how to do that. It looks I can not
simply
> add a value2 on top of the value "!Field.SalesAmountPercentageChange". I
> figured that it is necessary to pass a new dataset into chart, this new
> dataset would contain the total + original table. Total is something
> accessible in the report scope, the question is, where does it reside,
how
> can I use select statement to pick it out and combine it with original
table
> into a new one?
> $10 for solving this problem, just give me your paypal account :).
>
>
> --
> Sincerely|||If the <Min></Min> element is missing in the RDL file, then the chart will
use the "autoscale" mode. I.e. the minimum value of all datapoints in the
chart will become the minimum value for the y-axis.
If a Min element is present (but the content is not a valid number), then
the chart control will not use the autoscale mode.
Note: removing a previously specified Min-value in the chart properties
dialog in report designer will only remove the Min element in the underlying
RDL file if the Min-field in the dialog is completely cleared out before
hitting OK.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:E59D78EF-7B4C-4B33-8C3E-3C5D649674DF@.microsoft.com...
> This is an absolute bug. I digged more.
> I made a new chart, adding data set, then value, then series, and it
works,
> But the old chart with problem is still there. I compared the xml section
for
> these two charts side by side, line by line.
> I found only one line of difference, the working chart's rdl has <Min>
> </Min>, the other does not. I went to the report layout and accessed the
> chart property of not working one. in "Y axis" --> "Scale" --> "minimum",
I
> typed in a space, (any other character works two), then it works. all bar
> length goes back to normal. If I do not type anything, then it won't work.
> I believe under the hood, there is no default setting for min, and this
> causes serious problem.
> I am going to reproduce this problem in Northwind db and post the rdl. I
> hope it will be reproduced soon.
> By far, this is a bug in bar chart, I am pretty sure.
>
> "Robert Bruckner [MSFT]" wrote:
> > Did you get this resolved?
> > If not, can you post your RDL? In addition, if you have SP1 installed,
there
> > should be a data cache file (.rdl.data) in the same directory as your
.rdl
> > file. The .rdl.data would show the actual data values you are using.
> > Alternatively, it would help if you can reproduce the issue with the
sample
> > databases (Northwind or Adventure Works) and post the corresponding RDL
> > file.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
> > news:247C97F2-9783-45C2-8ACA-E085075AFBDE@.microsoft.com...
> > >
> > > I have read through all posts regarding 'bar chart" or "column chart",
but
> > > did not find simliar situation which would resolve my problem,
although it
> > > looks simple.
> > >
> > > A table/dataset cotains two columns, first ProductID, second
> > > SalesAmountPercentageChange. I linked the bar chart with the dataset,
I
> > added
> > > in "values" =!Field.SalesAmountPercentageChange, I added in "series
> > groups"
> > > =!Fields.ProductID. This way, I can have the bars displayed in
different
> > > color, which would be the same color if I add the !Fileds.ProductID
into
> > > "Category group".
> > >
> > > Now the trouble is this, although the SalesAmoutPercentageChange is
SAME
> > for
> > > different ProductID ( I have 5 product with 39% change for each) as
> > designed,
> > > the bar length VARIES (!!!) for different ProductID, which does not
make
> > > sense. Also, there are five 39% change corresponding to 5 products
spread
> > out
> > > along the horizontal-axis (in my opinion should be named as X-axis,
yet
> > funny
> > > enough it is actually Y-axis in RS).
> > >
> > > I am quite confused. I tried many different combinations, turning
things
> > on
> > > and off, still can not make it work. Any help will be greatly
appreciated.
> > >
> > > Also, I am trying to add into the bar chart another element
> > > "TotalPercentageChange", not sure how to do that. It looks I can not
> > simply
> > > add a value2 on top of the value "!Field.SalesAmountPercentageChange".
I
> > > figured that it is necessary to pass a new dataset into chart, this
new
> > > dataset would contain the total + original table. Total is something
> > > accessible in the report scope, the question is, where does it reside,
> > how
> > > can I use select statement to pick it out and combine it with original
> > table
> > > into a new one?
> > >
> > > $10 for solving this problem, just give me your paypal account :).
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Sincerely
> >
> >
> >