RE: Columns in printouts

[Al Mac <macwheel99@xxxxxxxxxxx>]

Oh Man, so obvious, yet I was oblivious to this.
Thankyou Thankyou ... I have more of this coming up with end fiscal month 
this weekend.

> Copy the file from ops navigator onto your PC, My documents for ease of 
> use, then import it into word or excel, in excel you can sort the report 
> by one of the columns which will leave all of the headers together and 
> then you can remove all of the headers bar one.
>
>
> Regards
>
> Steve Dodkins
>
> ebm-papst (UK) Ltd
>
> Tel: 01245468555
>
> www.ebmpapst.co.uk
>
>
> -----Original Message-----
> From: Al Mac
> Subject: Re: Columns in printouts
>
> Check the archives for past threads of relevance, such as low cost shareware.
>
> What I do is OPS NAV spool file to text folder, then use Excel Wizard to 
> import the text file.  My problem is my bosses do not want the headers 
> repeating, so I have to manually remove them, which can be a pain for a 
> huge report.
>
> I also use Cut / Paste (see CA Edit with append option) from View a report 
> from spool, to e-mail in which I put the paste in quote's to make it 
> easier to use a proportional font just on the pasted, and sometimes 
> smaller to eliminate wrap-around.
>
> When I send people the raw text file, I advise them to use Landscape on PC 
> printer.
>
> >Does anyone know how to cut and paste a report from the iSeries to Word
> >or Excel and retain the columns???
> >
> >thanks,
> >
> >Clare