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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,049
Last Active
Roles
Administrator

Comments


  • -----------------------------------------
    Article: End-User Tech Support
    -----------------------------------------

    Please understand that Digital Metaphors can only provide tech support to
    the Delphi developers that p…

  • Probably simplest to use two queries. For the main query define the
    autosearch criteria. For the summary query, define a search criteria that is
    not designated as autosearch.

    Use the Report.OnGetAutoSearchValues event to a…

  • We have created a new Case Studies section on our web site. If you or anyone
    else would like to contribute, please contact info@digital-metaphors.com.

    in Ultimate End User Reporting Tool Comment by nardmoseley December 2004

  • You can add search criteria to the master query so that only the master
    records that you want to include in the report are retrieved from the
    database. ReportBuilder will generate special linking SQL for the detail
    queries that …

  • If the database field is boolean you can either

    1. Use the DisplayFormat property to control the display. For the
    DisplayFormat you can specify S;N.

    2. Override the default formating by descending from TppDisplayForm…

  • If you set DetailBand.PrintHeight to phDynamic, then the detail band can
    break across pages.

    Another approach is to create a main report with no header/footer. Place two
    subreports in the detail band and set each to pbSect…

  • 1. Open the datasets associated with the report explorer.

    2. Initialize the printer driver. There is some additional overhead that
    occurs for the very first repoirt that is previewed/printed. You can
    manually force RB to i…

  • I think the approach would be to modify the dataview when the report loads,
    rather than trying to modify what is saved down.

    There are two options:

    1. You can write code to extract the TdaSQL object from the DataView…

  • Yes, that will work also. :)


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital…

  • Check out the TppLayoutFactory class defined in ppRptWiz.pas. This class can
    be replaced with your own custom descendant class. This class is used by the
    report wizard and the data tree drag-n-drop. There is a SetComponentSize
    m…

  • Sorry, but Guid field linking is not currently supported.

    The next release, ReportBuilder 9, will include support for Guid field
    linking.


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digita…

  • 1. Create a master query that contains a list of unique reconciliation
    numbers. Order the query by reconciliation number:

    Select Distinct ReconciliationNo
    From SomeTable
    Order By ReconciliationNo

    2. Link th…

  • This is not a known issue, nor can we reproduce it here.

    Please provide steps for reproducing this error. Use the
    RBuilder\Demos\EndUser\ReportExplorer project.


    --
    Nard Moseley
    Digital Metaphors Corp…

  • We are not aware of any RB TeeTree components.

    You could creating an RB wrapper component for TeeTree, this would be
    conceptually similar to the RB TeeChart wrapper. See ppChrt.pas and
    ppChrtDP.pas for the source code to t…

  • My guess is that the report definition was saved down with the
    TppReport.ShowPrintDialog property value set to False. Try loading the
    report and setting that property to True. You can use the
    Report.Template.OnLoadEnd event to i…
  • Answered in the Dade newsgroups, please do not crosspost.

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

  • Check out the articles in the Templates and EndUser threads of the Tech Tips
    newsgroup.

    Note that there are two types of database storage possible. A simple table
    that has the Name and Blob orthe report explorer tables tha…

  • Sorry I do not understand the question. Perhaps this will help...

    -------------------------------------------------------
    Tech Tip: Controlling Designer New, Save, Open actions
    ---------------------------------------------…

  • For future reference, it is against newsgroup guidelines to post
    attachements. Please send attachments to support@digital-metaphors.com in
    zip format.

    1. Check out the articles in the Calculations thread of the Tech Tips

  • 1. Just sent you the patch file for calculated field aliasing. Sorry, never
    received your prior request.

    2. Sounds like the report is corrupted somehow. There are no known issue
    with RAP event-handlers getting lost or re-a…

  • Thanks for that info - perhaps we need to investigate allowing this
    capability. What is the syntax? Can you provide a simple example...




    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital…

  • 1. You can try typing in the SQL text to see whether the database you are
    using will support it. The RB Query tools do not support it because
    performing a Goup By on a calculated column is not permitted according to
    the ANSI Sta…

  • 1. To build a summary query that has Day of Week data, consult your database
    docs and determine whether there is a SQL function that can do that.

    2. ReportBuilder's support for data-aware TppDPTeeChart is datapipeline
    base…

  • I think you need to try a different approach.

    Rather than calling Report.Print you probably need to be using
    Report.PrintToDevices. This enables you to manage the entire process in
    custom code. For a simple example check o…

  • This is an issue that occurs when the machine has no printers drivers
    installed and a TppBarCode component is used. There is a patch available for
    RB 7.04.

    Email support@digital-metaphors.com and request the patch.

  • Thanks for the feedback.

    The current options are to

    1. Create custom dataviews

    For an example see RBuilder\Demos\EndUser\CustomDataViews

    2. Write code to manually handle the autosearch and linking. F…
    in SQL Comment by nardmoseley November 2004

  • Check out ppASCtrl.pas, the method
    TppSimpleSearchPanel.EditControlKeyUpEvent

    You can modify the source code or you need to create your search panel
    classes. For an example see RBuilder\Demos\AutoSearch\Custom AutoSearch

  • The TppDesigner.Notebook property provides access to the TPageControl. Try
    something like

    myDesigner.Pages[0].TabVisible := True/False



    --

    Nard Moseley
    Digital Metaphors Corporation
    w…

  • Thanks for reporting this issue. We have created a patch for RB 9.0. Send an
    email to support@digital-metaphors.com and request the patch.


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphor…

  • 1. There is an RB 9.0 patch available that fixes the
    TppDesigner.ShowComponents feature. Email support@digital-metaphors.com and
    request the patch.

    2. The timing of the ToolbarManager/Toolbar creation and initialization ha…