nardmoseley
Comments
-
You need to create a custom dataview class. For examples, see
RBuilder\Demos\EndUser\Custom DataViews. Also check out the DADE thread of
the Tech Tips newsgroups for an overview of the architecture.
You will want your cu… -
For each dataset you need a separate DataPipeline. If the detail data is
embeddd in a blob field of the master, then you still need two
DataPipelines.
A DataPipeline can have any number of fields defined for it
(Da… -
Correct, there is a DataPipeline.GetFieldAsStream method
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
-
1. AutoSearchFields can be defined for any report.
2. The Report.OnGetAutoSearchFieldValues event fires after the user has
specified the search values. This event is typically used to apply the
values to the SQL where cl… -
There is a tutorial on using the JITPipeline in the Developers Guide.
There are examples of the JITPipeline in the main reports demo. Run
RBuilder\Demos\Reports\Demo.dpr and check out the 'no database' section.
A JI… -
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…