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

nicocizik

About

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

Comments

  • Hi Daniel,

    Sorry, I thought you were placing the db-aware components inside the summary
    band of the section subreport.

    If you are going to use two Section subreports as you describe below, be
    sure you only have the …
  • Hi Daniel,

    In order for a report to successfully traverse your data, you will need to
    place all DB-aware components inside the detail band. The summary band will
    not traverse your data. This is why you are only seeing the fi…
  • Hi Marcel,

    If this is a fixed subreport, it will print in the exact spot you place it
    on your report. It is up to you to measure the height of the subreport
    compared to the amount of vertical space remaining in the report. W…
  • Hi Bettina,

    Is you summary band set to have a phDynamic PrintHeight? If so, then it
    will only take the amount of space that is needed and there should be no
    overflow to the next page if there is enough room for all the summar…
  • Hi Jos?,

    Take a look at the followng article on creating groups in code. In your
    case you don't need to set a DataPipeline and you only need to group on a
    custom field.

    Then you will need to add something like the …
  • Hi Jos?,

    Here is a quick example of what I was talking about in my previous post.

    http://www.digital-metaphors.com/tips/ChildSubreportW…
  • Hi Jose,

    Since Child subreports do not support page headers and page footers, you
    can use the GroupHeader/GroupFooter bands instead. If you need to repeat the
    header
    when a page breaks then then you can create a group and…
  • Hi Eddy,

    Since you are setting the visibility of the detail band as the report is
    generating, there is no way to go back once you are finished and remove a
    section of the report that has already been generated. In this case y…
  • Hi Anatoliy,

    Do you want to change the order in which the subreports print or the order
    they show up in the designer as tabs? The order in which the subreports
    will print is determined by the ShiftRelativeTo property. Alteri…
  • Hi Chris,

    RB 7.x did not include the TppPageBreak component. I would first recommend
    considering upgrading to the latest version of ReportBuilder (10.05) for
    Delphi 7. If this is not an option, take a look at an older articl…
  • Hi Chris,

    Section reports are not to be used in a master detail report like the one
    you have below. They are designed to be used as a way to merge multiple
    complete reports into a single report. By definition a section subre…
  • Hi Jon,

    Are you using RAP? If so you will need to use one of the subreport events
    to access the detail band of that subreport. Try the OnPrint event. If you
    are coding in Delphi, you can use the TppChildReport.DetailBand pr…
  • Hi Patrick,

    Thanks for the feedback. It is possible to see the current z-order of the
    items on the report using the Report Tree. The Report Tree can be viewed by
    selecting View | ToolBars | Report Tree from the main menu in …
  • Hi Gary,

    In order to get the output that you want, you will need to only link on the
    ID_2 field. Linking on the ID_1 field will always return all the detail
    records since they are the same value. Take a look at the Master-De…
  • Hi Bill,

    If possible, please send a small example in .zip format to
    support@digital-metaphors.com that demonstrates the issue and I'll take a
    look at it for you.

    --
    Regards,

    Nico Cizik
    Digital …
  • Hi Bill,

    Is your data set up so that the Master is linked to the Detail 1 which is
    linked to the Detail 2 dataset? If not, this may be the problem. If you
    have nested subreports as you describe you will need to set up your l…
  • Hi Laura,

    Take a look at the TppReport.OnOutlineNodeCreate event. This event allows
    you to customize each node of the outline as it is generated give you much
    more control than the Outline Dialog in the designer. For instanc…
  • Hi Laura,

    Are there any groups in your report or loaded template(s)? If so, be sure
    that the ResetPageNo property of the groups is set to False. If not, try
    deleting the subreport in question and re-adding it. If this still…
  • Hi Laura,

    Be sure the subreport's ResetPageNo property is set to False. By default
    this property is set to True and will cause a section subreport to start on
    page one.

    --
    Regards,

    Nico Cizik
  • Hi Rick,

    What component are you using for the Grand Total? If you are using a DBCalc
    component, try replacing it with a TppVariable instead and add up the value
    manually in code. You could stay with the direction you are goi…
  • Hi Jack,

    If you would like the master data to print if there are no detail records,
    you need to be sure the SkipWhenNoRecords property of the detail pipeline is
    set to False.

    --
    Regards,

    Nico Cizik<…
  • Hi José,

    Sorry for the delay in this response.

    By definition, the page footer (TppFooterBand) will print on the bottom of
    every page in the report. My suggestion was to try using this band instead
    of the group foot…
  • Hi José,

    The Group Footer band is designed to only print at the end of a group. As a
    workaround you could try using the page footer band and dynamically change
    it depending on which group you are currently printing.

  • Hi Jacques,

    When a subreport is in drilldown mode, the components contained inside the
    subreport are not automatically created until it has been drilled down.
    Since you are using ReportBuilder components to make calculations, …
  • The server edition of ReportBuilder includes an XHTML device which can be
    used to export reports to HTML.

    ReportBuilder Standard, Professional, and Enterprise include a Text, Report
    Emulation Text, Archive, and PDF device. Yo…
  • I'm sorry but I am unable to create examples with older versions of
    ReportBuilder. The example consists of a master/detail report with the
    Customers and Orders tables in the DBDEMOS database (linked on CustNo).

    I created a gr…
  • Hi Anji,

    If you would like to show the percentages for each individual school ID, you
    will need to place the chart inside the subreport's title or summary band
    and connect to the detail pipeline using "color" as the label and …
  • Hi Gary,

    Below is a quick example of what I am talking about. This should get you on
    the right track.

    http://www.digital-me…
  • Hi Gary,

    I'm a bit unclear about what is happening. At what point are the subreport
    created with the code below printing? You can try setting the
    ShiftRelativeTo property to the previous subreport in order to determine
  • Hi Gary,

    At what point do you know how many subreports (pages) you are going to need
    to tack on the end of the report? If this is based on some data in a
    dataset, you could possibly dynamically create each subreport for each …