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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,048
Last Active
Roles
Administrator

Comments


  • ReportBuilder's DataPipeline linking does not currently support linking on
    Guid fields.

    One option might be to convert the Guid to a string in the SQL so that the
    result sets are linked on string fields.

    Another…

  • For future reference, please choose either the newsgroups or
    support@digital-metaphors.com. :)

    I resea…

  • You can remove the Designer menu options as describe before. However to
    remove the toolbar options would require that you modify the source code -
    that is the only way.

    Below is an article that lists some options for contr…

  • The same menu items are used for the Designer's View | Toolbars menu and the
    popup menu. You can use the TppDesigner.Menu property to access the items
    and toggle their visibility.

    Here is an example that hides the report t…
  • ------------------------------------------------------
    Article: TroubleShooting: Report Prints Endless Pages
    ------------------------------------------------------

    1. Check each report/childreport and make sure that the Report.D…

  • A couple of options I can think of:

    1. Modify the DADE plug-in for Advantage, daADS.pas and put the code in
    there.

    2. Use the Report.Template.OnLoadEnd event to attached the DataSet event
    handler. You can use th…

  • You can create your own wizards/designers. One approach would be to copy the
    existing wizards/designers and then create your own and register them with
    RB. The DADE units are located in RBuilder\Source and are prefixed with
    'da'…

  • What are describing is actually the manually join feature. When you select
    two tables for a query the Join dialog is displayed. The Query Designer
    attempts to be helpful by pre-selecting similar fields for the join.

    For an…

  • If the database field is a Boolean field you can define a DisplayFormat that
    looks like this:

    Yes;Not

    If the database field is a String field then you will need to implement an
    OnGetText event-handler


  • As an example open the RBuilder\Demos\EndUser\ReportExplorer\EndUser.dpr
    project. Make the following modifications.

    1. Modifiy the LoadEndEvent method to look this

    procedure TmyEndUserSolution.LoadEndEvent(Sender: TO…

  • I think what want you to do is press the Print button from the Report
    Explorer and then use the Print dialog to print the report to .rtf and email
    it.

    There are some add-on products for ReportBuilder that add additional ex…

  • Sorry, but the built-in formatting capabilities of the Crosstab are limited.
    Neither of the features that you are request are currently implemented. The
    RBuilder\Demos\Crosstabs example reports show what events are available and

  • If you want to build a high performance web reporting solution, do not use
    the BDE, CGI, or RB 6.x

    Use ReportBuilder 7 Server Edition.

  • 1. Update to ReportBuilder 7. That is my recommendation. ReportBuilder 7
    includes support for D5, D6, and D7. ReportBuilder 7 contains hundreds of
    improvements over RB 6. ReportBuilder 7 is currently being used in high
    performan…

  • 1. Check out ReportBuilder Server Edition. It can probably do what you need
    right out of the box.

    Live Demo: www.digital-metaphors.com/RBServerLive

    Features: www.digital-metaphors.com/Subpages/Products/Server/Feature…

  • Below is an article on creating custom report wizards. I recommend that you
    copy any of the existing wizards in ReportBuilder and customize them into
    your own custom wizard classes. You can register your customer wizards so
    that…

  • Try putting something like this in Report.BeforePrint event:

    if (HalfSheet) then
    myreport.PrinterSetup.PaperHeight := 5.5; // 1/2 of 11


    --

    Thanks for supporting ReportBuilder! Please vote for Rep…

  • One option is to set the detail band to be half the height of the page so
    that it the report can print two records per page. Is that what you mean?
    Are you trying to print a fixed size form layout?



    --

  • There are no known issues with ReportBuilder and Win98.

    Perhaps try updating the printer driver and video driver for the Win98
    machine.



    Nard Moseley
    Digital Metaphors Corporation
    www.digital-met…

  • I looked at the source code to BuilderControls.pas.

    Try modifying the TDrawRotatedText class so that the Angle and Origin
    properties are declared as 'published' rather than 'public'.

    Recompile the unit and regenerate…

  • You need to include the BuilderControls unit in the 'uses' clause of your
    archive reader application.


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



  • The Query Designer does not support SQL Unions. You would need to manually
    edit the SQL Text.

    Some database products support an inline if statement. That might help
    because you can have a field like this:

    IIF(…

  • You need to extract the TdaSQL object associated with the DataView. Here is
    an example that you can download....

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

    --


  • This question is answered in the Devices newsgroup. Please do not cross
    post.


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



  • We have not tested the combination of dbExpress and SQLServer. I recommend
    the following approach:

    1. As a first step, get the RBuilder\Demos\EndUser\SQL Server\ADO example
    working correctly on your machine and your databa…

  • You need to add daDBExpress to the uses clause of the end-user application.
    Check out the example located in RBuilder\Demos\EndUser
    Databases\Interbase\DBExpress.

    Also see the following article...



    --…

  • 1. The following example shows how to use the BandsPerRecord property to
    skip labels.

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

    2. You can use the Report.PrinterSetup properties to configure the paper
    size, …

  • You can define Report.Parameters[] to hold the values of the parameters.

    You can define a custom RAP pass-thru function that displays a custom input
    form. Run the RBuilder\Demos\Rap\Main\Rap.dpr application. Demo 35 contains


  • There is no Help events being fired from the Dade windows, that is correct.

    It is possible to create custom QueryDesigner and QueryWizard forms and
    register them with ReportBuilder. The following article explains how to

  • Have not heard of this before, this is not a known issue.

    1. Try updating to RB 7.04, the latest release. (Contact
    info@digital-metaphors.com with your full registration information,
    including serial no).

    2. Try…