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

digitalmetaphors

About

Username
digitalmetaphors
Joined
Visits
51
Last Active
Roles
Administrator

Comments

  • Create a variable component in the main report and set the data type.

    In the AfterGenerate event of the band containing the DBCalc, transfer the
    value of the DBCalc to the variable:

    ppVariable1.Value := ppDBCalc1.Value;
  • ReportBuilder will not automatically change the positions of report layout
    elements for you. But you can move these around programmatically before
    changing the margins...

    --
    Cheers,

    Tom Ollar
    Digital Metapho…
  • If you are using the OnDrawCommandCreate, you should not reference the
    TppDBText object, but rather the object which is passed is a TppDrawText
    object. Update the draw command in the Report.OnEndPage event. If you
    update the TppDBTex…
  • Try hooking a DBGrid to the detail pipeline to make sure you are actually
    retrieving more than one row of data for the master records.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • Please make sure that the subreport is assigned to the detail pipeline. Most
    likely the subreport is not traversing all of the detail data if this is the
    case.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors<…
  • Tom was just saying that Joe Celko is known for creating queries which you
    might think were impossible to build: http://www.celko.com/


    Cheers,

    Jim Bennett
    Digit…
  • Unless you just love Joe Celko, I'd probably create a detail query or two
    for this. Pull the needed data, link using the DataSource property of the
    detail TQueries. Use subreports to traverse this additional data.
    Subreports support j…
  • Take the same approach with the subreports that Tom mentioned for the main
    report. Make sure that AutoCreateFields is set to true on the
    datapipelines.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • The DataPipeline for each of the data-aware components in the report layout
    is not being updated when you change the pipeline. That or no fields are
    being created.

    First, check each data aware component and make sure that Parent…
  • You may need to use a technique of extending the shape one pixel down into
    the the next band. To do this, select the shape in the header band, hold
    down the Ctrl key and click the down arrow button. This should increase the
    height th…
  • In the OnPrintDialogClose event, check the ModalResult of the PrintDialog:

    if (ppReport1.PrintDialog.ModalResult = mrOK) then

    --
    Cheers,

    Tom Ollar
    Digital Metaphors Corporation
  • You can use the crosstab to fake it into a grid by adding rows and
    formatting the cells. See the demo below for an example.

    http://www.digital…
  • Place the memo in one region (with KeepTogether set to True) and the
    quantity and price labels in another. Set the first region to Stretch and
    set the second one to StretchWithParent. This will cause the second region
    to size itself w…
  • You can use the JIT pipeline to get HTML data into the report. You would
    have to parse the HTML yourself and use GetFieldValue and similar events on
    the pipeline to traverse the parsed HTML tree.

    --
    Cheers,

    Alexa…
  • If the end user makes changes to their RTM and you make changes to your RTM
    then you have two different RTMs. If you want both changes to coexist you
    must find a way to consolidate them.

    --
    Cheers,

    Alexander Kram…
  • If you make a change to the report you must send the new RTM file to the
    user as the old one is not valid since it contains the old report. If you
    are giving your users the RTM you shouldn't have to send them a new
    application. Simply…
  • There are no merge capabilities on a template.

    If you want to add an event handler to a report tempalte, you can do this
    programatically by editing the template that the user has to include the new
    event handler. You an also na…
  • Since you have a master detail configuration, tell the detail datapipeline's
    SkipWhenNoRecords property to be False.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • You can place a group in the subreport and set its break value to the key
    linking field. Move the information you want to print from the master
    detail band to the group header band. In the detail dataset, you should be
    able to acces…
  • Do you mean add a custom RB component? This is easy. See the installed
    RBuilder\Demos\RCL directory for an example of creating a custom component.
    Look at the initialization/finalization section of the myChkBox.pas file.


  • There is a known issue with groups and their event handlers getting out of
    sync if you use RAP. If you think that might be your problem, please email
    support@digital-metaphors.com to request a patch. Otherwise please read, if
    you have…
  • You can place two subreports side by side. The subreport on the left would
    traverse the detail data and the subreport on the left would traverse the
    extra data. Is the extra data static or does it come from a pipeline? If the
    extra da…
  • Email support@digital-metaphors.com for a patch that should address this
    issue.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • There is a CreateGroupInCode article in TechTips | CodeBased if that is what
    you had in mind. If you can't see it you might need to resync by completely
    deleting the dm account and re-subscribing.

    --
    Cheers,

    Alex…
  • In that case it is also possible that the memo is actually stretching but it
    is covered up by another component. If you have another component directly
    following the memo, set it to shift relative to the stretching memo.

    --
  • There are two things to check initially. First make sure that the OnPrint
    event handler is a assigned (that it is firing at all.) If so, also make
    sure that the first part of the if statement (df_xx.Stretch := True) is
    being hit by pl…
  • 1. The problem might be with the WMFs itself. How are they being generated?
    I've encountered a user who was having problems with WMFs generated by
    Illustrator and had to switch to another utility whose output produced valid
    results.
  • There is a patch to address this issue. Please email
    support@digital-metaphors.com to request it.

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • You can create a descendant of the LabelWizard and register it as a new
    wizard (see the registration calls at the bottom of the ppLabWiz unit). You
    can then override the execute method to take a current report and modify it
    rather tha…
  • You can manually launch the label wizard (TppLabelTemplateWizard). Please
    see the TppDesignerWindow.NewReportFromWiz method in the ppDsgner unit for
    details on how to create, set up, and launch the wizard.

    --
    Cheers,
    <…