RB Server Edition

rbuser

Hi,

I use Report Builder right now with my Delphi 7 Application. I display a
window to the user allowing them to enter the search criteria for the
report. I then query the database and store the results in client datasets.
Finally I use data pipes to pass the tables to the report.

I have a client that would like to be able to basically do this via a web
browser. I am currious if the Server Edition of Report Builder can be used
to do this with my existing code. Would the fact that the forms that I have
created gather information from the user and manipulate the sql statements
accordingly be an issue.

Thanks,
Richard Gostin

nardmoseley

1. Simplest solution is to use RB's AutoSearch feature in the creation of
your reports.

This results in an ask at runtime dialog being displayed to the user. RB
Server Edition automatically generates the web forms required to support
autosearch. To see an example, run the live demo on our web site and choose
Live Reports\Customers\Customer AutoSearch. Here is a link to the live demo

www.digital-metaphors.com/RBServerLive

The example mentioned above requires no code. The visually query designer
available from the RB Data workspace was used to define the query. The query
contains search criteria that is designated as AutoSearch. RB Server Edition
handles generating the ask at runtime form, passing parameter values to the
server and it handles dynamic modification of the SQL.

2. You can also take a more manual approach. You can define
Report.Parameters that can be passed between the server and webtier. You can
build custom web forms to gather the data and write custom code in the
server and webtier to process the parameters. RB Server Edition installs an
example of how to do this.


-------------------------------------------------------
Tech Tips: RB Server and Custom Parameters
-------------------------------------------------------

The RBServer Custom Parameter demos show how to define custom session and
report level parameters that can be used to implement security and other
types of custom processing.

The are three projects that work together. Each project includes a
ReadMe.doc and commented code.

1. RBServer\Demos\Servers\Custom Parameters
2. RBServer\Demos\WebTier\Custom Parameters
3. RBServer\Demos\Clients\Custom Parameters


The demos include examples of how to...

1. Define Custom Session parameters.

A custom login form is displayed. Based upon the login, the catalog of
reports available to the user is filtered.

2. Define Custom Report parameters

A custom parameter form is displayed. The parameters are used by the report.

3. Custom AutoSearch form

A custom autosearch form is displayed. The parameter values are used by the
autosearch criteria.