Home Component Writing
New Blog Posts: Merging Reports - Part 1 and Part 2

Chart skipping missing values in Data Pipline

edited August 2004 in Component Writing
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

Comments

  • edited August 2004

    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.



    --


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.