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

nicocizik

About

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

Comments

  • Hi Claudia,

    For ReportBuilder to traverse a dataset, it needs to be connected to a
    datapipeline (or datamodule in DADE). If you wish to connect to multiple
    datasets, you will either need to link your datapipelines/datamodules o…
  • Hi Claudia,

    I am a bit unclear about what you are trying to accomplish. The reason you
    are only seeing one line from your dataset in the subreport is that you have
    it positioned in the footer band. This band is static and cann…
  • Hi Jarrod,

    After consulting another engineer about this, there is unfortunately no way
    to accomplish this using RAP. RAP does not contain a proper event handler
    to update a dataset as you need.

    As an alternative, you…
  • Hi Jarrod,


    Are you using DADE to create your datasets? I am unclear what you mean by
    the "fields that are calculated by the OnCalc event of the dataset". Where
    is the OnCalc event of the dataset?

    Would this be…
  • Hi Joao,

    The wwRiched.pas is a file used only for InfoPower... It is not needed to
    work with WPTools. When you purchase WPTools, I believe they provide their
    own delphi package to enable you to integrate it with ReportBuilder, …
  • ----------------------------------------------
    Article: ReportBuilder's RichText architecture
    ----------------------------------------------


    The RichText in ReportBuilder is a wrapper around Delphi's TRichEdit which
    i…
  • Hi John,

    Ok, I got it to show the error. This looks like a limitation to the merge
    menu capabilities of ReportBuilder. As an alternative, I would recommend
    creating a custom Report Explorer form and registering it with
    Re…
  • Hi John,

    Which version of ReportBuilder are you using. I did the exact steps you
    described below and was still unable to recreate the problem. After adding
    a menu item below the newly added Tools item, I was still able to see…
  • Hi John,

    Are you able to recreate this issue using one of our end-user demos? In my
    testing, I was unable to get the merge menu to dissapear. If you can
    recreate this behavior with our demos, please provide the exact steps you…
  • Hi Jarrod,

    Unfortunately this is the way the Report Explorer and Designer was designed
    to work. If you would like try to change this, you will need to look at the
    Report Explorer source. Try looking at the TppReportExplorer.Op…
  • Hi Jarrod,

    Are you able to recreate this issue using our end-user demos? Just to be
    sure I'm doing everything correctly. I loaded the \RBuilder\Demos\3.
    EndUser\1. Report Explorer\EndUser.dpr project and ran it. Then I select…
  • Hi Greg,

    Try connecting your report to a JITPipeline set with a record count of 100.
    If this does not give the the formatting you need, you may need to load your
    existing report into a subreport positioned in the detail band of …
  • Hi Moisey,

    When you create the rb_item table in Oracle, be sure you set the Template
    field's datatype as BLOB rather than LONG. There is a known bug with the
    BDE when you try to use the LONG datatype and Oracle.

    -- <…
  • Hi Paul,

    You can toggle the visibility of the Calc tab and calculations dialog using
    the Designer.RapInterface properties. Set riDialog and riNotebookTab to
    false and you should get the effect you need.

    --
  • Please to not cross post. This question was answered in a more recent post.

    --
  • Hi Joe,

    If you are getting an 'IEdiSeri' or 'IEdiCha' error message when you try to
    compile a project that contains TeeChart functionality, then TeeChart is
    probably installed correctly. In order to get around these error messag…
  • Hi Moisey,

    A TppVariable's OnCalc event does not use the same timing structure as the
    rest of the report. The reason a TppLable was working is probably due to
    the fact that you were using the TppLabel.OnGetText event. You coul…
  • Hi Rick,

    The easiest way to do this would be to create new datamodules in DADE at run
    time based on the queries that your users build. Then once the dataviews
    are created in DADE, you're users will have full access to the data …
  • Hi Moisey,

    Please send an example demonstrating this issue to
    support@digital-metaphors.com and I'll take a look at it.

    --
  • Hi Moisey,

    Try setting the Report.CachePages to true and see if that helps. This will
    use more memory caching your report pages, but if you reports are mainly
    text and shapes, it should not affect performance.

    --
  • Hi Al,

    Yes, this is a SQL standard. Although some databases support extra
    features, to ensure the best compatablility over multiple database systems,
    ReportBuilder generally stays within the SQL standards.

    --
  • Hi Al,

    Unfortunately, grouping by a calculated field in ReportBuilder is not
    supported. This is due to the fact that grouping by the value of a
    calcuated expression is not supported by SQL itself.

    --
  • Hi Ken,

    Depending on which database server you are using, you may be able to use the
    ADD_MONTHS() built in method. I know for sure this method is available in
    SQL Server and Oracle. You may need to check your current database'…
  • Hi Jarrod,

    I happened to create a demo of this earlier this week. This is a custom
    query wizard that has horizontal scroll bars for the list boxes. Hope this
    helps. Simply unzip the file, add it to your project and rebuild.
  • Hi Jerome,

    Which version of ReportBuilder/Delphi are you using? In my testing with
    ReportBuilder 7.03 and Delphi 7, applying c.cccccccccc;0 to the
    DisplayFormat of a DBText gave me the exact results you were after.

    -…
  • Hi Moisey,

    Try creating a flag and setting it in either the OnPrint or OnStartPage of
    your subreports. Then using this flag value, you will be able to know if a
    subreport is present on the current page, and toggle the visibilit…
  • Hi Moisey,

    The Header and Footer bands act as PageHeader and PageFooter bands so they
    will reprint on every page unless they are suppressed. I would suggest
    using the Report.OnStartPage to toggle the visibility of these bands i…
  • Hi Moisey,

    A Section style Subreport by definition will start a new page when it is
    generated on a report. Try using a Child Subreport with its KeepTogether
    property set to True.

    --
  • Hi Brian,

    Check out the Advantage End-User database demo located in the
    \RBuilder\Demos\4. EndUser Databases\Advantage\1. Native\... directory.
    --
  • Hi Paul,

    In the built-in ReportBuilder autosearch dialog, there is a cancel button
    that works the way you want. In the ppASDlg.pas file, this is simply a
    TButton with its ModalResult equal to mrCancel. Printing is then suppres…