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


  • You might be able to control the ordering of the calculations by using
    BringToFront/SendToBack to control the z-order. (BTW, the report tree tool
    windows displays the components in z-order so you can see the effects of
    BringToFr…

  • Have a look at TppFontList located in ppUtils.pas, it is used to build a
    list of available fonts that are installed on a machine. It includes the
    CharSet information. This is what is displayed in the drop down list of the
    report…

  • One of the items on our ToDo list is to make the designer more customizable
    via plug-in toolbars and such. However this feature will likely not make it
    into the next release. We'll see...


    --
    Nard Moseley
    D…

  • The TppImage has an autosize feature, but the DBImage does not - perhaps
    something we can add to a future release.

    The TppImage resizes the bounds of the control to match the size of the
    picture. Try adding some similar co…

  • Try adding ppJPEG to the uses clause.

    --


  • Check the TppDesigner.DataSettings properties.

    Set TppDesigner.AllowDataSettingChange to true, then run the application.
    From the Data tab select File | DataSettings... to display the dialog. From
    the dialog check that the…

  • Sorry, I think my prior response was not clear.

    We do not have an example that uses FIBPlus. As a starting point, try
    working thru the BDE or IBExpress Interbase example. Each example contains a
    correct configuration and a…

  • 1. You download a DADE plug-in for FIBPlus from our web site.

    http://www.digital-metaphors.com/Subpages/Downloads/CompanionDade.html

  • Try performing the same test with the RBuilder\Demos\EndUser\ReportExplorer
    example.



    --


  • That is the correct event to use. When I test that code here using the
    RBuilder\Demos\EndUser\ReportExplorer\EndUser.dpr project it works
    correctly.



    --

    Nard Moseley
    Digital Metaphors Corporatio…

  • example:

    mySQL.EditSQLAsText := True;
    mySQL.SQLText.Text := 'select * from clients';



    --


  • ----------------------------------------------
    Tech Tip: Limitations of using TdaSQL.SQLText
    ----------------------------------------------

    The TdaSQL object can contain either an object based description of the SQL
    (…

  • Please see the two articles below. I think they will help you to understand
    how to perform the calculations in RB.


    ------------------------------------------------------------------------
    TECH TIP: Performing Calcul…

  • Have not heard of this issue before. Can you create a simple example by
    modifying one of the ReportBuilder end-user examples. Email to
    support@digital-metaphors.com in zip format and we can run it here in the
    Delphi debugger and…

  • I was referring to the DBImage.OnGetPicture event.

    DataPipelines simply respond to requests to traverse data and retrieve data
    field values. DataPipelines do not know about the data-aware controls.
    (Data-aware controls kno…

  • 1. Sorry, I misunderstood the question about the image.

    a. The Sender parameter to the OnGetPicture event contains the DBImage
    object reference.

    var
    lDBImage: TppDBImage;

    begin
    if not Sender …


  • 1. The TPicture Width and Height properties indicate the size of the graphic
    in screen pixels.

    To modify the size of the TppDBImage control to be the same size as the
    picture, do the following:

    if (Pictu…

  • True.

    But you can gain access it to it...


    For example, try this.....

    uses
    ppExpFrm;

    procedure TmyEndUserSolution.ppReportExplorer1Show(Sender: TObject);
    var
    lForm: TppReportE…

  • You essentially need to refresh the dataset and the report explorer.

    1. Refresh the dataset.

    There is a DataSet.Refresh method. You could call this directly. If the
    DBPipeline has RefreshAfterPost set to true, then D…

  • Make sure that you are using TppVariable component for the detail totals and
    the group totals. Do not use global variables - that will not work. See the
    Tech Tips newsgroups for articles on performing Calculations.


    -…

  • If you re-organize the data so that there are three linked queries as I
    described before, then the subreport detail band will print a single Job or
    single Entry. You can use the DetailBand.BeforePrint event to set the
    visibility…

  • Observations:

    1. My first recommendation would be that you redesign your database so that
    is normalized. You should have a Clerks table, Jobs table, and Entry Table.

    If redesigning the database is not an option then …

  • 1. Have you read the conceptual information and completed the tutorials in
    the Developers Guide? Have you examined the demos in
    RBuilder\Demos\Reports\Demo.dpr and read the articles in the Tech Tips
    newsgroup?

    If the …

  • Welcome to ReportBuilder!

    In ReportBuilder, you use subreports. Subreports provide a powerful and
    elegant solution, much more so than detail bands. SubReports can be used to
    traversed detail datasets and to print alternate…

  • Okay, I reread the question and think I understand that you are asking for
    data in MS Access format that has populated tables of our end-user demos. We
    only have the empty version that is installed with RB, we do not have an MS

  • 1. Check RBuilder\Demos\EndUser Databases\Access for a version of the
    EndUser tables in MS Access format. You can import these into your existing
    Access database.

    2. If you cannot convert the blob data directly, then run t…

  • This is not a known issue with RB 7.04 or one that we can reproduce here.

    Are you using the latest release, RB 7.04? If not contact
    info@digital-metaphors.com with your full registration info and inquire
    about receiving do…

  • Check the Designer.DataSettings for DatabaseType and SQLType. Make sure that
    these settings reflect the database engine that you are using. Left outer
    join syntax varies by database product. However, it looks like from your
    exam…

  • Outer joins work for queries that are not linked.

    Another work around might be to create simple non-joined queries and then
    link them. In the link dialog you can specified to include master that do
    not have corresponding d…

  • This a limitation of the linking SQL, it always uses an inner join.

    One possible work around is to manually edit the sql and then write code to
    create the links between the datapipelines.

    www.digital-metaphors.com/ti…