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

    I have not seen this behavior before. ReportBuilder simply retrieves data
    directly from the dataset it is given. What type of subreport are you
    using? If it is a fixed subreport, there may be a patch available th…
  • Hi Bob,

    The example simple gives you control over an event that fires when you click
    on the drilldown component. From that point it is up to you to add search
    criteria and regenerate the report if needed. I would suggest ini…
  • Hi Bob,

    Once you define a drill down component, the OnDrawCommandClick event is
    ignored. This would be the event you would want to use to add the search
    criteria. One workaround is to manually take control of the drill down …
  • Hi Bob,

    The ExpandDrillDowns routine is not natively available in RAP.

    --------------------------------------------------
    Article: Extending RAP
    ---------------------------------------------------

    There ar…
  • Hi Dietmar,

    In order to load a template into a subreport at design time, you need to use
    the Load Subreport option from the file menu instead of the Open option when
    in the subreport design view.

    --
    Regards,
  • Hi Dietmar,

    The easiest way would be to save your reports as template files, then load
    them either at runtime or at design time into subreports placed in your new
    main report.

    --
    Regards,

    Nico Cizik…
  • Hi Valdimar,

    A Report in ReportBuilder is only capable of traversing one dataset. If you
    would like to traverse your second table for the value of your 7th
    component, you will need to use a subreport connected to that dataset…
  • Hi Sylvie,

    Make sure the Report.CachePages property is set to False. This would affect
    the drilldown feature.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
  • Hi Sylvie,

    Does demo 152 function correctly? If so, be sure your subreport is
    connected to a valid datapipeline. You might try taking the removing the
    drilldown component at first and see what the report will look like fully…
  • Hi Richard,

    To see the Query Wizard you will need to select the File | New option from
    the Data tab in the designer. From your discription below you are selecting
    File | New from the Design tab of the designer.

    Fro…
  • Hi Richard,

    The Query Wizard is available in DADE (data tab in the designer) for use in
    the creation of built-in queries within your report. From the data tab, you
    can select File | New from the main menu and are then given t…
  • Hi Richard,

    Sorry for the delay.

    1. Try connecting a DBGrid to your dataset and be sure that once the SQL
    has changed, you are getting more than one record returned.

    2. Are you saving or loading templates? I…
  • Hi Richard,

    The query wizard is for use with DADE.
    (http://www.digital-metaphors.com/products/visual_data_access/) DADE
    can be ac…
  • Hi J.D.,

    The GetSubReports routine gives you a handle to each TppChildReport object
    (a TppCustomReport descendent and essentially the subreport design). Each
    TppChildReport is tied to a TppSubreport object which is the actual…
  • Hi JD,

    Once the template has loaded, you could use a report object loop to gain
    access to the subreport object, then either set its visibility to False and
    DataPipeline to nil, or completely remove it from the report by freein…
  • Hi Richard,

    ReportBuilder 10 includes native PDF export support so if you were using
    ExportDevices to export to PDF, you could possibly try using the built-in
    solution. Take a look at the TppPDFDevice topic in the RBuilder h…
  • Hi David,

    As a quick test, try setting the Report.CachePages property to true and see
    if that helps. Which version of ReportBuilder/TeeChart/Delphi are you
    using?

    --
    Regards,

    Nico Cizik
    Digita…
  • Hi David,

    This is not a known issue. Are you able to recreat this behavior with a
    simple example, perhaps using the DBDEMOS database? If so, please send the
    example in .zip format to support@digital-metaphors.com and I'll ta…
  • Hi Sergey,

    In my testing with the example I posted in my previous post, the calculation
    was correct for the grand total. How is your application different? If you
    would like to send a simple example, please send it in .zip f…
  • Hi Stuart,

    Are you using RAP? If so, you will need to create a global variable in the
    main report and set it equal to a TppVariable in the main report's design.
    Then in the OnCalc of the variable11 in the subreport, you would…
  • Hi Stuart,

    Take a look at the example I posted in your previous post. This report
    template contains code in the Calc tab (RAP) that does precisely what you
    describe below.

    --
    Regards,

    Nico Cizik
  • Hi Jeroen,


    When are you calculating the product + sub product? This sounds like a
    timing issue in that you are making this calculation too early and the total
    weight is being calculated before the sub product is. My fi…
  • Excellent! Just making sure :).

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in Second JITPipeline doesn't fire? Comment by nicocizik October 2006
  • Hi Madt,


    I'm a bit unclear about the problem now. Are you still unable to get the
    GetFieldValue event to fire? Is there another problem I can help with?

    --
    Regards,

    Nico Cizik
    Digital Metapho…
  • Hi Madt,

    Using RB 10.04 and Delphi 7.

    As a test, I created a simple report with two child subreports in the detail
    band. I connected each subreport to a separate JITPipeline on my form each
    of which were set to con…
  • Hi,

    Be sure the second pipeline is properly connected to the second subreport.
    From the design of the subreport, select the Report | Data option in the
    main menu and select the second pipeline. Next, be sure there are fields …
  • Hi Thomas,

    For the Variable in the header, try setting the LookAhead property to True.

    Take a look at the timing dialog of the variables. They are most likely set
    to reset when the page ends. If you would like to keep a…
  • Hi Corrado,

    If you simply remove the master-detail link from the datasets, your report
    will look like the following due to the fact that the subreport will print
    for each detail band.

    report A row 1
    report B …
  • Hi Scott,


    Correct. This is a many to one relationship and therefore would give you
    multiple master records for each detail. Typically when creating a Master -
    Detail relationship, you want a one to many relationship. …
  • Hi Scott,

    It is possible to create a report that has autosearch criteria for multiple
    datapipelines. From your description below, it looks like you need to
    create a master-detail report with Parts as the master dataset and Or…