[Download-List] MV.ORIENTATION on FORMAT TAB?

[David L. Rotman]

Here are a couple of approaches that will come close to what you are
after:
 
SELECT STUDENTS SAMPLE
DOWNLOAD STUDENTS \
  STU.NAME \
  STU.TERMS NUM.VALUES ALL VALUE.SEPARATOR '<br>' \
  FORMAT HTML \
  FILE ...
 
or
 
SELECT STUDENTS SAMPLE
DOWNLOAD STUDENTS \
  STU.NAME \
  STU.TERMS HTML.ROW 'valign="top"' NUM.VALUES ALL VALUE.SEPARATOR
'<br>' \
  FORMAT HTML \
  FILE ...
 
or

SELECT STUDENTS SAMPLE
SELECT STUDENTS BY @ID BY.EXP STU.TERMS
DOWNLOAD STUDENTS \
  BY.EXP STU.TERMS \
  STU.NAME \
  STU.TERMS \
  FORMAT TAB \
  FILE ...
The first two approaches will stack the terms vertically in the second
column.  The second approach forces Excel to place the student names at
the top of each cell rather than at the bottom.  (At least in my copy of
Excel 2010, the names get placed at the bottom of each cell by
default.)
 
The third approach will place each term on a separate line...but the
student name will be repeated on each line.
 
 
 
 
 
Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
 


>>> On 9/17/2010 at 1:18 PM, in message
<FA49C06155F2244C8DE3593C3AA2A52E097E0072 at RCG2MAIL.mascorcg.net>,
"Robert D. Varju" <Robert.Varju at mascocabinetry.com> wrote:


Perhaps I am missing something obvious.
 
I wish to download a TAB formatted file (for use in a spreadsheet) with
MV.ORIENTATION VERTICAL.  The desired output is that of the FORMAT FIXED
display.  The spreadsheet would appear as follows:
 

Harris, Amy
1998FA

1999G1

1999SP

2000FA

Jones, Thomas
1997SP

2002FA

 

Whenever I use the FORMAT TAB option, the output spreads the MV
attribute horizontally, not vertically.  Please advise.
 

Regards,
 
Robert D. Varju
Sr. Programmer Analyst I - Retail Operations /Costing
 
Masco Cabinetry
robert.varju at mascocabinetry.com ( mailto:laura.jones at mascocabinetry.com
)
15535 South State Ave. 
Middlefield, OH  44062 
tel        440.632.3806 
 
KraftMaid®|Quality Cabinets®|Merillat®|DENOVA®
P Please consider the environment before printing this e-mail.

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20100920/1d7cdbf6/attachment.html>