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

TeeChart & RB

edited September 2013 in General
HI Guys,

D2007, RB14, TeeChartPro 2010.

I have a TeeChart on a Form, all good.

What is the simplest, most exedient way of having that same chart
appear in an RB report?

Is there any way to link a form TeeChart & an RB TeeChart?

Similarly, I have a 5 column Grid with the Data that was applied to
the Form Teechart. It has 200+ x-axis data points.

I would like that grid/data to appear in two side by side 'Columns' of
5column grid in the Report.

Again, is there a simple, direct way of tdoing this?

Regards & TIA,

Ian.

Comments

  • edited September 2013
    Hi Ian,

    You have two options with the TeeChart.

    1. Recreate the TeeChart using the embedded TeeChart component in
    ReportBuilder.

    2. Display an image copy of the TeeChart on the form inside the report.
    We have many customers using this method so they can have identical
    charts on their forms and reports. See the following article on how to
    accomplish this with RB.

    http://www.digital-metaphors.com/rbWiki/RCL/Chart/How_To...Chart_As_Image

    For the grid, I'm a bit unclear about what you would like to accomplish.
    Do you want a copy of the grid itself inside the report? If so, there
    may be a way to do this similarly to the TeeChart method described above.

    If you just want the grid data inside the report, you can either connect
    the underlying dataset to a pipeline and retrieve it that way or you
    could use a JITPipeline to manually retrieve the data from the grid and
    display it on the report.

  • edited September 2013
    Hi Nico,

    Umm. I did reply to this but it seems to have dissappeared. Wonder
    if it is because I attaced an image.


    I like the image idea. It would mean maintaining only one Chart.

    I used the JITPipeline method to load the data to the report.

    Regards & thank you,

    Ian
  • edited September 2013
    Hi Nico,

    OK. Almost there. Got the Data, got the Image.

    Two things..

    1. No matter what order the two section subreports are in, the 'graph'
    page prints before the Data/Table page. Prefer the other way round.

    2. How do I get the Chart image to appear centered on the landscape
    page, vert & horiz, when in Preview & printed? I have
    'AlignHorizontal' & 'AlignVertical' set to Center in each case in the
    Image properties.

    Regards & TIA,

    Ian
  • edited September 2013
    Hi Ian,

    1. Section subreports print based on z-order. You can use the Bring
    Forward or Send Backward commands when right clicking over the subreport
    components to adjust this.

    2. The easiest way to center a static image such as a TeeChart is to
    create a new Page Layer. This will give you a workspace the size of the
    page to position the image. Another option is to stretch the detail
    band to the height of the page and place the image in the correct position.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2013
    Hi Nico,

    Again, thank you for your support.

    z order - I think I accidentally discovered that while playing around
    when they swapped around but didn't realise it. Now I know what I
    did..;-)

    Page Layer - Not sure about what this means. Never done anything with
    it. Is there a Demo of its use? I did stretch the band as suggested
    and positioned the 'image'.

    FYI - When I loaded the TeeChart Demo it came up against an issue
    about the Series. There seems to have been a change in TeeChart or RB
    that now causes an error. I am using D2007, RB 15.01 & TC 2013.

    Regards,

    Ian

  • edited September 2013
    Hi Ian,

    Here's some information on Design Layers. They can be useful for full
    page designs and report organization.

    Design Layers can be used to separate a report layout into logical
    layers. Every report layout always has a Foreground layer. To add a
    background layer select the Designer Layers node in the tree view. Next,
    press the right mouse button and select either New Page Layer or New
    Band Layer from the context menu. A tab set will appear just below the
    report tree and just above the object inspector. Use the tab set to
    select a design layer for editing.

    A bullet point list of the some of the Design Layer features is provided
    here

    http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_14

    Also check out the RBuilder help topic for TppDesignLayer and its
    properties.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.