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

Various Questions

edited October 2007 in End User
Hi!

I'm considering purchasing Report Builder to allow the creation of custom
reports by end users and I have a few questions:
- I understand that source code is supplied, but is it possible to hide the
Object Inspector in the designer altogether without loss of functionality,
say by creating new menu items to replace some of the properties?
- In the Query Wizars/Query Designer, can I hide the list box columns that
reference the actual database tbale/field names, and show the data
dictionary names?
- Is it possible to deploy a report to the end user with "embedded" data
sets, such as parameterized queries or stored procedures?
- If I deploy such a report, can I disable the options to add/modify/view
the data sources' SQL?

Thanks in advance

Pedro

--
"There are 10 different kinds of people in this world:
those who understand binary, and those who don't".

Comments

  • edited October 2007
    Sorry! I forgot to mention I'm using Firebird database engine and Delphi as
    the development tool...


  • edited October 2007
    Hi Pedro,

    Thanks for your interest in ReportBuilder!

    1. It is possible to hide the built-in object inspector however you may
    loose some functionality for certain objects. You will find that most
    functionality needed for creating reports is included in the designer
    toolbars and popup menus. I would suggest trying it out and seeing what you
    need to use.

    2. The Query Wizard and Query Designer are fully customizable. Replacing
    the forms used for these features is a fairly simply process. Examples of
    replacing dialogs in ReportBuilder can be found in the Tutorials.

    3. > - Is it possible to deploy a report to the end user with "embedded"
    datasets
    Yes, using DADE (data tab in the designer).

    ReportBuilder does not support parameterized queries from within DADE
    however it is possible to use the AutoSearch feature to give the same
    effect. Stored procedures are not natively supported however it is possible
    to use them by creating a custom dataview for DADE. A fully example of this
    can be found in the \RBuilder\Demos\4. EndUser Databases\SQL Server\2.
    ADO\StoredProc\... directory. (this is an ADO/SQL Server example but the
    same concepts will apply for Firebird/Interbase).

    4. Yes, you can disable DADE for your end-users by simply leaving the daIDE
    unit out of your uses clause. This will prevent the feature from being
    registered for the end-user designer however your previously created
    datasets will still function.


    --
    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.