Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

1 report for 2 tables

edited January 2006 in Subreports
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.

Comments

  • edited January 2006

    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
  • edited January 2006
    that's all right, many thanks !

This discussion has been closed.