Enduser Reports with ppDBPipeline combined with DADE

rbuser

Reportbuilder Enterprise 7.04
Delphi 5 Pro

Hi, we want to combine ppdbpipelines in Enduser-reports with DADE Datasets,

i.e. We have an ppDbPipeline named ADDRESSES, there is also a table called
CONTACTS createt in DADE (wihtin the enduser-report). Is it possible to do
something like:

REPORT1.OnStartPage
begin
CONTACT.filter='masterid='+inttostr(ADDRESSES['number']);
end;

Thanks for any tips,

Yusuf Zorlu
yusuf.zorlu@microtronx.com
-----------------------------------------------------------
MicrotronX Hard- & Software Consulting
http://www.microtronx.com

nardmoseley

1. This example shows how to link a DADE datapipeline with an external
datapipeline:

www.digital-metaphors.com/tips/LinkDADEPipeToStandardPipe.zip

2. For the datapipeline linking to work, the detail dataset must be sorted
on the linking field(s).


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

rbuser

"Nard Moseley (Digital Metaphors)" schrieb

nardmoseley

You could try implementing the code via a RAP pass-thru function and calling
it from the RAP Global OnCreate event.

--------------------------------------------------
Article: Extending RAP
---------------------------------------------------

There are two very simple and powerful techniques to extend the capabilities
of RAP infinitely. These are summarized below and covered in more detail in
the RAP.hlp online help. Demos and tutorials are installed to
RBuilder\Demos\RAP. The tutorial text is located in RAP.hlp.


1. RAP Pass-Through Functions

These are functions that appear in the Language tab of RAP's Code Toolbox.
These functions are written in Delphi and can be called from RAP. RAP's
pass-through function architecture enable's developers to add new built-in
functions to RAP's code toolbox.

2. Extend RAP's RTTI

RAP's Run-time Type information defines what classes and properties can be
accessed via RAP. By default the published properties of any class that is
registered with Delphi's RegisterClass procedure is recognized by RAP. In
addition many of the public properties and methods of ReportBuilder classes
are exposed.







--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com



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

rbuser

"Nard Moseley (Digital Metaphors)" schrieb

rbuser

OK. The Problem was not CHAR / INTEGER Field. My detail-table was not sorted
by the link-field.
Now everything is fine.

One performance-question:
When i use my funktions to create a master-detail link. Is this link
processed before open or after. (i.e. will dade read all 100000 customers
via sql and creates after that the link or will the link created BEFORE any
data is readed?)

Brgds,
Yusuf

nardmoseley

There is no performance penalty for linking. The datapipelines do not need
to be opened when the link is created. ReportBuilder uses the linking
information to traverse the data in a specialized manner. However,
ReportBuilder does this incrementally.


--