Report builder Question?

Yahoo Archive
1
If you could somehow assign each record a record#, then you could do a
calculated field using
iif(Recno = 1, 0, (Recno - 1) MODULO (#of columns)), then sort by the
calculated field and Recno.
This would sort the records such that for columns=3; records 1,4,7...
would =0; records 2,5,8..=1... effectively transposing the rows into
columns. Like Wayne, I have not figured out how to assign a record #.
Regards
Jim Stetter


-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, August 31, 2000 2:39 PM
To: vantage@egroups.com
Subject: Re: [Vantage] Report builder Question?


At 02:24 PM 8/31/2000 , you wrote:
>Select properties, Record Layout, Records across, enter number of
records

He's trying to get it to fill the columns first.

I tried to come up with some algebraic tricks to stuff into a calculated
field that could be sorted on, but didn't have any luck (at least in the
time available today.)

-WC





[Non-text portions of this message have been removed]
2
Select properties, Record Layout, Records across, enter number of records

Jeff Myers

Rubberasc@... wrote:

>
> I am trying to generate a report that prints in multiple vertical columns such as below.
>
> 1 6 11
> 2 7 12
> 3 8 13
> 4 9 14
> 5 10 15
>
> The formating under PAGE setup only permits horizontal rows such as:
>
> 1 2 3 4 5
> 6 7 8 9 10
> 11 12 13 14 15
>
> Are there any slick methods out there to get what I'm after.
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
3
Select properties, Record Layout, Records across, enter number of records


The format above generates the example below.
>
> The formating under PAGE setup only permits horizontal rows such as:
>
> 1 2 3 4 5
> 6 7 8 9 10
> 11 12 13 14 15


I'm trying for:
> 1 6 11
> 2 7 12
> 3 8 13
> 4 9 14
> 5 10 15


Shirley Graver
Sys Admin
Cleveland/Akron
4
At 02:24 PM 8/31/2000 , you wrote:
>Select properties, Record Layout, Records across, enter number of records

He's trying to get it to fill the columns first.

I tried to come up with some algebraic tricks to stuff into a calculated
field that could be sorted on, but didn't have any luck (at least in the
time available today.)

-WC