1 report for 2 tables
Hi,
sorry for this seems to be a very basic question... but I didn't find any way
to do it : i just want to print the content of 2 (completely independent)
tables on a single report...
I've tried with subreports but only the first record of each table is printed.
Thanks for any help.
sorry for this seems to be a very basic question... but I didn't find any way
to do it : i just want to print the content of 2 (completely independent)
tables on a single report...
I've tried with subreports but only the first record of each table is printed.
Thanks for any help.
This discussion has been closed.
Comments
Create a main report with no header/footer. Leave the datapipeline
unassigned.
Place two subreports in the detail band. For each subreport set
PrintBehavior to pbSection.
Connect each subreport to a datapipeline.
Access the layout workspace for each subreport and design the layout.
This will result in subreport 1 being printed, followed by subreport 2. Each
section by definition will start on a new page. (In other words this will
produce 2 report or section - that print as a single document).
The other way to design it is to set the subreport PrintBehavior to pbChild
and set subreport2 to ShiftRelativeTo subreport1. This will produce two
subreports that print on the parent report's page space (more like a memo).
All of this covered in the ReportBuilder Developers Guide. Below is alist of
resources for learning RB...
---------------------------------------------------------------
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/LearnRB/LearnRB.exe
2. Learning to RAP is designed to teach end-users how to use ReportBuilder's
Calc workspace to perform calculations and control visual aspects of the
report while it is generating. Learning to RAP includes a 59-page PDF file
and a stand-alone application complete with a database. The PDF file is
comprised of a series of tutorials that step end users through the process
of coding calculations and event-handlers to dynamically control report
generation. The application is used in conjunction with the tutorials so
that the learning experience is interactive. Learning ReportBuilder - RAP
can be downloaded from:
http://www.digital-metaphors.com/LearnRB/LearnRap.exe
3. 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.
4. 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.
5. 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.
6. 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/
7. 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
www.digital-metaphors.com