Using arrays in QUIZ for dynamic columns (CSV reports)

[Ken Langendock]

The only way you can achieve what you want is to use QUICK in BATCH.
 
Quick is the only tool that you can say FOR n...do this, that and the
other thing.
That way you could 'pack' (not the correct syntax) the items in an array
together with the separation character.
BTW, I use the "|" as a separation character in a CSV file as users have
a tendency to insert a comma in the data fields.
 
Ken
 
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Guy Werry
Sent: September 20, 2006 9:19 AM
To: powerh-l at lists.sowder.com
Subject: RE: Using arrays in QUIZ for dynamic columns (CSV reports)


Fernando,
 
Is this as simple as having a large number of columns with a BWZ (Blank
When Zero) clause?  That way you could have dozens of columns, that
would only display when there was data in them.  (This is harder for
TEXT, each field would probably require a define).
 
One large fly in that ointment is that if something is SUPPOSED to be
ZERO and has to be displayed like that, you're screwed.
 
Hope this helps.  I've tried arrays in Powerhouse and found that they're
really not worth using ... doesn't handle them well at all.
 
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
fernando.olmos at hpa.com.au
Sent: Tuesday, September 19, 2006 8:01 PM
To: powerh-l at lists.sowder.com
Subject: Using arrays in QUIZ for dynamic columns (CSV reports)



Hi 

I am reading up on QUIZ's manual on arrays (very little info actually)
and I need some help. 

I am trying to create a CSV QUIZ report, where the number of columns in
the report is dynamic (from 1 to 'n'). 

Anyone have any examples of QUIZ reports where such a possibility was
achieved using arrays? Otherwise I may have to bite the bullet and say
to the client, look you have up to 30 columns available and if you want
more, then we'll have to change the report. If you take away columns in
the database, then we'll also have to change the report. In fact if they
do anything to the table that will be used to load the array, we'll have
to change the report because each column is hard coded, whether you use
it or not. I am trying to avoid these limitations on my client.

Thanks 

Fernando Olmos 
MIS 
Senior Analyst Programmer 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> www.hpa.com.au



**********************************************************************

IMPORTANT

The contents of this e-mail and its attachments are confidential and
intended

solely for the use of the individual or entity to whom they are
addressed.  If

you received this e-mail in error, please notify the HPA Postmaster,
postmaster at hpa.com.au,

then delete  the e-mail.

This footnote also confirms that this e-mail message has been swept for
the

presence of computer viruses by Ironport. Before opening or using any

attachments, check them for viruses and defects.

Our liability is limited to resupplying any affected attachments.

HPA collects personal information to provide and market our services.
For more

information about use, disclosure and access see our Privacy Policy at

www.hpa.com.au

**********************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060920/1785eb46/attachment.htm