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

TeeChart and RBuilder datapipeline calc variable

edited April 2008 in RAP
Hi,

I'm trying to build a Chart from simple data.
I had originally 1 dataset with gender / contract type / count.
It doesn't appear to be possible to split this in 2 series so I made 2
dataset.

One with "man" data (contract type and a count() op the Calc tab) and
the same with "woman" data.

I made a serie1 for the men where I chose dataset "Man", label
Contract type and Bar = Count().
When I try to do the same with serie2 for the women I canno't "see"
(or select) the "Count()" field. Only contract type as label.

Can anyone help me?
I cannot find any help on the Steema website...

Thankx

Chantal

Comments

  • edited April 2008
    Hi Chantal,

    We have not seen this behavior before. Be sure the second series is
    connected to the second datapipeline. Double check to be sure the Count(*)
    field is present in the second dataset. In my quick testing I created two
    similar datasets each with a Count(*) calc field and was successfully able
    to access that field in each series of a DBTeeChart for each pipeline.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2008
    I have controlled everything and I don't get it.

    Can it be that the systeem gets a little confused because my 2 dataset
    are based on the same tables/fields, with only different search
    criteria's?

    I've tried to give them different names (via the SQL tab), but I still
    cannot see the count(*) variable in the serie source...

    I've also tried to add other calc variables, I don't see them either.
    Only normal fields.

    I'll try building the report again in a different order to see what it
    does.

    Thankx,

    Chantal

    On Mon, 14 Apr 2008 09:03:45 -0600, "Nico Cizik \(Digital Metaphors\)"
  • edited April 2008
    Hi Chantal,

    Which version of TeeChart and ReportBuilder are you using?

    If possible please create a simple example demonstrating the issue that I
    can run on my machine and send it in .zip format to
    support@digital-metaphors.com and I'll take a look at it for you.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2008
    We use TreeChart Pro v7.12.

    I managed to make one that works, with another field, instead of
    contract type per gender I did age group per gender, I builded the
    dataset with de "wizard" instead of manually in the design window.
    It's actually the "same" report, only the data in that field is
    different.

    I get a nice chart with both series on it.

    I'm wondering if the "data" could generate the problem.

    It's actually funny, I made the same report 4-5 times, and sometimes I
    get the count field for one of the series, sometimes for none of them.
    I can see it when I select the label but then is the list empty by
    bar...

    If I manage to make an example that "crashes" via Delphi (our report
    builder is embedded in our software) I'll send it.

    Thankx,

    Chantal


    On Tue, 15 Apr 2008 08:54:10 -0600, "Nico Cizik \(Digital Metaphors\)"
This discussion has been closed.