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

Problems with DataPipeLines

edited April 2002 in General
I have made an small program to design my templates from database.

1)
I have the problem, when I make an .LoadFromDataBase and the DataPipeLine
does not exists, it looses the connection..

If it is possible, I would like to know witch DataPipeLine are connected to
the template.. ar'nt there any way I can get names on those pipelines??

2)
Ar'nt it possible to get the CALC tab i designer??

3)
What do I do with my old template as has .OnGetText events?? They are lost
to.. .(

AnyOne please Help

--
Best Regart
Klaus Ladegaard Jensen

Comments

  • edited April 2002
    1. Make sure you are properly setting up ppReport1.Template.DatabaseSettings
    before you make a call to LoadFromDatabase. Where are all the data access
    components when the report is created. You can create the data access
    components at runtime. If the components are on your form you will need to
    create a new table in the database and store the name of the pipeline when
    the template is saved to the database. You can then access that value when
    loading the template in order to know which pipeline to load the template
    from.

    2. To display the Calc tab in the designer include raIDE in your uses
    clause. Keep in mind that you must have RB Enterprise 5.0 or higher to have
    RAP available to you.

    3. Let's assume you have created a report in Delphi and assign an event
    handlers to the OnPreviewFormCreate event of the report. The event is
    generated by Delphi as:

    procedure TForm1.ppReport1PreviewFormCreate(Sender: TObject);

    You then save the report to an RTM file 'Report1.RTM.' The events are
    stored as references only, and so the RTM contains:

    object ppReport1: TppReport
    .
    .
    OnPreviewFormCreate = ppReport1PreviewFormCreate
    end

    You then go on to work on a different report. Saving it with under then
    name 'Report2.RTM'. Only this time, before you save the report you change
    the report component name to: rptOrders. Delphi automatically updates the
    event declaration for OnPreviewFormCreate event to:

    procedure TForm1.rptOrdersPreviewFormCreate(Sender: TObject);


    You then create two buttons on the form, one to load Report1 and preview,
    the other to load Report2 and preview. When you run the app and click
    Report1, you an error. This is because the Report1.RTM file contains a
    reference to ppReport1PreviewFormCreate, a method which no longer exists (at
    least with this name) in the form.

    One answer is to load all your rtm files into the report component you will
    be using for loading. Fix any errors, reassign any events that get cleared.
    This will update your rtms to contain the proper event handler names.


    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • edited April 2002
    I have only had time to test 2) the calc tab.. I have made an temp fix for
    the other :( But it does not seem to work.. I just added raIDE to the
    usesbut no calc tab appeared..

    Do I need to set an property also??

    -
    Klaus L Jensen

    "Alexander Kramnik (Digital Metaphors)" wrote
  • edited April 2002
    Please look at the Report Explorer demo in
    RBuilder/Demos/EndUser/ReportExplorer for an example of activating the Calc
    and Data tabs. Remove the x from the {x$DEFINE RAP} statement and see if
    that enables the calc tab. Please send a sample project that reproduces the
    problem you are having in 1) to support@digital-metaphors.com.

    You could use DADE available in RB Professional/Enterprise to retrieve the
    data for your reports. This way everything would be stored in the template
    alleviating the need for a data pipeline object on the form.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

This discussion has been closed.