Report Builder formatting question

Yahoo Archive
1
Thanks, Sarah & Patrick.

The "Print Once" option on the group does *exactly* what I wanted. Just
feel a little dumb for not figuring that one out sooner!

The on-line help doesn't explain it well, but if anyone else wants to see
it, there's a good example on page 9-11 of the PDF R.B. Users' Guide.

-Wayne
2
Hi All,

Have a Report Builder formatting question... this has been bugging me for
a long time, and I finally figured out one way to do it, but it's sort of a
kludge. If there's an easier way, I'm all ears.

In a case where there are one or more detail records for a group header, I
want to print the 1st detail in the group line. Then if there are
additional details, print them on subsequent lines. To illustrate with
Part and PartBin:

PartNum PartDesc BinNum1
BinNum2
BinNum3

PartNum PartDesc BinNum1

PartNum PartDesc BinNum1
BinNum2

I managed to do it by duplicating the detail fields on both a group header
and a detail line. However, that always prints the first detail
twice. So I added an aggregate and calculation like:
BinCount: Count(BinNum, PartNum, Every, Final Pass)
LineFlag: BinCount = 1
and conditionally print the detail line when LineFlag = False

It works, but it's a bunch of hassle for something I'd like to use
frequently. Any better suggestions?

-Thanks,
Wayne Cox
3
The way I've done this in the past is the following:

Create a sortBy 'PartNum". Create a SortBy 'BinNum'. GroupBy PartNum, then
By BinNum. Set the PartNum Group to 'Print Once'.

HTH,

Sarah



[Non-text portions of this message have been removed]
4
Simple Reports:
You can do this in your example by setting Sorts and Groups to 1) PartNum,
2) PartDesc, next change the groups by checking the PRINT ONCE check box.
Put the three fields on the record line and you will get the results you
wish.

More Complex Reports:
When you get into complex reports you may want to Create a Variable such as
PART_DESC which would consist of the equation of PartNUM + " " +
SubString(PartDescription,1,20) then use the variable for sorting and
grouping again check PRINT ONCE and then you would only use up one sort and
group.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a



-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, November 07, 2001 10:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder formatting question


Hi All,

Have a Report Builder formatting question... this has been bugging me for
a long time, and I finally figured out one way to do it, but it's sort of a
kludge. If there's an easier way, I'm all ears.

In a case where there are one or more detail records for a group header, I
want to print the 1st detail in the group line. Then if there are
additional details, print them on subsequent lines. To illustrate with
Part and PartBin:

PartNum PartDesc BinNum1
BinNum2
BinNum3

PartNum PartDesc BinNum1

PartNum PartDesc BinNum1
BinNum2

I managed to do it by duplicating the detail fields on both a group header
and a detail line. However, that always prints the first detail
twice. So I added an aggregate and calculation like:
BinCount: Count(BinNum, PartNum, Every, Final Pass)
LineFlag: BinCount = 1
and conditionally print the detail line when LineFlag = False

It works, but it's a bunch of hassle for something I'd like to use
frequently. Any better suggestions?

-Thanks,
Wayne Cox



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/