nardmoseley
Comments
-
Below is an article on using the JITPipeline in a master/detail
relationship.
Once the master/detail relationship is configured properly the drill down
should work properly.
----------------------------------… -
RAP does not currently support DataPipeline events.
Can you provide more details about what are you trying to accomplish?
Perhaps there is an alternative approach.
--
Nard Moseley
Digital Meta… -
That is a limitation of the visual linking. DataPipeline linking requires
that the detail data be sorted by the linking field(s). The automatica
linking feature works by generating special linking SQL for the detail
query.
For a 'calc field', the column position of the field as it appears in the
Select clause is used in the Order By
example:
Select CustNo,
Sum(AmountPaid)
from Orders
Order By 2
In t…
The formatting of text displayed by report elements such as TppDBText, is
handled by the TppDisplayFormat class (see
RBuilder\Source\ppDisplayFormat.pas.) You can easily create a descendant of
TppDisplayFormat and specify tha…
The basic approach is to use the Query Designer to create Autosearch
criteria for the first query and then programmtically apply the search
criteria to the second query.
ReportBiulder 9 includes enhancements designed spe…
Thanks for pointing this out. The field lists in the edit toolbar and report
wizard will be sorted for the next maint release (10.01). If you want to
receive a patch for this now, email support@digital-metaphors.com and reques
Make sense.
As for (c), you can programmatically create Report.AutoSearchFields[], which
will result in RB displaying the AutoSearch dialog for you. Basically you
would use the Report.OnInitializeParameters event t…
Welcome to the ReportBuilder community
Our goal is to produce the best quality product and support possible -…
Glad this mystery is solved. We had not encountered this before.
If you are using D6, then perhaps there is something related to one of the
update packs. We compile RB with D6 Update 2, but I think there was another
update 2 to the rtl that we do not use. No customer has reported an issue
…
Sounds very frustrating. Have not ever heard of this before. We have
thousands of users and we have been using the same demos for many years now.
But we have not had any reports of the demos not working.
1. As a simple test, try creating some simple non RB demos that access the
DBDemos data.
2. If that works, then perhaps you have a corrupt installation. See article
below.
-------------------------------------…
In the form/datamodule OnDestroy, try adding a line of code to explicitly
free the TppTeeChart.
There are some types of series that reference other series or functions.
TeeChart does not handle the free notification betw…
Are you using the ReportBuilder Data workspace (DADE) or are you using
external DataPipelines that reside on a form/datamodule?
If you are using ReportBuilder's Data workspace to build Query DataViews
then you can modify…
1. For the detail data pipline set SkipWhenNoRecords to False if you want
the master record to be included in the report when there are no
corresponding detail records.
2. Configure the Report.NoDataBehaviors propery to …RB 10 includes an example of using stored procedures and autosearch fields.
The examples shows how to create custom custom dataview classes that can do
this. It is installed to RBuilder\Demos\EndUser Database\SQL Server\ADO.
-…
- Try using the TdaSQLBuilder class instead. This is a new class introduced
in RB 9 that can be used to easily modify the TdaSQL object associated with
a Query DataView. Check out the RBuilder.hlp topic for TdaSQLBuilder.
Here is an example of using the JITPipeline over a TDataSet. It demonstrates
that JITPipeline.Eof works the same as DataSet.Eof.
www.digital-metaphors.com/tips/DataSetViaJIT.zip
You can also check out the source cod…
DADE is open and extensible.
You can build custom DataView classes to do anything that a TDataModule can
do. A TDataModule is a container for data components. Likewise a DataView is
a container for data acces…
The Delphi architecture of the TDataModel is such that it is global/visible
to the entire application. The reason RB works the way it does is because
customers requested that we follow the Delphi standard. If you place a
Repo…
Make sure that you do not have any event-handler code that manipulates the
dataset in any manner while the report is generating.
Are you using the ReportBuilder data workspace to link two queries? Or are
you using extern…
---------------------------------------------------------
Tech Tip: Define Master/Detail DataPipeline Links in Code
---------------------------------------------------------
Defining a Master/Detail relationship for a Data…
To use the IBO DADE plug-in at Delphi design-time, you need to compile and
install the package rbIBOxx.dpk into the Delphi IDE. (note: the xx is a
package suffix that represents the RB version and Delphi version).
Follo…
- search your machine for daIBO.* - you may have multiple copies of
daIBO.pas and daIBO.dcu installed to various directories, perhaps IBO
included one - do not use that one
- remove all occurences of daIBO.dcu
- remove a…
- 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…