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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,271
Last Active
Roles
Administrator

Comments



  • - The DADE plug-in for IBO will register an IBOSession session type.


    - The RBuilder\Demos\EndUser Databases\Interbase\IBO\ directory contains an
    example of using IBO. The ReadMe.doc installed to the same directory…

  • - in your Delphi application, what data access components are you using to
    work with Firebird? Or perhaps you are trying to decide?

    - For information about dbExpress see the Delphi documentation and the
    Delphi newsgroups…


  • - For examples check out RBuilder\Demos\EndUser Databases\Interbases

    - RB installs DADE plug-ins that support IBExpress and dbExpress. IBO is
    another option - the source to the IBO DADE plug-in is installed to
    RBui…


  • Correct. These should be updated to correspond to the specific IBO packages
    that you are using.


    The ReportBulder .dcp's and .dcu's are installed to RBuilder\Lib. The IBO
    installation should be doing something…

  • Yes. There is a RB 10 for Delphi 2006/Turbo Delphi that can be installed
    and used in Turbo Delphi. Trial versions can be downloaded from
    http://www.digital-metaph…

  • - the Owner of the Report instance should be a Form or DataModule

    myReport := TppReport.Create(myForm);

    - then all other objects: Designer, DataPipelines, etc should have the same
    Owner as the Report.Owner


  • - make sure you create the data components prior to loading the report.

    - do the two pipelines appear the data tree?

    - make sure that the ParentDataPipeline is set to False for the DBText
    components that are connect…

  • - to create a simple subtotal in the SummaryBand, add a Variable (Variable1)
    to the SummaryBand and implement the Variable.OnCalc to accumulate the
    results.

    Value := Value + myPipeline['AmountPaid'];

    - to add …
  • - use the TppVariable.OnCalc event to perform calculations. Do not use
    DetailBand before print. See the Developers Guide Tutorials and the
    Calculations thread of the Tech Tips newsgroups. Here is a quick overview...


    Calc…

  • The ReportBuilder online help containts a list of RB run-time packages for
    each RB Edition and Delphi version. (You can re-distribute RB run-time
    packages. )

    Acess the help, select ReportBuilder Reference | Table Of Cont…

  • - Build each .dll with the 'build with run-time packages' option selected
    and include the RB packages in the list.
    - Build the .exe with the 'build with run-time packages' option selected and
    include the RB packages in the lis…

  • I think I found the problem. The DADE plug-in packages for DBISAM needed to
    be updated.

    Starting with D2005, the new BDS IDE implemeted 'demand package loading' -
    it tries to delay loading any packages that it thinks are…

  • An example for RB and DBISAM is installed to RBuilder\EndUser
    Database\DBISAM. Please see the example and ReadMe.doc installed to that
    directory.

    - if you update to a newer version of RB or update to a new version of


  • Yes, my prior post included a comprehensive answer. Please re-read my
    complete post.


    DataSettings should be...

    SessionType = IBXSession
    DatabasType = dtInterbase
    SQLType = SQL2



  • - for future reference, please specify Delphi version, ReportBuilder
    version, Windows version, and database product and data access components.

    - the TdaSQLBuilder.SearchCriteria.Add call looks correct and using
    Delphi…

  • RAP does not support arrays.

    As an alternative try using TStringList or TList.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • We have a list of known plug-ins on our web site - see link below. I do not
    see one for SDAC. Try contacting Core Labs and inquire whether they have one
    available. The creation and maintenance of plug-ins is a community effort.

  • 1. To use the Data workspace (DADE) you will need a plug-in that supports
    the SDAC components. The plug-in will register a new SessionType with RB.

    2. I looked at the Core Lab web page for the SDAC components. Looks like the <…

  • ReportBuilder traverses the dataset using calls to First, Next, Prior, etc.
    It does not have any ability to sort the data.

    - one option might be to use a ClientDataSet, I think it enables an index to
    be defined. So perha…

  • Thanks for pointing that out. It is now updated for the code base moving
    forward.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com


  • When you open each query and click Ok, that is the same as iterating over
    the dataviews and updating the SQL object. If you do it once for Interbase
    and then switch to MSSQL and do it again, does it remove the Interbase

  • The Designer.DataSettings get assigned to the QueryDataView's internal
    TdaSQL object when the query is first created. You need to assign an
    event-handler to the Report.Template.OnLoadEnd event to iterate over the
    dataviews an…
  • Please configure your newsreader to post using your name. Currently it
    displays
    Christoph _baka0815_ Schwerdtfeger.

    This question should be posted to the DADE newsgroup. Until this post, I had
    no clue what you were trying…

  • When using the DADE Query Tools, each QueryDataView will have a single
    DataPipeline.

    When creating custom dataview classes, it is possible for a QueryDataView to
    contain any number of DataPipelines. For an example see
  • There is no option to contol that.

    If you use RB's Visual Data Access Environment (DADE) that is included with
    RB Pro and Enterprise, then the DataPipelines assocaited with the dataviews
    that you build will appear as root node…
  • ppTypes

    --

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • There is a tutorial in the Developers Guide as well. And the completed
    tutorials are installed.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • The main reports demo includes an example of a master/detail JITPipeline
    report.


    No that is not correct. The detail data must be ordered by the linking
    field(s). Your JITPipeline GetFieldValue event-handler code should r…

  • The TextPipeline supports simple data traversal, there is no SQL engine
    support.

    You might be able use a Delphi add-on component that has an in memory
    dataset that can do something like that. I googled and found this...<…

  • When you selet the 'build with runtime packages' option, which packages do
    you include/require?


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com