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

    The issue is where to make the calculation. Try setting the visibility of
    the detail band inside the OnCalc event of the variables you are using. If
    this is too late to set the visibility of the band, you can try …
  • Hi Daniel,

    My first recommendation would be to create a calculated field in SQL that
    calculates the difference percentage between the two fields, then add a
    search condition to only return the records greater than 15%.
  • Hi Filip,

    If I understand collation correctly, printing a two page report with
    collation turned off will print in the following order...

    1. Page 1
    2 .Page 1 (copy)
    3. Page 2
    4. Page 2 (copy)

    You …
  • Hi Filip,


    The sample uses a TppDrawText component, not a DBText. Are you speaking
    about your application? Do you offer your users a custom component of some
    sort that shows a unique caption for each copy? If so, the c…
  • Hi Filip,

    You can work around this by using the OnStartPage event of the Printer
    Device. Take a look a the following example.

  • Hi Frank,

    Try placing a line inside the detail band with its ParentWidth property set
    to True and its Visibility set to False. Then inside the
    DetailBand.BeforePrint event, toggle the visibility of the line based on the
  • Hi Garth,

    Are you sure you have your subreports set to Section style? In my testing I
    created a simple main report with only a detial band and two Section
    subreports inside it. Inside each subreport was a TppLabel component.…
  • Garth,

    We also prefer you use your real name in the "from" section when sending
    posts. Currently your name is "vader4d", please change this as well.

    You need to be sure your subreports are individually connected to the p…
  • Hello,

    For future reference we prefer you use your real name when posting to these
    newsgroups.

    Try creating an empty main report with nothing but a detail band. Then
    place two Section style subreports inside the de…
  • Hi Kimberly,

    Depending on the size of your report, if you know the number of records that
    fit in the first set of columns, you could use multiple queries to display
    one fixed style subreport and one child style subreport in th…
  • Hi Everett,

    The OnCalc event should fire regardless. Are you by chance loading a
    template in your application? If so, you may be loosing the event handler.
    Take a look at the following article for more information.

  • Hi Peter,

    You can do this by setting ParentPrinterSetup property of the subreport to
    False and either manually assigning the PrinterSetup of the subreport (using
    the Delphi object inspector) or doing so in code before the repo…
  • Hi Isabelle,

    Angled lines are currently not supported in ReportBuilder. One alternative
    would be to create an image of an angled line and use that in your report.
    Another would be to take a look at the TwPaintBox freeware com…
  • Hi Filip,

    The Report printing process was not designed to allow the streaming of only
    the first copy of a report to archive when more than one copy was selected.
    I would recommend either creating and streaming the archive file…
  • Hi Everett,

    First I would recommend upgrading your version of ReportBuilder to the
    latest, 10.04. This would be a free upgrade if you are a registered user of
    RB 10.x. Contact info@digital-metaphors.com for upgrade informati…
  • Hi David,

    Thanks for the info. In my testing with RB 10.04 and Delphi 7, this seemed
    to work correctly. This is something that was perhaps fixed for a release
    later than 7.04. Thanks again.

    --
    Regards,
  • Hi David,

    Sorry for the delay, my newsreader lost track of the thread.

    You are correct, all you need to implement to successfully get the
    JITPipeline working is the OnGetFieldValue event technically.

    I will tak…
  • Hi David,

    Mixing JITPipelines and DBPipelines should not be a problem. JITPipelines
    are essentially the same as DBPipelines only they do not contain any
    built-in logic to connect, traverse, locate, etc. your data. This is wh…
  • Hi David,

    This error indicates that the Interface section of one of your RB source
    files has been changed from its original state. Since we do not ship the
    source to RAP, all the source files must remain interface specific in…
  • Hi Andrew,

    For the most part, the correct units will be added automatically to your
    uses clause as you are designing a report. Some common units you may need
    to add are ppJPEG for jpeg images and ppTypes for enumerated types.…
  • Hi Andrew,

    You need to add ppJPEG to you uses clause. Also, be sure the GraphicType
    property is set to JPEG.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
  • Hi Ian,

    There is no built-in way to copy a value from the preview to the clipboard
    however it may be possible to manually give your users this capability. One
    option you might explore is implementing the OnDrawCommandClick ev…
  • Hi Larry,

    Thanks for the example. I just sent you a response.

    For those following this thread, I will continue correspondence via email
    and post the solution here once the problem has been resolved.

    --
    R…
  • Hi Larry,

    This is not a known issue. In my testing with RB 10.04, Delphi 2006, Indy
    10, and the Indy demo (dm0110.pas), I am able to successfully send an email
    with an attached report. If possible, please construct a simple …
  • Hi Andrew,

    ReportBuilder uses the specific DADE plugin to determine the table names.
    Take a look a the GetTableNames function in the TdaSession descendent of the
    DADE plugin you are using to see how this is currently done in y…
  • Hi Jose,

    For future reference, please send all attachments to
    support@digital-metaphors.com.

    Sorry, I did not realize you wanted a percentage of a group total. The
    example I sent calculates a running percentage bas…
  • Hi Jose,

    As a quick test I moved the code from the example in Delphi to RAP and
    everything seemed to work correctly. You will need to declair the
    FGrandTotal variable in the global declarations section of the Module View.
  • Hi Juan,

    Try the following example. I tested it with D2006 and RB 10.04 and it works
    correctly.

    http://www.digital-metaphors.com/tips/percenta…
  • This is a multi-part message in MIME format.
  • Hi,

    Inside the DetailBand.BeforePrint event you can check the value of the text
    in the group header and if it is the same as what will be printed in the
    detail band, you can set the visibility of the components to False.