RE: Antwort: Multiple Declare Select to the same r eport

Hi ,

 

You can work with the array  load in memory , something like

 

Define array_1 ....

Define array_2 ....

Define array_2 ....

 

Main 

  Start report aa to ...

 

   While ........

         Call fil_arrays( .....)

         Output to report aa(1) 

 

   End while

  

  Finish report 

End main

 

Report aa (x) 

Define x smallint 

 

ORDER EXTERNAL BY x   (this is important ) 

 

On every row 

   ...... Print your arrays --- for loop or whatever .........

 

End report 

 

Thierry Houdu 

 

HF Company 

  _____  

De : Scott Edwards [mailto:[email protected]] 
Envoyé : mardi 22 mars 2005 12:19
À : [email protected]
Objet : RE: Antwort: [fourjs-users] Multiple Declare Select to the same
report

 

Hi There,

 

If I am understanding you correctly this might not work because the 3 arrays
hold quite different information so 3 totally different select and what not.
So does this mean that what I am trying to do is not going to be possible?

 

Regards,

 

Scott

 

  _____  

From: [email protected] [mailto:[email protected]] On
Behalf Of [email protected]
Sent: 22 March 2005 11:01
To: [email protected]
Subject: Antwort: [fourjs-users] Multiple Declare Select to the same report


Hey, 
You can make ONE START REPORT rep1 TO ... 

then you can have 3 different selects in sep. functions f.e. 
In the foreach Statement you have the OUTPUT TO REPORT rep1(val1, val2,
val3, ...) 
be sure that the number and type of columns you send to the report will be
the same in each foreach statement. 

After that you have ONE FINISH REPORT. 

If the number of Columns is different, you can declare some cursor directly
in a report (f.e. in BEFORE GROUP, AFTER GROUP) and print the lines in the
foreach statment 

hth 



Stefan Serwe

KOFU Tiernahrung Kottmann GmbH
EDV-Abteilung
Danziger Strasse 3-5
41460 Neuss
Tel.: +49 2131 181 202
Fax: +49 2131 181 204

  _____  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please 
delete it from your system and notify John Reid & Sons Ltd on +44 1202
483333. You should not copy it or use it for any purpose nor disclose or 
distribute its contents to any other person.