1 TppReport, 1 TppDBPipeline and 10 Report Templates

rbuser

Hi,

I am using Delphi 7 with RBPro 7.x.

I have 10 report templates each with different formats and each with
code in the OnBeforeGenerate event. Currently, I have 10 TppReports
and 10 TppDBPipelines to process these 10 report templates but I would
like to use only 1 TppReport and 1 TppDBPipeline since it takes too
long for the program to construct.

Is it possible with the event code? I have looked at the End-User
Reporting tutotial and demo but the report templates there are all
based on formats where event code is not present.

The alternative I am currently thinking is to use one form per report
and to create the form when I want to use that report.

Regards,
Frederick

nicocizik

Hi Frederick,

The easiest way to go about this would be to utilize the DADE and RAP
features of ReportBuilder Enterprise. DADE (which is available in your
version of RB Pro) allows you to define and save your datasets inside the
report template so there is no need to have any pipelines on a form. RAP
(available with RB Enterprise) allows you to keep all report event code
local to the template so there is no need to implement or keep track of any
event code in Delphi.

This way you can simply have one report on a form and load each template as
you need.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,


Are the datasets that are defined with DADE required to be static? For
example, I create a query for the report using the DADE. However,
before actually printing the report, I need to do some data processing
with the query before it is fed to the report. Any problems with this?


Oh, I didn't know this. I thought RAP was for end-users to put in code
for their own use. I actually am using RB Enterprise but my folder is
named as RBPro for some reason. Looks like I have a lot to pick up.


Thanks.

Regards,
Frederick

nicocizik

Hi Frederick,

Using DADE, and the TdaSQLBuilder object, you can take full control over the
querys created in code. Take a look at some of the dade examples located in
the Developer's Guide for a starting point. Then take a look at the
TdaSQLBuilder topic in the RBuilder help. This includes code examples on
how you can take control of the existing queries or in fact create new
queries with search criteria on the fly. Below is a link to the SQLBuilder
rbWiki topic including numerous how-to's.

http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,




Thanks! I appreciate your assistance.

Regards,
Frederick