Formatting reports for Excel

Shah, Roshan (Windsor, HQ) shahro01@unisourcelink.com
Fri, 29 Jan 1999 09:14:38 -0500 

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------ =_NextPart_001_01BE4B91.FD05A760
Content-Type: text/plain;
	charset="iso-8859-1"

We use REVEAL to do it. From REVEAL the user can download the file in
the format they want. We do not have to download the report and send it
via e-mail to them.....


Roshan Shah
PRI Consultant to IBM
------------------------------------------------------------------------
--------------------------------------------------------
| Switchboard : 860-298-3200 Xn : 3144                   |    EDI / Data
Warehouse /  |
| DID              : 860-298-3144, 860-298-6706            |     Year
2000 / C / C++ /     |    
| FAX              : 860-298-3164                                    |
COBOL / HTML              |
| Internet         : shahro01@unisourcelink.com           |
POWERHOUSE / HP3K |
------------------------------------------------------------------------
-------------------------------------------------------

> ----------
> From: 	Taber, Phil[SMTP:prta@lubrizol.com]
> Sent: 	Friday, January 29, 1999 8:38 AM
> To: 	'Chris Sharman'; powerh-l@lists.swau.edu
> Subject: 	RE: Formatting reports for Excel
> 
> 	Insert the following lines before your report statement in quiz:
> 	define Asc_009 int*3  = 009 
> 	define T       char*1 = character(Asc_009)
>      
> 	then within the report statement, do NOT use any TAB statements,
> rather just insert the variable T between each item you want to form a
> column on your spreadsheet.  You need to also do this on the page
> header
> between column headings (do not use KEEP COLUMN HEADINGS, rather hard
> code
> them with the T between each header).
> 	Also insert a 
> 	set page width 250 length 0 
> 	command to keep from getting multiple page headings within the
> document.  
> 	Set output to a disk file (set report device disc name fred)
> 	You then can import the fred.txt file into excel as a tab
> delimitted
> file and it will load properly.
> 
> 
> 	-----Original Message-----
> 	From:	Chris Sharman
> [SMTP:Chris.Sharman%ccagroup.co.uk@interlockp.lubrizol.com]
> 	Sent:	Thursday, January 28, 1999 9:42 AM
> 	To:	powerh-l%lists.swau.edu@interlockp.lubrizol.com
> 	Cc:	Chris.Sharman%ccagroup.co.uk@interlockp.lubrizol.com
> 	Subject:	Formatting reports for Excel
> 
> 	Does anyone have any useful tips or tools for re-formatting text
> for
> Excel ?
> 	The reports (done in Powerhouse Quiz) look fine on a VT or to
> print,
> but
> 	oh-so-clever Excel has its own ideas about how to lay it out.
> 
> 	'Sparse' reports with many cells left blank seem to be a
> particular
> problem,
> 	in that blanks seem to get removed.
> 
> 	Someone mentioned rich text: would it help ? Is there an encoder
> for
> VMS ?
> 	Or is there a way to provide hints to Excel along with the
> reports,
> so that
> 	it goes straight into Excel all pretty, rather than needing lots
> of
> manual
> 	adjustment.
> 
> 	I could turn it all into comma separated quoted text, but that's
> fairly
> 	tedious, and makes the report pretty unreadable except via a
> spreadsheet.
> 	I'd really like a report readable to both humans & Excel.
> 
> 	Excel is the customer's choice, not mine, so I can't use a
> Powerhouse PC
> 	product instead: the reports are done overnight & emailed to the
> customer
> 	who wants to look at them with Excel first thing Monday morning.
> 
> 	Thanks
> 	
> ______________________________________________________________________
> 	Chris Sharman			Chris.Sharman@CCAgroup.co.uk
> 	CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2
> 9WS.
> 	= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> = = = =
> 	Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> 	Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> 	powerh-l@lists.swau.edu is gatewayed one-way to
> bit.listserv.powerh-l
> 	This list is closed, thus to post to the list, you must be a
> subscriber.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a
> subscriber.
> 

------ =_NextPart_001_01BE4B91.FD05A760
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



RE: Formatting reports for Excel




We use REVEAL to do =
it. From REVEAL the user can download the file in the format they want. =
We do not have to download the report and send it via e-mail to =
them.....





Roshan Shah

PRI Consultant to =
IBM

-----------------------------------------------------------------=
---------------------------------------------------------------


| Switchboard : 860-298-3200 =
Xn : =
3144           &n=
bsp;       |    EDI / Data =
Warehouse /  |

| =
DID           &nb=
sp;  : 860-298-3144, =
860-298-6706          =
  |     Year 2000 / C / C++ =
/     |    

| =
FAX           &nb=
sp;  : =
860-298-3164          =
            =
            =
  |     COBOL / =
HTML           &n=
bsp;  |

| =
Internet         : =
shahro01@unisourcelink.com       &nbs=
p;   |     POWERHOUSE / HP3K |

-----------------------------------------------------------------=
--------------------------------------------------------------



------ =_NextPart_001_01BE4B91.FD05A760--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.