Thanks for your help and to a degree this works, but I want to plot the zero
value when it shows even if it is the first value. For some regions I may
not get a reading till the 10th day so in the chart that line will now not
appear till half way thru the graph and depending on circumstances may end on
the 25th day. Originally I am plotting the zero values but just get
duplicates for the series.
We are using RS 2000 SP2.
Thanks
[quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Assuming you have RS 2000 SP2 installed, you can try the following:
>
> Change the dataset (or use a calculated field or use an IIF expression in
> the chart value expression), so that 0 is represented as NULL in the dataset
> (or as VB: Nothing in the RDL expression). Then the "zero" value datapoints
> will be interpreted as "empty" points, but on the other hand you should
> still get the x-axis starting with 1.
>
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Me and SRS" <Me and SRS@discussions.microsoft.com> wrote in message
> news:D087DFC5-1822-4685-819A-4D768FD80618@microsoft.com...
> >I have a line chart where I am displaying values (x axis) for a 30 day
> >period
> > (y axis) for 4 different regions (series). My problem is that when the
> > chart
> > is displayed it is repeating a series value although that series does only
> > appear 30 times. If I change the series to only display 1 region the
> > problem
> > still occurs. I think it may have something to do with zero values
> > returned
> > in dataset ie
> > Day Region value
> > 1 A 0
> > 2 A 1.2
> > 3 A 0
> > 4 A 1.5
> > If I put a filter on to start at day 2 then I do not have the problem,
> > however I don't neccessarily know what day would be the first one without
> > a
> > zero value.
> > I can return values only above zero but I'd prefer to plot that zero value
> > on the graph.
>
>
I seem to have fixed the problem. Even though dataset returned the correct
amount of records (4 * 30) I was still getting duplicate rows in the series.
Had to use the TRIM function on the series field in the chart and just like
that the duplicates disappeared.
Thanks for your help.
[quoted text, click to view] "Me and SRS" wrote:
> Thanks for your help and to a degree this works, but I want to plot the zero
> value when it shows even if it is the first value. For some regions I may
> not get a reading till the 10th day so in the chart that line will now not
> appear till half way thru the graph and depending on circumstances may end on
> the 25th day. Originally I am plotting the zero values but just get
> duplicates for the series.
> We are using RS 2000 SP2.
> Thanks
>
> "Robert Bruckner [MSFT]" wrote:
>
> > Assuming you have RS 2000 SP2 installed, you can try the following:
> >
> > Change the dataset (or use a calculated field or use an IIF expression in
> > the chart value expression), so that 0 is represented as NULL in the dataset
> > (or as VB: Nothing in the RDL expression). Then the "zero" value datapoints
> > will be interpreted as "empty" points, but on the other hand you should
> > still get the x-axis starting with 1.
> >
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Me and SRS" <Me and SRS@discussions.microsoft.com> wrote in message
> > news:D087DFC5-1822-4685-819A-4D768FD80618@microsoft.com...
> > >I have a line chart where I am displaying values (x axis) for a 30 day
> > >period
> > > (y axis) for 4 different regions (series). My problem is that when the
> > > chart
> > > is displayed it is repeating a series value although that series does only
> > > appear 30 times. If I change the series to only display 1 region the
> > > problem
> > > still occurs. I think it may have something to do with zero values
> > > returned
> > > in dataset ie
> > > Day Region value
> > > 1 A 0
> > > 2 A 1.2
> > > 3 A 0
> > > 4 A 1.5
> > > If I put a filter on to start at day 2 then I do not have the problem,
> > > however I don't neccessarily know what day would be the first one without
> > > a
> > > zero value.
> > > I can return values only above zero but I'd prefer to plot that zero value
> > > on the graph.
> >
> >
Don't see what you're looking for? Try a search.
