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

    I'm a bit confused about how your data is arranged. Perhaps if you give me
    a simple example of what your tables/queries look like before you generate
    the report will help me come up with a solution for you. Currentl…
  • Hi Don,

    If you detail dataset is ordered by customer, then store location, you could
    simply place a group inside your detail subreport on store location and
    place the store location in the group header. This would only print …
  • For future reference, please use your real name when posting to these
    newsgroups.

    From RAP, I would suggest taking a look at the Report.Parameters property.
    You can create a parameter to represent the parameter usied in your q…
  • Hi Ken,

    In order to access TeeChart properties from RAP, you will need to create a
    pass thru function. I believe the TppTeeChart.Chart property is available
    so this could be passed to the pass thru function and then used in D…
  • Hi Bersin,

    I have not seen this behavior before. Which version of ReportBuilder and
    Delphi are you using? Is there something different about the two fields
    that are being displayed incorrectly?

    --
    Regards,
  • Hi Aaron,

    The ExecuteFunction routine cannot be called separate from the report
    object. What exactly are you trying to accomplish. If this is a pass thru
    function in Delphi, you should be able to test it using a simple repor…
  • Hi Chris,

    Sorry, I'm a bit unclear about the problem. Are you trying to access a
    stored procedure on your database? In this case you can create a custom
    dataview to access and adjust the parameters of the stored proc. Take …
  • Hi Chris,

    The TdaSQLBuilder object was designed to allow you to easily alter the SQL
    without having to actually use SQL code. Changing the query to use the SQL
    code you have below should be very easy using the built-in routin…
  • Hi Max,

    This is not a known issue.

    1. Please upgrade to RB 10.06 and test with that.

    2. If you are still having the same issue, please create a minimal example
    that demonstrates the behavior and send it to su…
  • Hi Max,

    Which event are you assigning the value of the TppVariable? Try coding this
    in Delphi first so you can find the correct event and settings to use to
    obtain the proper value, then move your code to RAP. This way you c…
  • Hi Bersin,

    I'm a bit unclear about the full issue. Where are you assigning the global
    variables? If it is inside the OnGlobalCreate event, they should never
    loose their values unless it is changed in another event.

  • Hi Andi,

    The GlobalOnCreate is now called from the Report.InitializeParameters
    method. This change was made because it was firing too late (after the
    autosearch dialog had been displayed). It needs to fire before any other
  • Hi Peter,

    Try setting the Report.CachePages property to True and see if that solves
    the problem for you.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in Running total, page by page Comment by nicocizik August 2007
  • Hi Peter,

    1. Be sure you are using a two pass report.

    2. Try placing a DBCalc component inside your footer band set to calculate
    the Count(*). This should give you the number you are after. Otherwise you
    can use…
  • ----------------------------------------------
    Tech Tip: RAP: Checking for Null Data Values
    ----------------------------------------------

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

    I'm sorry, for some reason you did not receive my first email. I just
    re-sent the email. Let me know if you get it.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in OnCalc timing Issue using Traversal on Detail Comment by nicocizik September 2007
  • Hi Richard,


    Which version of Delphi are you using? Are you using a registered copy of
    ReportBuilder or an application with RB built-in?

    I would first recommend upgrading your version of ReportBuilder to the
    l…
  • Hi Richard,

    For future reference please begin a post by stating the version of
    ReportBuilder and Delphi that you are using.

    I'm a bit unclear about the design of your report. Does this calculate
    correctly if your r…
  • Hi Fillipe,

    How are you sure this is the line giving the error? If you remove this line
    from the RAP code, does everything work correctly?

    What I mean by trying it in Delphi is creating a test application with a
    si…
  • Hi Fillipe,

    What error do you recieve? Is this an error when you try to compile your
    RAP code or an error when you try to generate the report? Have you tried to
    get this working in Delphi code?

    --
    Regards,
  • Hi Max,

    Does this occur when printing directly to the printer or from the previewer?
    In my testing when printing from the preview window, the AfterPrint event
    fires once for the previewer and once for the printer (as designed)…
  • Hi Mark,

    You will want to use the Report.Engine.PrintPosRect.Top property to get the
    position on the page after the detail band generates. Subtracting this from
    the Engine.PageBottom should give you the remaining space availa…
  • Hi Chantal,

    My first suggestion would be to download and install a trial edition of RB
    10.06 and test with that. We have gradually been making changes to the
    TppVariable to handle the limitation of calculating a page total wi…
  • Hi,

    Which version of ReportBuilder and Delphi are you currently using? When
    making calculations, I would recommend exclusively using TppVariable
    components rather than DBCalcs. DBCalc components are designed to function
  • Hi Richard,

    RAP does not support sets or arrays. If you need to keep a list of data or
    objects, try using a TStringList or TList object which are both available in
    RAP.

    --
    Regards,

    Nico Cizik
  • RAP supports the Date, DateTime, and Time data types. These types work the
    same as they do in Delphi. See the RAP Language Overview topic in the RAP
    Reference help for everything supported.

    --
    Regards,

    Nico …
  • ----------------------------------------------
    Tech Tip: RAP: Checking for Null Data Values
    ----------------------------------------------

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

    Perhaps I'm a bit unclear about what you are trying to accomplish. What
    exactly are you trying to order? Are you placing a DBText component inside
    the detail band of the report? If so, the only way to order the da…
  • Hi Chris,

    ReportBuilder retrieves data directly from the dataset you have it connected
    to. If you need to reorder the records shown on a report, you will need to
    reorder the data in your dataset.

    --
    Regards,<…
  • Hi Ronald,

    RAP code inside a template will always remain in binary format. It is
    possible however to load a template and search the RAP code using the
    CodeModule property of the report. Take a look at the following example o…