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

    Looking at the code, it looks like you can get access to the Items property
    of the Calcfields list which returns a TdaCalculation object. It does not
    however look like this (or the TdaField) class is exposed to RAP…
  • Hi Brian,

    Which version of ReportBuilder are you using (10.0x)? In my testing with
    the end-user demo and ReportBuilder 10.07, I was able to successfully create
    a report with a page break, save it to a blob field, reopen it, r…
  • Hi Chantal,

    How do you determine the text that is to be passed to the subreport
    variable? Would it be possible to assign the variable a "numerical"
    representation of the text value and perhaps use that to display the correct …
  • Hi Chantal,

    Would it be possible to keep a TppLabel updated with the proper text each
    time the variable calcs so you don't have to deal with the string variable?

    --
    Regards,

    Nico Cizik
    Digital Metaph…
  • Hi Nick,

    1. You need to be sure GraphicEX supports the type of Tiff image you are
    trying to display. Try using the demo app that came with the library to see
    if you can load your image.

    2. Try to get this working…
  • Hi Scott,

    There is now a patch that fixes this issue for RB 10.07. If you would like
    this patch please send a small email to support@digital-metaphors.com.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in downto Comment by nicocizik March 2008
  • Hi Mark,

    If I understand correctly, you would like to hide everything if all
    field values are the same and display everything if at least two field
    values are different?

    I would need to know more information about y…
  • Hi Alex,

    The RecordNo property of the DataPipeline is currently not available in RAP.
    The datapipeline traverses the data from start to finish, it does not have a
    concept of a record count before it has begun. What exactly wo…
  • Hi Marco,

    Yes, rbRCL10105.bpl is the correct package. Are you able to recreate this
    behavior with a simple example? If so, please send it in .zip format to
    support@digital-metaphors.com and we'll take a look at it for you.
  • Hi Marco,

    After looking at the RB 10.07 code and running it, we found that the main
    report's code module is created even if there is only RAP code in a
    subreport. Try upgrading to the latest version of ReportBuilder (10.07) a…
  • Hi Randy,

    One option would be to simply place another TppVariable inside the summary
    band and then inside the OnCalc of the variable in the Group Footer, update
    the summary variable's Value property as well.

    --
  • Hi Robert,

    Yes, it is possible to create any report component in RAP. I would first
    suggest creating any component in Delphi and getting that working, then move
    the code to RAP. Adding the following code to your Report.Befor…
  • Hi Rob,

    The TdaSQL object is a very complex and sometimes confusing item to use
    (even for us). This is why a few years back we decided to create the
    TdaSQLBuilder class which makes using the SQL object much easier and
    s…
  • Hi Rob,

    The Field SQL Alias is assigned by ReportBuilder to ensure a unique name is
    given to each field. This value is essentially only used by the database,
    ReportBuilder uses the FieldAlias property to define and show each …
  • Hi Chantal,

    The crosstab component traverses all the data it is given independent of the
    report. The primary way to filter this data is to set up a Master/Detail
    relationship with your data so the crosstab only receives the d…
  • Hi Chantal,

    Which version of TeeChart and ReportBuilder are you using?

    If possible please create a simple example demonstrating the issue that I
    can run on my machine and send it in .zip format to
    support@digital-me…
  • Hi Chantal,

    We have not seen this behavior before. Be sure the second series is
    connected to the second datapipeline. Double check to be sure the Count(*)
    field is present in the second dataset. In my quick testing I create…
  • Hi Stuart,

    Section subreports have the ability to create their own print jobs. Be sure
    you have the Subreport.NewPrintJob property set to True and the
    Subreport.ParentPrinterSetup property set to False. Then in an event that…
  • Hi Stuart,

    Inside the zip file is a Delphi project that demonstrates how to calculate a
    total from a subreport inside the main report using RAP code. You should be
    able to simply open the .dpr project file in Delphi and compi…
  • Hi Paul,

    Paul is correct. Below is a small example of what he is talking about.

    http://www.digital-metaphors.com/tips/TotalsFromSubr…
  • Marijo,

    The RoundTo routine is not supported in RAP. We will consider adding it to
    a later release. Currently you will need to either use the Round function
    or create a RAP passthru function to use the RoundTo routine in Del…
  • Hi Chantal,

    You might try contacting the third party company that provided the Excel
    export software for a quicker answer.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in Report to Excel with Text fields Comment by nicocizik May 2008
  • Hi Chantal,

    Take a look at the following example on hiding the DADE menu items. You
    should use a similar method to hide the RAP menu items. Below are the
    changes that need to be made.

    in Deactivate menu options Comment by nicocizik May 2008
  • Hi Ricardo,

    Try placing a TppPageBreak component at the end of your report. This will
    break to a new page after all other report components have been generated.

    --
    Regards,

    Nico Cizik
    Digital Metaph…
  • Hi Jeroen,

    It looks as though the pipelines are opened too late to set the file name
    using the TextFileName property.

    One option would be to access the Report.FileDevice.FileName property
    directly using a passthru f…
  • Hi Steve,

    The TdaSQLBuilder object is not designed to simply give you access to the
    SQL object, it is a wrapper around the SQL object making it easier to
    manage. I would suggest trying to use some of the built-in routines
  • Hi Rob,

    Parenthesis are TdaCriteria objects in the Items list as well. You can loop
    through the Items list and check the TdaCriteria.CriteriaType property to be
    sure you are about to remove the correct index. Then using the …
  • Hi Susan,

    Once the SQLBuilder object is destroyed (freed), the ApplyUpdates routine
    will be called automatically if the object has changed so there is no need
    to make the call in your case.

    --
    Regards,
  • Hi Rob,

    Yes, you are correct. I created a small patch that allows you to remove
    parenthesis using the SearchCriteria.Remove command. Send a small email to
    support@digital-metaphors.com requesting the patch and I'll send it t…
  • Hi Rob,

    Below was my reply to your original post. I believe the reason you are
    unable to see your post is that you chose a subject that has already been
    used in this newsgroup. Some news readers (like outlook express) will s…