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

UseTableOwnerName

edited October 2002 in DADE
All,

Apologies for this simple question, but I have just begun reviewing RB7 for
my employer (defecting from Crystal I hope!)

Using the "UseTableOwnerName" property of the DataDictionary, it would seem
that it prefixes the table names with the current logged in user ID. How can
I tell it to use a different prefix from the User ID for table names?

TIV,

Paul Endersby.

Comments

  • edited October 2002
    All,

    Another question while I'm at it.

    On the TppReport component there is a property called ShowAutoSearchDialog.
    The property name would seem to suggest that if I have a report with auto
    search values in it, then by setting it to false, I can suppress the usual
    dialog that it shown (This doesn't happen). My ultimate goal is to show my
    own filter dialog. If I am going about this the wrong way then can someone
    tell me a better way.

    Ta again,

    Paul Endersby.


  • edited October 2002
    Thankyou for evaluating ReportBuilder 7! You'll can generate additional
    entries in the data dictionary to support each table owner name if you want
    to control this on a userID level. Our data dictionary end user tables are
    not complicated. You don't have to use the data dictionary builder to
    generate the entries. You can programatically add entries to customize the
    available tables for each user of the database.

    There is another alternative. Since the data dictionary is fed data from
    datasets on the form, you can always filter these datasets yourself to
    control what is passed from the database to the data dictionary.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited October 2002
    Please start a new thread for each new question. It might get hard to follow
    if there is a long discussion:)

    The autosearch dialog is customizable. You can replace roughly 99% of the
    forms in RB. There is an example of replacing the autosearch dialog in your
    RB installation in the RBuilder\Demos\Autosearch\ directory. You can also
    code more if you want, as show in this custom tip we put together:

    http://www.digital-metaphors.com/tips/CustomAutosearchDialog.zip


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited October 2002
    Many thanks Jim.

    Regards,

    Paul.

This discussion has been closed.