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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,050
Last Active
Roles
Administrator

Comments


  • - try a creating simple test project with a query dataset on a form (i.e. a
    test with just a dataset and no RB). Place the long running SQL statement in
    the query dataset. Put a button on the form and in the button OnClick call

  • - ok thanks for the feedback

    - note that when you zoom in on preview or print the report, the text is
    indented a bit from the border edge, but I do understand that you might want
    to specify it

    --
    Nard Mo…

  • - Simplest way to set the BorderPositions is via the FormatToolbar's Border
    toolbutton which displays an easy to use palette. Setting the border
    positions from the palette results in all selected components being updated.


  • You can try RB 7.04, but I checked the release notes and it only mentions
    improvements for linking on null values and lnking LargeInt fied type. (If
    you are using RB 7.x, I do recommend updating to RB 7.04 as it contained an

  • - use the Query Designer to order the query by property id
    - for the report layout, add a group and place the property information in
    the group header
    - place the image information in the detail band

    The other option…

  • The report explorer should be doing what you describe automatically. It
    should not display the designer if the template does not load successfully.
    I researched this further and the TppReportExplorer.LoadReport method has a
    t…

  • Try using the Report.Template.OnLoadEnd event. You could inspect the
    template and try to fix anything that you can detect is wrong or raise an
    exception.



    --
    Nard Moseley
    Digital Metaphors
    www.…

  • You can replace the existing report explorer form, by creating a custom
    report explorer form descendant class and registering it with ReportBuilder.
    The report explorer has a treeview and listview that are used to display the

  • A couple of options:

    - Set TppDesigner.AllowSaveToFile to true, then run the Report Explorer
    application. Access the Report Designer and use the File | Load From File
    option to load the file. Then you can save it to data…

  • This is a Delphi language behavior, the = operator performs a case sensitive
    comparision of two strings.

    Try this example in a button OnClick event...

    if ('Invnumb' = 'INVNUMB') then
    ShowMessage('Using the =…

  • - I will add this to the list of requested features :)

    - An alternative is to load the report and use File |…

  • - check out the thread in general 'Change Location of RBuilder.ini without
    Designer' posted 7/29/2006.

    - update to RB 10.04 (if you did not receive notification about RB 10.04,
    send your serial number and registeration i…

  • I do not understand. Please create a simple example and send to
    support@digital-metaphors.com in zip format. Include a description of what
    result you are trying to achieve and the issue with the layout. We can look
    at it here…

  • - Select the Shape and then use the Draw toolbar to set the FillColor to 'No
    Fill'

    - Send to Back can also be used to layer objects (i.e. z-order)


    --
    Nard Moseley
    Digital Metaphors
    www.digital-…

  • Here are a couple of examples that use the TdaSQLBuilder class introduced in
    RB 9...

    www.digital-metaphors.com/tips/ApplyAutoSearchValue2ndQuery.zip

    Same example as above, but implemented in RAP code

    www.…

  • - RBuilder\Demos\EndUser\ReportExplorer shows an example of a basic end-user
    application. The report explorer interface provides for the interface to
    manage and organize reports stored to a database. The Data workspace enables

  • Thanks for the feedback. I will put this on the request list..

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com


  • Check out RBuilder\Demos\AutoSearch\Build Description of AutoSearch Settings

    The example shows Delphi code, but similar code will work in RAP.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • Excellent :)

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • - I researched this, the syntax you are using is databasename..tablename,
    which is an abbreviation for databasename.owner.tablename in which the owner
    is dbo (the default owner).

    - The RB Query Tools and daQueryDataView,…

  • Do you have one ADOConnection that your application is using? Or do you have
    three?

    I think that perhaps you are trying to so something that RB was not designed
    to do. ReportBuilder is designed to be used with a single d…

  • I misunderstood your original question.

    Try using the DataDictionary with UseTableOwner set to true. Then the SQL
    query that is generated will include owner.tablename type of syntax for the
    different schemas.


  • - Internally RB calls ADOConnection.GetTableNames to build the list of
    available table names. You can modify the DADE plug-in for ADO, it is
    contained in daADO.pas, check out the method TdaADOSession.GetTableNames.

    - You…

  • Check out the RBuilder\Demos\AutoSearch\Custom AutoSearch dialog. This
    example shows how to create custom autosearch panel classes. The approach
    would be to create custom autosearch panel classes for specific autosearch
    field…

  • - please do not post attachments to the newsgroups. Attachments can be sent
    to support@digital-metaphors.com

    - I cannot emphasize this enough - please read it again. "If you modify the
    source code, restrict the modifcati…

  • - If it were me, I would use the newer SQL2 syntax

    - If you modify the source code, restrict the modifcations to the
    implementation section of daSQL. You should not need to modify anything
    else.


    --

  • - Try configuring the Designer.DataSettings.SQLType to use the SQL2 syntax
    instead. According to this information I found, Oracle 9i supports this
    newer ANSI standard syntax

    in [RAP] - Recompiler Comment by nardmoseley September 2006

  • Not much info to go on here...

    - Is this a behavior that you create in your testing? If the user is at
    another site, have them export the report definition to an .rtm file and
    email it to you.

    - Does it happen…

  • - one option is to use the Report.Template.OnLoadEvent and
    Report.Template.OnNew events to configure the default properties for the
    report

    - the other option is to load the report definition, use the Designer object

  • There are two approaches.

    1. Configure the CalcOrder for the Variables.

    Position the mouse over the band and press the right mouse button to display
    the context menu, then select Calc Order... to display the Calc Or…