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

User defined field question

edited September 2002 in End User
Is it possible for an end user (program uses Delphi5 and Report Builder
Professional 6.03), to actually create a new currency field which could then
be used with a separate calculation and then used in a report ?

Thanks
John

Comments

  • edited September 2002
    In our Enterprise Edition, the end user can code a calculation in RAP. Using
    the Professional Edition, you could use the TppDBCalc for the calculation or
    create a custom component which preforms the custom calculation for them
    after they choose the currency data field from the dataview they created in
    DADE. There is an example of creating a custom component in the
    RBuilder\Demos\RCL directory.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited September 2002
    I see, but what if there is not (at present) the currency field which they
    require.
    Would they be able to create a currency field on the fly ? This could then
    be used as part of another calculation.
    The thing is...
    I have a quotation screen with Report Designer capabilities.
    Some users are asking for extra fields (and i wondered if i could get away
    with showing them that could do it with the Report Builder).
    I think you're previous response was taking for granted that the fields
    wanted for calculation purposes were already part of the source dataset.


  • edited September 2002
    Yes, the user can use DADE to add a new field to the dataview. This is only
    if that field is available in their database before launching the report
    designer. Let's say they are using Access 2000 as their database. Then they
    can use Access to add a new field to the database, populate it with data.
    Then launch the report designer, go into the Data tab (DADE) and define a
    new field on the dataview. In the design workspace they can then add a
    dbText connected to that new field in the dataview they just created.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited September 2002
    Great thanks.
This discussion has been closed.