<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Using arrays in QUIZ for dynamic columns (CSV reports)</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=664480513-20092006>Fernando,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=664480513-20092006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=664480513-20092006>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).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=664480513-20092006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=664480513-20092006>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=664480513-20092006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=664480513-20092006>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=664480513-20092006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=664480513-20092006>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf Of
</B>fernando.olmos@hpa.com.au<BR><B>Sent:</B> Tuesday, September 19, 2006 8:01
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Using arrays in
QUIZ for dynamic columns (CSV reports)<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi</FONT> </P>
<P><FONT face=Arial size=2>I am reading up on QUIZ's manual on arrays (very
little info actually) and I need some help.</FONT> </P>
<P><FONT face=Arial size=2>I am trying to create a CSV QUIZ report, where the
number of columns in the report is dynamic (from 1 to 'n').</FONT> </P>
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><I><FONT face=Arial color=#0000ff size=4>Fernando Olmos</FONT></I>
<BR><B><FONT face=Arial size=2>MIS</FONT></B> <BR><B><FONT face=Arial
size=2>Senior Analyst Programmer</FONT></B> </P>
<P><SPAN lang=en-au><B><FONT face=Arial color=#0000ff
size=2>HPA</FONT></B></SPAN><B><SPAN lang=en-us></SPAN></B><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial color=#000000 size=2>Direct: 03 9217 5411</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial color=#000000 size=2>Mobile:
0410 382 857</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial><BR></FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Fax: 03 9217 5716</FONT><FONT
face=Arial></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> </SPAN></P>
<P><SPAN lang=en-au></SPAN><A
href="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN
lang=en-au></SPAN><SPAN lang=en-au><U></U></SPAN><SPAN lang=en-au><U><B><FONT
face=Arial color=#0000ff size=2>www.hpa.com.au</FONT></B></U></SPAN><SPAN
lang=en-au></SPAN></A><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN> </P><BR><PRE>**********************************************************************
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@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
**********************************************************************
</PRE></BLOCKQUOTE></BODY></HTML>