Intraweb, Mydac MySQL

rbuser

I am running Delphi 7 Intraweb 7.2.11 and reportbuilderpro 7.4(Trial). MyDac
3.1(trial).

I have a report that has three datapipelines connected to MYDac queries.

Datapipeline1 points to MyQuery_Customer (The main table). begin current
record end current record.

Datapipeline2 points to MyQuery_Invoice (the main invoice table) with master
as datapipeline1. begin current record end current record.

Datapipeline3 points to MyQuery_Inv_list(the items contained in the invoice)
with master as datapipline2. begin firstrecord end lastrecord.

The header contains fields from Customer, (Customer number, address etc) and
Invoice, (Invoice number, del_details etc)


The detail contains fields from Inv_List ( quant,stock_Code etc).

I run the report and export to a PDF. I am only getting one item line
showing in the details field.

Am I missing some settings or is there problem with the various products I
am using.


Cheers

Steve Warburton

nardmoseley

Steve,

Thanks for your interest in ReportBuilder.

1. Make sure that you have the datalinking relationships defined properly.

See the Data Access section of the Tech Tips newsgroups for an article on
linking queries. ReportBuilder supports dataset linking and datapipeline
linking - but you need to use one or the other - not both.

2. The report layout should contain subreports for each detail datapipeline
that you want to traversed. Example

main report - DataPipeline1
detailband
subreport1 - DataPipeline2
detailband
subreport2 - DataPipeline3


3. Below is a list of resources for learning the ReportBuilder. I recommend
that spend sime time up front with the Developers Guide, tutorials, and
demos. This will enable you to have great success with ReportBuilder and
avoid
frustration. ---------------------------------------------------------------
Article: Resources for Learning ReportBuilder
---------------------------------------------------------------

1. Learning ReportBuilder is a complete learning system designed to teach
end users how to build a range of reports, but it is also an excellent
resource for the developer who is just getting started with RB. Learning RB
includes a 125-page PDF file, a stand-alone application complete with a
database, and a help file. The PDF file contains a set of tutorials, which
can be completed using the provided application. Learning ReportBuilder can
be downloaded from:

http://www.digital-metaphors.com/Subpages/Downloads/LearningRB.html


2. Developer's Guide

When you install RB, this guide is automatically installed into the
RBuilder\Developers Guide directory. It contains extensive conceptual
information and step by step tutorials which show how to construct reports
and reporting applications within the context of the Delphi IDE.


3. On-Line Help

Accessible via a single click of the F1 key from with the Delphi IDE, this
reference resource explains the classes, methods, properties and events
which make up the product. It is also an excellent source of information
regarding installation, troubleshooting and version history.


4. Examples

There are a large number of example reports and reporting applications
included with RB. These show how to accomplish some of the most frequently
requested types of reports. In total there are probably over 200 different
examples covering everything from crosstabs to full-blown end-user reporting
solutions. The RAP functionality included with ReportBuilder Enterprise has
a separate set of demos, tutorials, and help files.


5. news.digital-metaphors.com

The newsgroups are very active with both Digital Metaphors engineers, TeamDM
members (volunteers specially selected for their knowledge of RB and their
willingness to help) and RB developers all pitching in to answer questions
and help each other out. There is also a Tech Tips 'newsgroup' maintained
by DM Engineers which lists over 100 different articles outlining various
tips and techniques. Probably the easiest way to connect to the newsgroups
is to surf the digital metaphors site, go to the support section and click
the newsgroup of your choice:

http://www.digital-metaphors.com/Subpages/Support/newsgroups.html


ReportBuilder newsgroup archives may be searched using a search engine
hosted by Tamarack Associates. Access the the following URL and then search
the Borland Newsgroup database. Tamarack has indexed the ReportBuilder
newsgroup archives in this database.


http://www.tamaracka.com/




6. support@digital-metaphors.com

When you are working on the really advanced stuff, and need an additional
point of view, we're always glad to help.



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



Best regards,
--

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