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

    Yes, many of the events in ReportBuilder (with the exception of the OnCalc
    event of the TppVariable) will fire more than once during report generation.
    This is why it is never a good idea to make numerical calculations …
  • Hi Axel,

    There were no major changes in pagination from RB 6 to RB 7. If possible
    please create a small example demonstrating the issue and send it to
    support@digital-metaphors.com in .zip format and I'll take a look at it for<…
  • Hi Axel,

    Try using the AbsolutePageCount to get the page count for the whole report
    instead of just the PageCount property.

    --
  • Hello,

    I'm unclear what the issue is. If there is no data in your dataset, you can
    use the NoDataBehaviors property of the report to instruct it what to do
    under this circumstance. Also there is a SkipWhenNoRecords property
  • Hi Daniel,

    Be sure you are not linking your datasets as well as linking the pipelines.
    In my testing with the exact table below and your exact queries, the third
    pipeline showed its data perfectly. If possible, please send a sm…
  • Hi Nelson,

    Try setting the subreports to be Section Style subreports. This way, they
    will each generate and print as if they were each an individual report.
    Then you should only have to create one dataview and connect each subr…
  • Hi Dan,

    The page header and page footer bands are not available in a Child style
    subreport. As an alternative, you will either need to create a group and
    use the group header and group footer or use the title and summary bands.…
  • Hi Dan,

    Section style subreports are designed to allow users to add numerous single
    report to one report for printing purposes. For this reason, the page
    header and page footer will not show up when printing one of these style<…
  • Hi Bruce,

    Try setting your SubReport.PrintBehavior := pbSection. This will by default
    start the subreport on a new page.

    --
  • Hi Dan,

    The reason you have three pages is because your second subreport is a
    Section style subreport. It will print its own page, then ReportBuilder
    will use another page to print your footer band.

    --
  • Hi Pat,

    When making calculations inside the report you will want to use the
    TppVariable component and its OnCalc event. This event has been specially
    designed to only fire once per traversal. Check out an example by clicking
  • Hi Dan,

    Be sure the Report.AutoStop property is set to True. I am unsure why you
    are receiving an error when trying to set the visibility of the subreport.
    At design time are you able to toggle the visibility and preview correc…
  • Hello,

    Yes, you can definitely add a subreport inside another subreport. Is there
    an issue with the way your report is printing? Are you not receiving the
    anticipated output when you place a subreport inside another?

  • Hi Bernd,

    If you would like to limit the columns to only print a certain amout of
    records, you can set the DetailBand.PrintCount property. For instance if
    you have a report with 2 columns and initially it looks like...
  • Hi Brian,

    By definition, if a subreport is set to KeepTogether, it will try to fit on
    one page.... if there is not enough room, it will move to the next page and
    try to fit on that one. I feel we could get to the bottom of this…
  • ------------------------------------------------------------------
    Tech Tip: Subreport header/footer bands do not print for
    Child type subreports.
    ------------------------------------------------------------------

  • Hi Shanil,

    We are unaware of any issues like this in ReportBuilder. Be sure all your
    datapipelines are uniquely named and are visible. Double check each
    subreport's datasource by clicking the Report | Data |.. menu option in t…
  • Please do not cross post. This question has been answered in the End-User
    newsgroup.

    --
  • Hi Manolo,

    Yes, it is possible to move a subreport in code. You will need to re-assign
    the Top and Left properties of the subreport before the report generates.
    If you would like to switch bands that it is in, you will need to …
  • Hi Don,

    Which type of calculation are you making with the DBCalc components? In my
    testing with the sum, I was able to obtain the correct calculations and then
    divide the two values successfully in the OnCalc event of a TppVari…
  • Hi Shanil,

    Please send a small example of this behavior to
    support@digital-metaphors.com in .zip format.

    --
  • Hi Shanil,

    We have never heard of this type of behavior in a report before. Where are
    these subreports located on your report? If you place a new section style
    subreport on your report with a shape or label inside it, will you…
  • Hi Heiko,

    You can use the "Send to Back" , "Bring to Front" features of the subreport
    components to change the order of how they print. To be sure the order is
    correct you can take a look at the Report Tree (select View | ToolB…
  • Hi,

    There is no need for them to shift as they will start a new page when they
    are printed.

    --
  • Hi Heiko,

    You might try using Section Style subreports instead of Child. Section
    subreport will always start a new page by default.

    --
  • Hi Martha,

    Sorry if I'm way off base on this one :). A SubReport will only traverse
    the data that it is connecte…
  • Hi Martha,

    The approach you describe below should work correctly. Be sure you are
    linking each detail table properly to the Statement field of the master
    table. Then using the same method I described in my earlier posts, you c…
  • Hi Martha,

    First be sure the SubReport's NoDataBehaviors (available in the Object
    Inspector) has ndBlankReport set to True. The rest of the options should be
    set to False.

    In my testing, I added the following code to…
  • Hi Martha,

    Inside the DetailBand.BeforePrint event you can manually check to see if a
    datapipeline contains no records, then set the visibility of certain
    components on your report accordingly. Something like the following...
  • Hi,

    Try setting the Subreport.ResetPageNo property to False. This should give
    you the effect you are after.

    --