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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,384
Last Active
Roles
Administrator

Comments


  • 1. The report engine will open all of the datasets associated with the main
    report, data-aware controls and childreports. If you have subreports that
    you want to conditionally suppress prior to generating the report, then you
    co…

  • A couple of options to try:

    1. Set the subreport.Band to nil to remove it from the report.

    2. Set subreport.DataPipeline to nil to disconnect it from the datapipeline.
    If the data-aware component in the subreport suc…

  • No. That is up to you to determine. There are many factors that can affect
    performance. The complexity of the report layout is affected by number of
    subreports and also by factors such as the number of KeepTogether objects,
    Stre…

  • You can optionally create the group in the childreport rather than the main
    report - that would make it an easy DBCalc.

    The older architecture caused mass confusion for most customers. The current
    architecture does not - y…

  • One option might be to use a group that breaks for each detail line and is
    configured to reprint its header on subsequent pages. That would require
    that you place the memo in the group header band, so it might not suit your
    nee…

  • To control whether the master record prints when there are no detail
    available, you need to set the detail DataPipeline.SkipWhenNoRecords
    property to False.

    When using Dade, you can do this via the Link dialog. Access the …

  • The footer band is the one band that cannot stretch vertically (i.e. you
    cannot set PrintBehavior to phDynamic.) The footer band must be a fixed size
    height. If you need to print a fixed area at the bottom of each page, you
    coul…

  • Try using the ChildReport OnStartFirstPass event, this event will fire each
    time the childreport generates. (There is also an OnStartPage event, but
    this fires each time the subreport generates a page).

    At Delphi design-ti…

  • The following example implements a table of contents. A subreport containing
    a memo is used to display the table of contents on the first page. The
    Report.PassSetting is set to psTwoPass. During the first pass, the memo is
    loade…

  • Try myReport.AbsolutePageNo.

    If that does not help, provide more details on what you are trying to
    accomplish.


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


  • If you change only the implementation section that you need only change the
    package that contains ppCTMain. The package name is rbCT7x where x is the
    version of Delphi that you are using.


    --
    Nard Moseley
    D…

  • Try placing another subreport, lets call it SubRpt0, above SubRpt1. Use this
    subreport to generate a page break. Set the TitleBand.NewPage property to
    true and size the height of each band to 0.

    Set SubRpt1 to shift relati…

  • The following article contains detailed information about loading reports
    stored to the report explorer database tables...

    ---------------------------------------------------------------
    Tech Tip: How to Programmatically L…

  • Try using the Band.BeforePrint event of the band that contains the
    subreports and regions. You can set visibility and redefine the
    shiftrelativeto relationships here.

    --
    Nard Moseley
    Digital Metaphors Corporatio…

  • Please modify your newsreader to post your real registerd user name and sign
    your messages with your real registered name.

    1. Make sure that you are using the latest release - RB 7.04.

    2. If you set any objects in a …

  • Can you create a similar report using ReportBuilder and DBDemos. Email in
    zip format to support@digital-metaphors.com and we can take a look at here.


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digit…

  • The following article may contain some helpful information.

    Also note that starting with RB 5.5, the DetailBand.DataPipeline was
    deprecated.


    --------------------------------------------------------------------<…

  • In its current implementation the DataPipeline.OnOpen event fires each time
    DataPipeline.Open method is called. The event is fired regardless of whether
    the datapipeline is already active. It does not check whether the
    datapipel…

  • As an alternative to the Regions, you might try using SubReports. If a
    subreport is not connected to a datapipeline, it will print a single detail
    band and stop. You can still connect the data-aware objects in the subreport
    to a…

  • My first guess is that perhaps the data is not linked correctly. Try
    building the report incrementally. First create a simple report that
    traverses the master datapipeline. Next add a subreport that traverse the
    detail datapipel…

  • Here is an example of dynamically creating and linking DADE dataviews. See
    the DADE thread of the Tech Tips newsgroup for articles on the DADE
    architecture.

    www.digital-metaphors.com\tips\CreateDataModCustOrderLinkedDataVi…

  • The ReportBuilder Data workspace can be used to visually link queries. You
    can select a field in the detail dataview and then drag to the field in the
    master dataview. For examples, run the
    RBuilder\Demos\EndUser\ReportExplorer.…

  • There is not enough information here for me to diagnosed the problem.

    1. Make sure that the data is linked correctly. (see article below).

    2. Run RBuilder\Demos\EndUser\ReportExplorer and RBuilder\Demos\Reports and
    c…

  • When using the datapipeline linking the detail dataset must be sorted on the
    linking field(s)


    ------------------------------------------------------
    Tech Tip: Linking SQL Queries for Master/Detail Data
    ---------…

  • Perhaps the copy/paste is producing the problem.

    Try creating a second region and subreport without copy/paste.

    Also, make sure Region2.ShiftRelativeTo is set to Region1

    If you would like to submit an demo, ple…

  • 1. Make sure that you are not linking on Guid fields - this is a feature
    that is not supported in RB 7.04, it is being added to the next release.

    2. For each detail datapipeline, try setting SkipWhenNoRecords to False.

  • The report layout includes all subreports within it. When a report is saved,
    all of the subreports within it are saved to the same .rtm.

    There is an option to load/save an .rtm to a subreport - to do this access
    the worksp…


  • From what you describe, I think you need a separate summary query that
    calculates the YTD totals.

    1. create a summary query

    Select Count(*) as YTDCount
    from orders
    where orders.OrderDate >= StartOf…

  • 1. Check the linking relationships. There are two types of linking supported
    by ReportBuilder. Delphi TDataset linking and DataPipeline. These are
    mutually exclusive - you need to use one or the other. See article below.

    2…

  • There is nothing built into the report engine that will help you with this.

    The best approach I can think of would be to write custom code that can
    calculate the amount of space required for each subreport. If the subreport