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

nicocizik

About

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

Comments

  • Hi Ennio,

    Instead of using two DBMemo objects, simply add the text of the two db
    fields to the TppMemo object manually in the DetailBand.BeforePrint event.
    Something like the following...

    ppMemo1.Lines.Text := ppRep…
  • Hi Martin,

    Since we do not provide the source code to RAP, you cannot change the
    Interface sections of any of the ReportBuilder source files and still use
    the RAP functionality. You will either need to disable RAP or find ano…
  • Hi Martin,

    I'm sorry, I do not have older versions of ReportBuilder available to test
    with and this is not a known issue with RB 9.03. You might try taking a
    look at the 9.03 source to see the order of opperations before the …
  • Which version of ReportBuilder are you using? In my testing with RB 10.06
    for Delphi 2007, the report is generated and displayed properly in the
    preview tab using the exact code I gave in my previous post.

    --
    Regards,
  • Hi Martin,

    In my testing with the following code in the OnShow event of the
    TppDesigner, the designer opened with the preview tab selected successfully.

    procedure TForm1.ppDesigner1Show(Sender: TObject);
    begin
  • Hi Sidney,

    1. Try placing a single group around the entire report. The group footer
    should only print at the end of the last column in the report.

    2. The lookahead feature for the DBCalc component is working as designed…
  • Hi,

    Please use your full name when posting to these newsgroups.

    1. You should be able to place a DBCalc inside the column footer in order
    to display the total count of details inside the actual column.

    2. Be …
  • Hi Rob,

    Where is your data defined? If you are using DADE, I would strongly
    recommend creating and altering your search criteria using the SQLBuilder
    object. This makes the process of creating and deleting criteria very
  • You will want to use the InsertOr statement to add an "OR" to your SQL
    statement.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metap…
  • Hi Ian,

    The SQLBuilder does not have any built-in feature to remove case sensitivity
    your database enforces. It is simply used to manually construct the
    underlying SQL of dataviews in DADE. You could possibly manually check …
  • Ian,

    There are numerous ways to filter your data from within the report.
    Similarly to what you have below, you can use the DetailBand.BeforePrint
    event to compare the current record value to something.

    Take a look a…
  • Hi Trevor,

    For some reason your original posts are displaying "Re:" in the subject
    line. Please check your news reader settings.

    This is not a known issue. Check to be sure your library path includes the
    \RBuilder…
  • Hi Trevor,

    I'm a bit unclear about how your report is designed.

    1. If there is a datapipeline on a form that you wish to connect to a
    report that is loading templates, you can connect that pipeline to the
    report us…
  • Hi Trevor,

    It looks as though you are already defining your data in the data workspace
    (DADE) so there is no need to create a Query, DataSource, Datapipeline group
    on your form. My recommendation would be to keep all you data…
  • Hi Trevor,

    Where are you loading the template file? Note also that the pipeline will
    need to be connected to the report after the template is loaded, perhaps
    using the Template.OnLoadEnd event. See the Using Template Events …
  • Hi Car,

    There is no built-in feature to count distinct records in ReportBuilder
    however this could be done fairly easily either in SQL code (with a
    different dataset) or RAP code.

    In RAP, you could possibly check th…
  • Depending on how much space each detail band requires, you can set the
    PrintHeight to phDynamic an each detail band will only use the amount of
    space that is required. It may also be possible to create a fixed subreport
    with a 4 i…
  • Hi Jean-Francois,

    1. If you have your detail band set to print with a static print height,
    you can size it to be 4 inches and every detail band that prints will
    automatically take up 4 inches of space. Are you trying to keep…
  • Jean-Francois,

    By definition a "static" height detail band will print the exact size you
    define it each time the detail band is printed. If you would like the band
    to shrink to the space used, you will need to use a dynamic h…
  • Hi Ian,

    This can be caused by a number of items. The article below may offer some
    insight to the issue.

    1. ReportBuilder does not currently contain any support for Unicode. We are
    hopeful that Borland will add Unic…
  • Hi Ian,

    Take a look at the following example on accessing and modifying the RAP code
    present within a template. This should get you on the right track to
    accessing any RAP code you may need to.

    in Report template translations Comment by nicocizik June 2007
  • Hi Ian,

    Rather than trying to translate your template on the fly, I would suggest
    creating three different templates, each pre-translated. Then load each
    template based on which language you would like to display. If you hav…
  • Hi Frederic,

    Thanks for the clarification. There is no built-in way to split a single
    report into multiple print jobs however it should be fairly easy to
    implement this yourself by altering the SQL for a number of print jobs …
  • Hi Frederic,

    I would suggest taking a look at the background printing feature. This will
    allow you to print in a different thread while still having access to your
    application. See the TppReport.BackgroundPrintSettings prope…
  • Hi Ian,

    I would suggest using a DBMemo object rather than manually populating a memo
    object in the OnCalc of a variable. This will simply traverse the data it
    is given.

    --
    Regards,

    Nico Cizik
  • If you are a registered user of ReportBuilder 10.x, you can contact
    info@digital-metaphors.com with your serial number and purchasing email
    address for upgrade instructions.

    --
    Regards,

    Nico Cizik
    Digita…
  • Hi Tony,

    If you download the trial edition of the latest version of ReportBuilder
    (10.06), you will be able to compile and test your current applications with
    Delphi 2007 very easily. ReportBuilder 10.06 is the only version o…
  • Hi Martin,

    This is not a known issue with RB 9.03. Are you able to see the labels on
    screen or are they not showing up there either? If you would like, you can
    send a small example that demonstrates the issue in .zip format …
  • Hi Jeff,

    Where are you assigning the CurrentStatus variable? I would recommend
    implementing the OnStatusChange event which will fire each time the status
    text is altered.

    Note: In your first line of code, you are …
  • Hi Jeff,

    You can use the TppSMTPCustom.Status property to check the current status of
    an email being sent. This can be accessed directly from the TppEmail object
    or from the report using the TppReport.Email property.