Chart skipping missing values in Data Pipline

rbuser

Hi, I'm a newbie to this forum.
I'm using ReportBruilder 6.03. I've got a chart reading data from 3 data
Pipelines, trying to compare them in a stacked graph. But I don't always
have each column represented in each Data Pipline (and the query is too hard
to change to include nulls). When I draw the graph, or even look at data in
the Data tab, it is not aligning the columns

E.G.
Pipline A Pipeline B
Perth 57 Perth 23
Sydney 13
Adeliade 1 Adelaide 12
Darwin 2 Darwin 5

The chart does not skip the missing value in the second pipeline.

Any idea how to fix this in the chart, rather than teh query ?

Thanks, Duncan

nardmoseley

For future reference, please post to the General newsgroup if you do not
know which newsgroup to post to. An appropriate newsgroup for data access
related questions is DataPipelines (if using external datapipelines) or DADE
(if using the Report Designer's Data workspace)

1. Simplest way to fix it is to add a condition to the SQL Where clause

Example:

Select Customer.CustNo
From Customer
Where Customer.CustNo Not Null

2. Another alternative is to add DataPipeline event-handler code to skip the
null values. For an example see demo 116 (dm0116.pas) in the
RBuilder\Demos\Reports\Demo.dpr project.



--