Communicating to RB as a Windows service

rbuser

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

nardmoseley

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.