ReportBuilder - Grouping information or displaying it vertically instead of horizontally

rbuser

I'm using ReportBuilder to create a report from a SQL database. The report
has 3 fields of information.

Information: PART#, Serial #, and Information

Serial is the Unique Identifier but we want to group by Part# and display
the "information for the multiple Serials for that PART vertically or
together".

Example data:
PART# Serial# Information
22 1 John
22 2 Bill
33 3 Steve
11 4 Mike

In this example the data grouped will show like this
22 1 John
2 Bill

I would like to see it in one of two ways.
22 1,2 John, Bill
or
22 John, Bill

The serial # field is really not relevant in this situation.

nicocizik

Hi Jamie,

This can be done using a fixed style subreport and LeftToRight traversing
columns. You will need to have your datasets in a Master/Detail
relationship in order to get the effect you are after. I created a small
example that shows how you might go about doing this. Hope it helps.

http://www.digital-metaphors.com/tips/HorizontalMasterDetail.zip

--
Regards,

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

rbuser

Nico,
What do I do with this Zip file? When I unzipped it the file contains some
files which I don't know how to use.

I'm currently trying to figure out what version of ReportBuilder we are
using it is installed in a CANNED application.

I believe this is supposed to be something I can open in ReportBuilder? We
can load ReportBuilder RTM files.

For documentation I have the ReportBuilder Developers Guide Version 3 and
also the Learning Report Builder guide. All provided by the CANNED
application.

nicocizik

-----------------------------------------
Article: End-User Tech Support
-----------------------------------------

Please understand that Digital Metaphors can only provide tech support to
the Delphi developers that purchase ReportBuilder. Digital Metaphors
receives no distribution royalties from Delphi developers that embed
end-user reporting solutions in their applications. It is the responsibility
of the software publishers that sold you the product to provide you with
tech support.

There is an end-user tutorial called Learning ReportBuilder that can be
downloaded from our web site for free. See the following article for more
infomation.

--------------------------------
Article: Learning ReportBuilder
--------------------------------

Learning ReportBuilder is a complete learning system designed to teach end
users how to build a range of reports. This system includes a 125-page PDF
file, a stand-alone application complete with a database, and a help file.
The PDF file is comprised of a series of tutorials that step end users
through the process of building reports as simple as a table listing and as
complex as crosstabs. The tutorials also introduce conceptual aspects of
report building along the way. The application is used in conjunction with
the tutorials so that the learning experience is interactive. The end user
just prints out the PDF file, runs the application, and learns
ReportBuilder. The help file is accessible from the application, so all
three tools work together to provide a seamless learning environment.

Learning ReportBuilder installs into C:\Program Files\LearnReportBuilder.
When the system has successfully installed, a complete set of instructions
appears in the form of a 'ReadMe' doc, so the end user knows just what to do
upon installation.

- Download Learning ReportBuilder

http://www.digital-metaphors.com/LearnRB/LearnRB.exe

--
Regards,

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