Home Component Writing
New Blog Posts: Merging Reports - Part 1 and Part 2

Custom Label with TableName and field Name drop downs

edited May 2008 in Component Writing
I was curious if there is a way to do the following:

In my database, I have User defined fields have TableName, FieldName,
FieldAlias as fields.

Is there a way to make a custom component in the report designer that
will have in the drop down (like on a DBTExt component), the table names
in the first drop down, and the field names in the second drop down.
Then when printing, the field alias will be printed.

Comments

  • edited May 2008
    Hi Jeff,

    Although we have not tried creating a component like this it should be
    possible.

    Your component would probably need to manually access the dataset and
    compile lists of the available tables and fields the user can select.
    Instead of trying to add dropdowns to the toolbars in the designer (which
    would require an advanced knowledge of how the toolbars currently work) I
    would recommend leveraging the built-in object inspector to allow your users
    to select the proper values. The object inspector will automatically
    include any published properties of a RB component.

    An even simpler solution would be to give your users a custom dialog that
    takes the information about the table and field, then automatically creates
    a DBText component on their report returning the proper data.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.