Using arrays in QUIZ for dynamic columns (CSV reports)

[Joe Boyle]

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.

 

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.

 

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)'

 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
fernando.olmos at hpa.com.au
Sent: 20 September 2006 02:01
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/10a761fa/attachment.htm