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

Communicating to RB as a Windows service

edited December 2005 in Server
Hi,

Is it possible to communicate, perhaps using RAP pass-through functions,
dynamically to a RB application registered as a Windows service ?

My problem:
I'm developing applications running on the Internet, either as an Apache dso
or a ISAPI dll, and I would like to do my reporting as a WebTier (using a
TrsWebTier in my application). Depending on the user's choice on drop-down
boxes and radio buttons, I construct the SQL dynamically. It is this SQL
text I would like to pass on to the RB application running as Windows
service.

Or is there another way doing it more elegantly?


Regards,

Nols Smit

Comments

  • edited December 2005

    I recommend that you model this as follows:

    1. Define custom Report.Parameters for the report that correspond to the
    user options.

    2. Use the Report.BeforeOpenDataPipelines event to implement custom RAP code
    that modifies the SQL. You can use the TdaSQLBuilder class to modify the
    SQL.

    3. In the WebTier application, use the techniques demonstrated in the custom
    parameters demo to

    - display a custom web form
    - process the web form by using the web request parameter values to
    initializ the report parameter values.






    Best regards,

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