Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Subreports with Balanced Snaking Columns

Status
Not open for further replies.
May 7, 1999
130
US
Hi!

I have a report that will consist of multiple subreports. However, the cover page is giving me fits. It consists of the following information:
* Title... that's easy enough
* Index... major headings with associated page number ranges to identify start and end of major grouping names (name of sorted field)
* Subscribers' List... names in order by "last name, first name"
Not quite sure how to generate the actual index, but the real problem is that I want the index to consist of two columns, each with major grouping name and page ranges one the same line snaked into the two columns.

It would look something like this:

Code:
Apples      1-2        Pears     11-15
Biscuits      3        Raisins   16-18
Carrots     4-5        Tomatoes     19
Dog Food   6-10

And the subscriber's list would be similar, except that there are give columns of the sort:

Code:
Andrews, Julia    JA    Edwards, Martha   ME   Irving, Thomas    TI
Baker, Richard    RB    Fetter, Mary      MF   Jenner, Bill      BJ
Catawba, Susan    SC    George, Joseph    JG   ...etc.
Douglas, Arthur   AD    Howell, Jane      JH

I can get snaking to work when the report is the only subreport on a page, but when I haven't figured out how to force snaking and balanced columns (equal numbers of entries in a column of a subreport) at the same time!

Thanks!
John Harkins
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top