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

nicocizik

About

Username
nicocizik
Joined
Visits
2,418
Last Active
Roles
Administrator
Company Name
Digital Metaphors Corporation

Comments

  • Hi Denise,

    I went ahead and created a small example for you that gets pretty close to
    what I think you are after. I essentially set up a simple Master-Detail
    report using the DBDEMOS database and am displaying the company name,…
  • Hi Denise,

    Are you printing a multiple column report (i.e. Report.Columns property is 2
    or more) or do you want an unique footer at the bottom of each "column" of
    data you have placed in your detail band? If you are defining mu…
  • Hi Denise,

    Unfortunately the Page Footer band is the only band that cannot be sized
    dynamically. This is because the report engine needs to know exactly where
    the end of a page is to make proper page breaks. As an alternative,…
  • Hi,

    There have been hundreds of issues addressed in ReportBuilder since RB 5.56.
    I would suggest downloading a trial version of ReportBuilder 7.04 for Delphi
    5 and testing your application with that. If it does not fix the issu…
  • Hello,

    The report templates are not forward compatable. Though it may be possible
    to load and run new report templates on an old version of ReportBuilder, it
    is definitely not a good idea as there have been many changes made an…
  • Hi,

    If you remove the subreport and set a background color to the region, do you
    still see the space? Be sure there is no extra space in the subreport that
    could be showing up. As a test, try placing colored rectangles in each…
  • Hi Sydney,

    ReportBuilder cannot read HTML documents, however, you may be able to find a
    utility that will convert your HTML documents to RichText. Then you could
    load the RichText file into a TppRichText components for viewing …
  • Hi Laercio,

    At first glance, your code looks good to me, especially if it is giving you
    the correct output :)
    in TdaSql Comment by nicocizik August 2004
  • Hi Laercio,

    The TdaSQL object was not really meant to be used separate from
    ReportBuilder, mainly because it is not properly documented. Below is a
    link to an example that creates a stand alone Query Designer that outputs
    in TdaSql Comment by nicocizik August 2004
  • Hi Laercio,

    I am unclear about what you would like to use the daSQL object for. If you
    are try to create custom SQL statements inside a report, you can extract the
    SQLText object and alter it as you need. See the following ex…
    in TdaSql Comment by nicocizik August 2004
  • Hi Yang,

    There is now a patch available for ReportBuilder 7.04 that addresses this
    issue. Please send an email requesting this patch to
    support@digital-metaphors.com and we'll send it to you asap.

    --
  • Hi Yang,

    Thanks for the example. I was able to recreate the error and am currently
    looking into the cause of the problem. I'll let you know when I find
    something. Thanks for your patience.

    --
  • Hi Craig,

    We suggest using a WMF because a WMF file consists of drawing instructions
    for vector graphics on your screen, meaning that when you resize or print
    the image, you will not loose any accuracy or the image will not appe…
  • Hi Pavel,

    Check out the following example on how to use a progress bar with
    ReportBuilder.

    http://www.digital-metaphors.com/tips/ProgressBar.zi…
  • Hi,

    If you are using groups or section style subreports to separate these
    ivnoices, be sure the ResetPageNo property is not set to True. This is a
    published property and can be set in the Delphi Object Inspector.

    -- …
  • Hi Alex,

    It is possible to replace all the dialogs in ReportBuilder with the
    exception of the designer. There is an example of customizing the Report
    Explorer in the \RBuilder\Tutorials\Complete\II. Applications\04. End-User
  • Hi Steffen,

    ReportBuilder stores parameters as Variants and then maps them to datatypes
    based on the type of Variant it is. Unfortunately there is not a Variant
    type conversion for every data type we have available in ReportBui…
  • Hi Martin,

    If you are using static height detail bands you could change the
    DetailBand.BandsPerRecord property to 2 once you've reached the last detail
    band that will fit on a page. Since you know the size of the page and the
  • Hi Martha,

    Would it be possible for you to join the two Return tables with the detail
    Master table, and order that result set on the PayorID? If so, you would be
    all set when you link the Master Payor Table to that dataset or d…
  • Hi Martha,

    Let me know if I'm wrong here but I'm assuming that the payor and ID fields
    are synonymous in the master and detail tables. You might try ordering on
    ID, State in your detail dataset. Something like the following?
  • Hi Martha,

    Are you sure that your detail dataset is sorted on the grouping field? It
    looks like the group is breaking on every field which means that for each
    traversal ReportBuilder makes on your dataset, there is a new value …
  • Hi Martha,

    You might try creating a group around each stateX in you subreport and then
    using the GroupFooter to sum up the fields. This would require you to order
    your dataset based on "state".

    --
  • Hi Chris,

    Check out the following example I created for another customer who wanted a
    horizontal column header and footer. You may be able to use this as a
    starting point for your report.

    in columned report Comment by nicocizik August 2004
  • Hi Chris,

    You might try setting your TppDetailBand.ColumnTraversal property to
    ctLeftToRight so the data will traverse across the columns instead of down
    them. Then you could possibly add column headers in the page header band.…
  • Hi Dmitry,

    To add a report component to a region, you simply need to assign its Region
    property to the propert region component. For example...

    lLabel := TppLabel.Create(Self);
    lLabel.Band := ppReport1.DetailBand…
  • Hi Marc,

    When you set the AllowSaveToFile property to True, the Save To File menu
    option is automatically made visible and enabled. You can see this in the
    TppDesignerWindow.mniFileClick procedure located in the ppDsgner.pas fi…
  • Hi Marc,

    Sorry, I somehow lost track of your post.

    Yes, when you have the SaveAsTemplate property set to True, ReportBuilder
    will try to load the report template you have defined in the
    Template.FileName or Template.D…
  • Hi Marc,

    Are you trying to save your report as a Template (.rtm) file or a text file?
    If you are trying to save as a template, there is no need to set the
    TextFileType property. Are you able to save a template down by selecting…
  • Hi Michael,

    The OnRecordPositionChange fires before the JITPipeline gets the field
    value, so if you call Table.Next in that event, you will essentially be
    starting on your second record. If you are always incrementing your reco…
  • Hi Al,

    When you save your report while designing a subreport, you should have two
    extra options in your File menu... Save Subreport and Load Subreport.
    Clicking Save Subreport should only save the subreport down as the template<…