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

EU report and params

edited September 2002 in End User
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

Comments

  • edited September 2002
    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

  • edited September 2002
    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!
  • edited September 2002
    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

  • edited September 2002
    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


  • edited September 2002
    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

This discussion has been closed.