Custom Label with TableName and field Name drop downs

rbuser

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.

nicocizik

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