<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Using arrays in QUIZ for dynamic columns (CSV reports)</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>Quiz states that syntax ‘report all’
will report all items in the repeating field, which leads me to believe/assume
that syntax ‘report summary all’ will do the same thing when
reporting to a subfile – try it and see.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>As for the 255 quiz report limit, this is
only relevant when writing reports – if you use quiz to write to a
subfile you can write up to 1023 items , each of up to 2047 chars in size.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>To reference a specific array item for
addition to a subfile you have to use a define item e.g. ‘def dn datatype
dets… = array_item(n)’<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>fernando.olmos@hpa.com.au<br>
<b><span style='font-weight:bold'>Sent:</span></b> 20 September 2006 02:01<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> Using arrays in QUIZ for
dynamic columns (CSV reports)</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi</span></font>
<o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
am reading up on QUIZ's manual on arrays (very little info actually) and I need
some help.</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
am trying to create a CSV QUIZ report, where the number of columns in the
report is dynamic (from 1 to 'n').</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks</span></font>
<o:p></o:p></p>
<p><i><font size=4 color=blue face=Arial><span style='font-size:13.5pt;
font-family:Arial;color:blue;font-style:italic'>Fernando Olmos</span></font></i>
<br>
<b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>MIS</span></font></b> <br>
<b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>Senior Analyst Programmer</span></font></b> <o:p></o:p></p>
<p><b><font size=2 color=blue face=Arial><span lang=EN-AU style='font-size:
10.0pt;font-family:Arial;color:blue;font-weight:bold'>HPA</span></font></b><font
face=Arial><span lang=EN-US style='font-family:Arial'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Direct: 03 9217
5411</span></font><span lang=EN-US><br>
</span><st1:City w:st="on"><st1:place w:st="on"><font size=2 color=black
face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:Arial;
color:black'>Mobile</span></font></st1:place></st1:City><font size=2
color=black face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:
Arial;color:black'>: 0410 382 857</span></font><font face=Arial><span
lang=EN-US style='font-family:Arial'><br>
</span></font><font size=2 color=black face=Arial><span lang=EN-AU
style='font-size:10.0pt;font-family:Arial;color:black'>Fax:
03 9217 5716</span></font><span lang=EN-AU> </span><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><a
href="file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au"><b><font size=2
face=Arial><span lang=EN-AU style='font-size:10.0pt;font-family:Arial;
font-weight:bold'>www.hpa.com.au</span></font></b></a> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<pre><font size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>IMPORTANT<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>The contents of this e-mail and its attachments are confidential and intended<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>solely for the use of the individual or entity to whom they are addressed. If<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>then delete the e-mail.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>This footnote also confirms that this e-mail message has been swept for the<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>presence of computer viruses by Ironport. Before opening or using any<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>attachments, check them for viruses and defects.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Our liability is limited to resupplying any affected attachments.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>HPA collects personal information to provide and market our services. For more<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>information about use, disclosure and access see our Privacy Policy at<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>www.hpa.com.au<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>**********************************************************************<o:p></o:p></span></font></pre></div>
</body>
</html>