home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!caen!zaphod.mps.ohio-state.edu!pitt.edu!field
- From: field@.cs.pitt.edu.cs.pitt.edu (Brian Field)
- Newsgroups: comp.databases
- Subject: paradox reports questions
- Message-ID: <1661@blue.cis.pitt.edu>
- Date: 11 Jan 93 15:54:15 GMT
- Sender: news+@pitt.edu
- Organization: Univ. of Pittsburgh Computer Science
- Lines: 41
- X-Newsreader: Tin 1.1 PL3
-
-
- Couple questions regarding reports in Paradox. These are more or less
- all from a single report I would like to generate. (This report lists
- names of people by department. I would like the names listed in two
- columns, alphabetic down each column.)
-
- 1) Can the "CC" and "CL" format strings be combined into a single
- format statement? I am using this in a calculated field. I need to
- display names, and would like the first letter capitalized with the
- remaining letters lower case. Combinations of format ("CC,CL", ...) and
- format ("CL,CC", ...) don't yield the desired results. Currently, I am
- doing format ("CC", format ("CL", ...)). Is there a better way to do
- this?
-
- 2) Is there a way to specify a group band, but have the group be itemized
- independent of case?
-
- 3) Can counting in a report be done based on an outer group? I.e.
- group band A
- group band name
- #rec name
- group band name
- group band A
-
- I would like the names alphabetized, but to incrementally number
- them within each group A item. When I add the #rec field, it
- assumes that it is numbered by the inner-most group.
-
- 4) Are mailing labels the only way to generate two column output in a
- report?
-
- If yes, is there a way to get mailing labels ordered down the column
- instead of across rows?
-
- If no, what are the alternative(s)?
-
-
- Please e-mail (field@cs.pitt.edu) responses, and I'll summarize if there is
- interest.
-
- Brian
-