Using arrays in QUIZ for dynamic columns (CSV reports)

[Guy Werry]

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/51f6f8e9/attachment-0001.html