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

    Yes sorry, I was thinking about copying to separate reports.

    In this case you would either need to go through the template code and
    change the group names to something unique or create the subreports
    compl…
  • Hi Steve,


    What types of problems are you having with this method of copying
    subreports?? This would be the easiest way to duplicate the same subreport
    numerous times. If fact, you wouldn't event have to save the report…
  • Hi Steve,

    Are you using RAP? If so, I recommend moving the code (temporarily) to
    Delphi for debugging purposes. This way you can step through the event code
    and see exactly what is happening.

    If you would like, yo…
  • Hi Steve,


    If you trace into the code accessing the variable value, what is it showing?
    The trick is to find the proper time to access this value. Is the variable
    resetting at the right time as well?

    --
  • Hi Steve,

    The issue is most likely that the variable has not made it's calculation
    before the GroupHeader.BeforePrint event fires. To work around this, you
    can set the variable to LookAhead and then set the visibility of the …
  • Hi David,

    Something like the following should work for a two pass report inside the
    footer band BeforePrint event.


    if Report.SecondPass then
    Report.FooterBand.Visible := (Report.AbsolutePageNo =
    Report.…
  • Hi Shely,

    I'm unsure why this is happening however remember that ReportBuilder simply
    retrieves the data that it is given. If no data is showing up for a certain
    dataset, then none is available. You might want to re-check yo…
  • Hi Shely,

    Did you try connecting your datasets to a DBGrid to see if ReportBuilder is
    actually able to access the data? Are you able to recreate this behavior
    using a minimal application that I could run on my machine? If so…
  • Hi Shely,

    The fact that you are able to see the data when you preview and not when you
    print indicates that there is some different code running for the print
    option. Are you able to print directly without previewing first?
  • Hi Phil,

    Usually when the subreport displays the same data over and over, the master
    and detail datasets are not properly linked. Be sure that the detail
    dataset (dataset connected to the subreport) is actually linked to the …
  • Hi Mason,

    Ok, I have a better idea of what is happening. If you are using Child style
    subreports, you need to be sure the "Comments" subreport is set to
    ShiftRelativeTo the "Object" subreport. Otherwise they could overlap
  • Hi Mason,

    Where is the "comment" information coming from? The same dataset as the
    object properties? If so, you will not want to create a separate subreport
    just for the comment, the comment will need to go into the original…
  • Hi Veri,

    Unfortunately once you change the aValue parameter, this value is taken into
    account when the subtotal and grandtotal is calculated. If you would like
    to keep the total and subtotals unchanged, you will need to updat…
    in CrossTab Comment by nicocizik July 2010
  • Hi Veri,

    I'm a bit unclear about what you are trying to accomplish. The Value
    returned by the CalcDimensionValue event is not the row subtotal value. You
    will need to use the OnGetTotalValueText to get a total or subtotal va…
    in CrossTab Comment by nicocizik July 2010
  • Hi Michael,

    This is not a known issue with RB 11.08. ReportBuilder simply retrieves and
    displays the data it is given so if a certain record is not displaying, it
    is either being hidden by the design of your report or the rec…
  • Hi Tim,

    Yes, the FooterBand is not capable of stretching. It is the only
    permanently static band in ReportBuilder. If you need a page footer to be
    dynamic height, you will need to use a group footerband or the summary band.<…
  • Hi Tim,

    Subreports use the different print behaviors to determine whether they will
    stretch or not. My guess is that the subreport's PrintBehavior property is
    set to pbFixed essentially rendering it unable to stretch. Changi…
  • Hi Peter,

    You can use a report object loop to gain access to all components inside a
    report. From there you can check if they are data-aware and toggle their
    properties manually. See the following example on how this can be …
  • Hi Peter,

    The suggestion I gave was not a solution, simply a test to try to isolate
    where the problem is occurring. Instead of saving the report to a stream,
    then loading it to a subreport in code, try saving the report to fi…
  • Hi Peter,

    Which version of ReportBuilder and Delphi are you using? Are you using RAP
    for the event handlers or are you coding them in Delphi?

    If you save the report to a template file, then load it manually into a
  • Hi Eliseu,

    For future reference, please send all attachments to
    support@digital-metaphors.com rather than posting them here.

    The PageBreak component also contains a ShiftRelativeTo property and this
    will need to be …
  • Hi Nigel,

    Take a look at the following article on creating a preview plugin that
    allows the expanding or collapsing of all drill downs. This should get you
    on the right track to accomplishing what you need.

  • Hi Stephen,

    The child subreport is designed to be used inside a dynamic height band.
    Try using a fixed style subreport instead, sized to the height of the static
    detail band. The subreport itself will still grow dynamically, …
  • Hi Luc,

    The fact that you are making calculations outside the OnCalc event of a
    TppVariable will most likely lead to incorrect calculations when generating
    a report. The OnCalc event is designed to handle this type of report.…
  • Hi Luc,

    Which version of ReportBuilder are you using? Are you using TppVariables
    and the OnCalc event to make your calculations? The calculation of
    subtotals was an issue for some earlier versions of ReportBuilder with
  • Hi Greg,

    The header and footer bands will not print for Child Subreports. You
    can use the Title band or a group header band as a replacement.


    Regards,

    Nico Cizik
    Digital Metaphors
    in blank pages printing before section subreport Comment by nicocizik June 2011
  • Hi Greg,

    Section subreports are meant to be placed in the detail band of an empty
    report to combine multiple reports together as one. When you place a
    section subreport inside another band, it will first print that band,
  • Hi Peter,

    See my answer to this question in the General newsgroup.


    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com<…
  • Hi Gustavo,

    Try using the Subreport.OnPrint event to hide the footer band of the
    main report. Access the main report using the
    Subreport.Report.MainReport property.

  • Hi Michael,

    The main idea is to toggle the visibility of the content in the footer
    band before it is generated. You could use SubreportY or perhaps event
    an event of a component inside that subreport to do so.

    If y…