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

    When using the Calc tab (RAP), the Code Toolbox in the lower right corner
    should have three tabs near the bottom. The Objects tab will give you
    access to the properties available to each component (selected in the o…
  • ----------------------------------------------
    Tech Tip: RAP: Checking for Null Data Values
    ----------------------------------------------

    The DataPipeline.FieldObjects[] array property provides access to the
    TppField obje…
  • Hi Terje,

    Two options...

    1. Create a pass thru function that traverses your dataset directly and
    returns the proper value to the RAP program. For an example of creating a
    pass thru function, please see the develop…
  • Ian,

    The crosstab component does not function the same way the report does. It
    traverses your data independantly and builds a matrix based on that data on
    it's own before creating drawcommands that display everything. This i…
  • Hi Ian,

    Sorry, I misread your initial post. You can manually edit a calculated
    value in a crosstab using the OnGetValueText Event. Take a look at demo 127
    located in the \RBuilder\Demos\Crosstabs\... directory for an example…
  • Hi Ian,

    ReportBuilder simply traverses the data you give it. You should be able to
    filter the output by adding a search condition to your query accessing this
    data. Something like the following...

    select Org, Valu…
  • Hi Nick,

    Try using the Report.DataPipeline.Username property.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • Hi Chris,

    If each "detail" table contains a linking field (such as the PO#), you could
    link the master table (PurchaseOrders) to each detail table on that field,
    then when autosearching on that field, the criteria will apply t…
  • There is now a patch that adds the SendMail routine support for RAP. Please
    send a small email to support@digital-metaphors.com if you would like the
    patch.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
  • Hi Bob,

    1. When making calculations inside a report, only using the OnCalc event of
    a TppVariable. Which event are you updating the value of the global
    variable?

    2. As a test, try setting the Report.CachePages to…
  • Answered in your previous post. Please do not multi-post.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

  • Hi Barry,

    Try placing a shape inside the detail band behind all other components with
    ParentWidth and ParentHeight set to True. Then, inside the
    Detail.BeforePrint, you could add something like the following...

    Sha…
  • Hi Codebue,

    On possible solution would be to keep track of the field values for each
    page perhaps using a TStringList object. Then before the footer prints,
    loop through the values and determine which items get printed.
  • Hi Rob,

    The Values property only gives multiple values when using the Between or
    InList operators. This is not the case in your situation because you are
    essentially creating two separate autosearch fields based on the same f…
  • Hi Mark,

    It is possible to completely customize the autosearch dialog in
    ReportBuilder. Take a look at the demo located in the \RBuilder\Demos\5.
    AutoSearch\4. Custom AutoSearch Dialog\... directory for an example of this.
  • A pass thru function is a way to call something from Delphi from within RAP.
    This essentially gives you the ability to execute any Delphi code in RAP.
    In your case, you would create a procedure that sends a TStringList and a
    String…
  • Hi Shane,

    Checking the source, it doesn't look like CommaText is added for the latest
    version either. I will add this for the next release. In the mean time, I
    would recommend creating a simple pass-thru function rather than…
  • Hi Shane,

    One workaround is to use a TStringList rather than a String type if you need
    to access it like an array. Another would be to create a pass thru function
    to return the given index in a string array.

    --
  • Hi Shane,

    1. There is now a patch available for RB 10.07 that includes support for
    the CommaText property in RAP. If you would like this patch, please send a
    small email to support@digital-metaphors.com requesting it and we'…
  • You need to include raIDE in your uses clause to register the calc
    workspace.

    ------------------------------------------------------------
    Article: Controlling the End-User Environment
    -------------------------------------…
  • Hi Terje,

    One option would be to separate your report into groups and send the cut
    command in a group event. Take a look at the following article on printing
    to continuous paper for help with the paper size.

    ------…
  • Hi Terje,

    What are you trying to ultimately accomplish? Determining the record count
    prior to the report generating is very difficult if you do not have access
    to the original dataset, especially if you plan to alter the spac…
  • Hi David,

    Take a look at the following example of hiding the group header when there
    are no details. It uses a method similar to what you are currently using
    however it may give you some clues on how to fix the problem you ar…
  • Hi Deck,

    Take a look at the following example of refreshing a report from RAP. A
    passthru function is necessary to do this.

    in How to refresh Comment by nicocizik January 2008
  • Hi Scott,

    I created a small patch that adds the FolderID property to the
    DataBaseSetting RTTI. Please send a small email to
    support@digital-metaphors.com to get the patch.

    --
    Regards,

    Nico Cizik
  • Hi Deck,

    I removed your post from the General newsgroup. Please do not post
    attachments to these newsgroups. Send all attachments to
    support@digital-metaphors.com.

    By default, ReportBuilder does not create a borde…
  • Hi Deck,

    Sets are not supported in RAP. As a workaround, you can send your passthru
    function a value representing what should be done to the set, or you can
    create a separate boolean RTTI property for each value in the set si…
  • Hi Mark,

    Thanks for the info. There is now a patch for RB 10.07 that fixes this
    issue. Send a small email to support@digital-metaphors.com to receive the
    patch.

    --
    Regards,

    Nico Cizik
    Digita…
  • Hi Chantal,

    There is a patch available for RB 10.07 that addresses this problem. Please
    send an email to support@digital-metaphors.com requesting the patch.

    --
    Regards,

    Nico Cizik
    Digital Metaphors<…
  • Hi Chantal,

    If you are using DADE (data tab) you can click twice on the field alias
    (similar to renaming a file in the Windows Explorer) in the Query Designer,
    you can alter what is displayed in the AutoSearch dialog and Data …