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 Jon,

    Are you using RAP? If so, you will need to create a global variable and
    assign the reference to the variable in the subreport. Something very
    similar to the example below.

    in Sum from One Subreport in Another Comment by nicocizik September 2005
  • Hi Paul,

    Placing a Child subreport and a Section subreport in the same band tends to
    confuse the report engine. Try placing two Section style subreports inside
    your detail band, the first one containing the chart and child su…
  • Hi Paul,

    We have not seen this behavior before. How are you moving the Meter Stats
    subreport to the next page if there are more than 4 rows of data? Try
    setting your portrait subreport to ShiftRelativeTo your Meter Stats
  • Hi Peter,

    Try changing the z-order of the subreports using the BringToFront and
    SendToBack options available by right clicking the actual subreport objects.

    If you would like to view the current z-order, take a look at th…
  • This question is being handled in the DataPipelines newsgroup. Please do
    not crosspost.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digita…
  • Hi Joe,

    Try making these subreports Section Style subreports with the
    ParentPrinterSetup property set to False.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in sub-reports and printing orientation Comment by nicocizik October 2005
  • Hi Juan,

    You can try setting the Visibility of the footer band inside the BeforePrint
    of the subreport based on the value of the global variable.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
  • Hi Steve,

    The problem with your design is that once a subreport ends, ReportBuilder
    looses all stored page information. You might be able to store the number
    of the last page printed for Subreport1 then manually place the pag…
  • Hi Karen,

    When making calculations, you need to use the TppVariable.OnCalc event
    rather than the BeforePrint event to guarantee only firing once per
    traversal. See the article on making calculations below for more
    infor…
  • Hi,

    Be sure you have your main report's PassSetting property set to psTwoPass.
    Are you loading a template? If so, you will need to be sure the template
    was saved with this property set to psTwoPass or that you are setting it …
  • Hi Valerie,

    Yes, if section subreports give you the proper effect, they are the ones to
    use.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    ht…
  • Hi Valerie,

    Which version of ReportBuilder are you using? Is there any other event code
    present than could be altering the pagination properties of the report or
    subreport? Be sure you have your main report set to TwoPass. …
  • Hi Harry,

    Unfortunately ReportBuilder cannot do this for you automatically. You will
    need to manually adjust the z-order of the subreports (using SendToBack and
    BringToFront) in order to visually see the subreport in the orde…
  • Hi Harry,

    The z-order determines the order in which the subreports print, not show up
    on the report. If you place ShowMessage commands inside the
    TppSubreport.OnPrint events of each of your subreports, you will see this is
  • Hi Eric,

    If possible, please send a small example demonstrating the problem that I
    can run on my machine in .zip format to support@digital-metaphors.com and
    I'll take a look at it for you.

    --
    Regards,
  • Hi Eric,

    It all depends on what you would like your report to look like. The basic
    idea is that you need to remove all section subreports from the summary
    bands of other reports. I would recommend going back to having an emp…
  • Hi Eric,

    Section subreport are meant to be placed inside an empty detail band in
    order to combine multiple reports together as one. When they are placed
    outside the detail band (or if there are other objects inside the detail…
  • Hi Ben,

    Yes, the link is not working for me. If possible, please send the example
    in .zip format to support@digital-metaphors.com and I'll take a look at it
    for you.

    --
    Regards,

    Nico Cizik
    Dig…
  • Hi Chris,

    Unfortunately the OnNoData fires too late to change the visibility of that
    subreport. You will probably need to use the Band.BeforePrint event of the
    main report to check the connected dataset for no data, and toggl…
  • Hi Valerie,

    Does Subreport 2 need to be on its own page? If so, you might be able to
    simply switch it to a Section Style subreport and remove the PageBreak
    component completely. Then your report should look something like th…
  • Hi Brett,

    You need to declair the global variable in the Variables declairation
    section of the Module View in RAP. Then assign it to another variable in
    the GlobalCreate. Finally in the OnCalc of the variable in the subrepor…
  • Hi Chris,

    1. Try making your subreports Section style and see if that helps. This
    may however leave an empty page at the end of your report.

    2. Place a TppPageBreak object between each of the current subreports. The <…
  • Hi Chris,

    Unfortunately this was not a simple code change. A couple things you might
    try:

    1. Be sure the Transparent property of the image is set to False.

    2. Try setting the DirectDraw property to True (if …
  • Hi Chris,

    The black image issue was addressed for ReportBuilder 7.04. You will need
    to upgrade to this version or later to receive this enhancement.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
  • Hi Van,

    I have not seen this behavior before however I believe it may have something
    to do with the timing of setting the subreport's visible property. As a
    test, try toggling the visibility of the second subreport in an earl…
  • Hi Mike,

    Are you by chance loading a template before generating this report. If so,
    you will need to save the template down with the pass setting set to
    psTwoPass in order for the property to take effect. If this is not the …
  • Hi Mike,

    Try setting the TppGroup.ResetPageNo property to True. This will reset the
    page number for each group in your report.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in Invoice page no. Comment by nicocizik March 2006
  • Hi Patrick,

    Sorry, I'm a bit unclear about the issue you are having. Is the
    ReprintOnOverFlow feature simply not working in your case? Are you loading
    report templates by chance? When comparing page numbers, you may want to…
  • Hi Chris,

    My first suggestion would be to consider upgrading your version of
    ReportBuilder. Perhaps download a trial edition of RB 10.02 and see if you
    can get the effect you are after before upgrading.

    Take a look…
  • Hi Chris,

    A couple things to try.

    1. Which version of ReportBuilder are you using? If you have version 9.x
    or higher, you can try placing the TppPageBreak object inside your group
    header band to force a page break…