ppwwrichEd

rbuser

Hi,

I'm using infopower to load blobs using wwDbRichedit that contains Rtf
documents or Excel-Pastes
& print them via Reportbuilder with ppdbRichtext (updated
with ppWWRichEd ).
But the print is never complete (stops at the end of a page - mostly the
second page) and the next page is empty or the text is mixed with data of
the following record.

Now I use a dbrichtext followed by a subreport with data gathered in the
event Onprint.
What can I try to make it work ?
Maybe it is a timing problem or is the size calculation wrong?

Delphi BDS2006
RB 10.06
InfoPowerStudio2007

Best Regards,
Herman Janssens
ACTA-B nv

nardmoseley

You say "..I use a dbrichtext followed by a subreport with data gathered in
the
event Onprint."

What do you mean 'data gathered in the OnPrint'? Is the DBRichText not
connected to a blob it loads directly?

As a test try setting subreport.Visible to false, then run the report to
determine whether the DbRichTet generates correctly.


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

rbuser

Hello Nard,

Yes, the Dbrichtext is connected to an blob
with setting the subreport.Visible to false, the Dbrichtext is ok
My fault, the subreport was not always visible in the program execution.

But I have a subreport that contains
DBrichtext1
Child Subreport1 with onprint event that executes a sql to fill the pipeline
for subreport1
DBrichtext2 with same text as 1 (to test)
Child Subreport2 with onprint event that executes a sql to fill the pipeline
for subreport2

All with the exact shiftrelative setting.

if the subreport1 is visible Dbrichtext1 never prints all of the text; it
contains 3 pages
but it print 2 pages of it and stops at the end of the 2nd page.
I don't get it, Nard

Herman.

nardmoseley

Below is an article that discuses techniques for linking data. Do not use
the Subreport.OnPrint event, that will not work.


------------------------------------------------------
Tech Tip: Linking SQL Queries for Master/Detail Data
------------------------------------------------------

The following example shows two options for linking SQL queries to create a
master/detail relationship.

In this example, we are using Delphi's DBDemos data to create a
Customer/Order relationship. Thus we wish to link the Orders detail to the
Customer master.

I. Delphi Query Linking
------------------------

a. Set the detail TQuery.DataSource property to point to the master
query's TDataSource component.

b. In the SQL "Where" clause for the detail query use a ':' followed by
the linking field name from the master:

example
select *
from orders
where orders.CustNo = :CustNo

Now each time the master record position changes, the detail query will
automatically be refreshed with the correct result set.


II. RB DataPipeline Linking
-----------------------------

a. Set the detail DataPipeline.MasterDataPipeline to point to the master
DataPipeline.

b. Use the detail DataPipeline.MasterFieldLinks property to define the
linking relationship

c. In the SQL for the detail, retrieve all records and sort them by the
linking master field:

select *
from Orders
order by CustNo


III. Manual filtering
---------------------

use the master datapipeline.OnRecordPositionChange event to filter the
detail data.

example:

detaildatapipeline.Close;
detailDataPipeline.SQL.Text :=
detailDataPipeline.Open;



Notes:

1. Using RB DataPipeline, each query is executed only a single time - thus
performance is much faster.

2. RB Professional and Enterprise Editions include a visual Data environment
for creating SQL queries, defining linking relationships, and creating
Ask-At-Runtime parameters. Using the RB tools you could create the above
linked queries in about 10 seconds.


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






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