Sorted reports driving newbie crazy (long 'n' whiney) 
Author Message
 Sorted reports driving newbie crazy (long 'n' whiney)

I am trying to learn to use Paradox and am using my organization's
employee phone list to learn on. So far, I have two tables: one with
information about employees, and another that lists various groups within
the embassy (every employee works for one agency or section). I've done OK
with forms and reports that combine info from the two tables, but my
latest project is driving me nuts. In addition to an alphabetical list of
employees, the phone list has a listing of employees by section. Within a
section, they are listed by section rank, and then alphabetically (section
heads should go first). I've done a query that sorts everybody in their
proper order, but things fall apart in the report when I try to add a band
that groups people by section. As soon as I add that, the chiefs wind up
in alpha order with the indians.
Here are my questions:
1. Am I on the right track in using a query to sort the report the way I
want it? How can I keep it on the right track?

2. I've designated the section rank field as a secondary index in the
original table, but haven't figured out how to make use of it. Would it be
useful in this case?

3. Adding a second group band within the section group band to sort by rank
would get the sorting right, but group bands seem to insist on adding vast
amounts of white space between groups, and I'd like a little more
subtlety. Indians are indians and chiefs are chiefs, but we don't need to
rub anybody's face in it. Is there a way to have my cake (group bands) and
eat it too (no white space)?

Thanks to the FAQ (thanks Joel!) at least I can go to work today knowing
how to pitch the whole thing into Word or WordPerfect and deal with it
there (I spent much of yesterday cursing the fact that Paradox lets you
export tables but not reports), but somehow that feels like cheating. More
to the point, since somebody besides me will be doing this eventually, I'd
like to make it as automated as possible.

Thanks for bearing with me; any help here or via email would be most
appreciated.

Adele



Sat, 23 Nov 1996 21:35:36 GMT
 Sorted reports driving newbie crazy (long 'n' whiney)

: 1. Am I on the right track in using a query to sort the report the way I
: want it? How can I keep it on the right track?

So long as there are fields to sort on at report time, group bands should
handle all of your sorting needs.  Perhaps the "Indians" sorting with the
"Chiefs" problem was bands in the wrong order?  The section should
be outermost, followed by rank, then lastname.  If your section and rank
are inside the last name, they will only be used to settle ties.

: 2. I've designated the section rank field as a secondary index in the
: original table, but haven't figured out how to make use of it. Would it be
: useful in this case?

I don't think so.

: 3. Adding a second group band within the section group band to sort by rank
: would get the sorting right, but group bands seem to insist on adding vast
: amounts of white space between groups, and I'd like a little more
: subtlety. Indians are indians and chiefs are chiefs, but we don't need to
: rub anybody's face in it. Is there a way to have my cake (group bands) and
: eat it too (no white space)?

The white space is there by default, but you don't need to put up with it.
Bands are movable.  Simply delete any header information that you don't
need within the band. Highlight the band, grab it with the mouse, and pull
it till the white space disappears.  When the cursor changes to a double
arrow, you know you can grab the band.  Keep in mind that the white space
is in both the band header and band footer, so you will have to squeeze it
out in two places.  I always have to "trial and error" this--which
direction to pull the band is sort of counter-intuitive in terms of the
effect it has.  But you can tell as soon as you let go of it.

This is a very common use of bands-just controlling sort order.  You don't
need the headers or spacing.

: Adele



Sun, 24 Nov 1996 21:55:38 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Clipper's driving me crazy, HELP...

2. Clipper's driving me crazy

3. Clipper's driving me crazy

4. I'm not crazy - Startup apps don't start up with SQL 7

5. dumb newbie question - won't take you long

6. newbie's question about 'decode'

7. Can't initialize report if sort on band

8. Can't sort table/report in Opal

9. I'm sure it something simple but it's driving me nuts :-(

10. EM doesn't see drive until it's formatted

11. Error Reading Drive 'X'

12. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************


 
Powered by phpBB® Forum Software