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

Using ReportBuilder in a Multi-tiered Web Application

edited June 2002 in General
We are investigating converting our current client/server application which
uses Oracle 8i of the backend and DOA components to connect to it to a
multi-tiered application using ActiveForms in the client application to
allow it to be run it a browser on the client PC. Does anyone have any
experience implementing ReportBuilder into such an application? Does
Digital-Metaphors have a demo of such an implementation?

We are going to have an Application Server program installed on a server PC
and that will connect to our Oracle database. Then we are going to have an
Activeform client application that will be installed on our web server.
This can then be run via Internet Explorer from any client PC.
--


Kevin

Comments

  • edited June 2002
    Sounds cool. We don't have a live demo at this time. We are developing the
    Server Edition as we speak. It is able to serve reports over the web using
    no web browser plugins, as it generates javascript/HTML for the browser
    (Netscape and Internet Explorer). We are a couple of months away from
    release.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited June 2002
    "Kevin Campbell" wrote in message
  • edited June 2002
    This doesn't really answer my question. Can I use ReportBuilder in my
    client ActiveForm program to display reports? Will ReportBuilder pipeline
    objects attach to TClientDataSets the same as they do directly to TDataSets?

    Kevin
  • edited June 2002
    Yes, you can.

    You can connect a report pipeline to a TClientDataset since it is a TDataset
    descendent.

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited June 2002
    Thanks you.

    Another question. We have several reports that are called from within our
    application but use an internal data pipeline (on the data tab) rather than
    an external dataset and pipeline on the form that calls the report. Now,
    when we move this setup to a multi-tiered environment the report components
    will be installed on either an ActiveForm called from a web browser or onto
    a form in a thin-client application using TClientDataSets to connect to an
    AppServer application. The client app will not have database connectivity
    directly. It won't have the Oracle client installed. It connects to the
    AppServer which is what has the database connectivity.

    I can see how the reports that use datasets that are on the form can connect
    to the AppServer by using TClientDatasets and connecting the pipelines to
    those, but how can an internal dataset connect to the AppServer?

    Kevin
  • edited June 2002
    You can use MIDAS and the daMIDAS DADE plugin to connect. daMidas is
    available from this page on our website:

    http://www.digital-metaphors.com/subpages/friends/data_dade_addons.html


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited June 2002
    I got that plugin and I tried to add it to the rbDOA66 package and I got the
    following errors when I tried to compile the package:

    First I got: Required package rbDAD56 not found.
    I looked in the source for the required packages and I changed the package
    to rbDAD66 because I found that package in the lib folder.

    Then I got the following error:

    daDOA.pas (12): Bad packaged unit format: rbRCL66.dcp.ppClass.

    What is the problem? I'm using Delphi 6 Enterprise Trial and ReportBuilder
    6.03 for Delphi 6.

    Kevin
  • edited June 2002
    Sorry, ReportBuilder doesn't install into Delphi 6 trial edition.

    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.