Quiz Page width problem

[Chris Sharman]

Tim Cummings wrote:
> I have run into this before, you can use QTP and create your header with 
> one output and append the details with another.  You might also try 

Using a subfile as someone else mentioned - although Quiz is at least as 
able as QTP for this (using a preliminary pass and set noclose), and 
therefore preferable for performance reasons. This is our method of 
choice (with or without headings), mainly because it looks best to the user.

The alternative (using a multiline report) won't work when the 
individual fields exceed 255, but will when the line does. Enclose the 
line breaks in quotes to have Excel treat them as field contents.

It's all a bit messy whatever you do, and will only get worse as more 
and more people regard excel import, and wider reports, as the report 
format of choice.

I can't believe that fixing Quiz (to page width 511 or 32k or whatever, 
and making page length 0 work correctly) is all that difficult for Cognos.

Chris

> -----Original Message-----
> From: Seamus Browne [mailto:Seamus.Browne@partage.org]
> Sent: Monday, March 15, 2004 11:34 AM
> To: powerh-l@lists.sowder.com
> Subject: Quiz Page width problem
> 
> 
> Hi,
> I'm having problem exporting a long field from Quiz on to my disc.
> I'm on a HP3000 and I want to create a file in CSV format.
> Trouble is that the length of my field is about 500 characters.
> 
> This is it
> 
> 
> def header char *  508 =      &,
> Pack ("PATNUM" + ";" +        &,
>       "PATRAI" + ";" +        &,
>       "PATNOM" + ";" +        &,         etc..
> 
>  
> Then :
> def packet char * 508 =                  &,
> 
> Pack (asc(PATNUM)   + ";" +     &,
> 
>        PATRAI       + ";" +     &,
> 
>        PATNOM       + ";" +     &,  etc
> 
>     
> Then  :
> 
> :purge lftest
> :build lftest ;rec=-512,,f,ascii
> set rep dev disc name lftest
> 
> That part seems OK.
> 
> Then I do
> 
>  init head header
>  set page len 0
>  set rep spa  0
>  rep packet
>  go
> 
> I get this message from QUIZ
> *E* Can't report an element exceeding PAGE WIDTH specification.
> 
> Limit seems to be 256.
> Any way round this ?
> 
> TIA
> 
> Seamus
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to 
> powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> 



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.