EU report and params

rbuser

Hi!
Can you please give me advice (idea!) what is the easiest way to implement
parameters in EU reports (i.e. changing date values in SQLs stored in EU
database, but with some user friendly interface....). I want to use primary
inerface like in your EU demo with some modifications...if possible!
Regards,
Damir Vadas

digitalmetaphors

You can use a custom autosearch dialog. See the RBuilder\Autosearch demos
for examples on modifying the search criteria that is in your end user
reports and also for an example of a custom autosearch dialog.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

THX but I have to make several different parameters depend on SQL
definition. And I would not like to make any changes to exe fle but to some
params outside the program.
Autosearch is option with fixed params for known query, but in EU user are
installing many SQL definition (let me say this is a some project manager)
and then "normal" user should throug "Autosearch like" form change
parameters of predefined query.
Is that possible at all?
THX!

digitalmetaphors

Is your goal to modify the persistent searchc riteria values stored inside
the tempalte definition?

One thing you can do for the project manager user is that you can give them
the ability to use the report designer and DADE. Once they have access to
DADE, they can access the dataviews in the report. They can add criteria
objects to the dataviews if they would like using our normal interface. Is
this what you mean?

In the autosearch demos, there is an example which shows how to modify the
end user search criteria at runtime.

Another solution is that you have to create a custom autoserach dialog to
edit the search criteria as shown in the autosearch demos. You'll have to
change the exe to do this.

The only other way to set the persistent search criteria stored in the
template is to use another exe which could load the report templates from
the database and then you could change the persistent search criteria values
in the reports at runtime and then save the templates back down to the
database with the new default search criteria values.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi!
THX for your answer!
I need one Report component which will load from database different reports
(let's say with no other events in TReport component) and then with EU show
different SearchPanel's (from Autosearch), which will end user define. Is
that possible at all, without changing exe for every other SQL (with
different params!)?
Regards,
Damir Vadas

digitalmetaphors

Are you using RB Enterprise? You can use RAP to show different autosearhc
dialogs for the same report based on conditions you have at runtime. In the
RAP global OnCreate event handler, call a RAP pass through function. In
this method, you can make one of a selection of registration calls to
register your custom autosearch dialog. Move the registration of your
custom autosearch dialog out of the initialization section and move them to
this pass through function's method call. There are demos of creating a RAP
pass through function in your RBuilder\Demos\0.Rap directory. This would be
the easiest way to show one of many dialogs for the same report, based on
the user's selections or user ID.


Cheers,

Jim Bennett
Digital Metaphors