PDA

View Full Version : Pick up variables from reports?


ABC123

Keith George
07-04-2000, 01:36 PM
I would like to print a report consisting of summary fields created in other reports.

Can I print reports to screen/file and somehow have Alpha, read the summary fields required into variable’s, then can I create a report with a title and all the variables?

TIA

Keith

csda1
07-05-2000, 08:06 PM
Keith,

It's been awhile since I tried this, but I believe that you can run a report to the end on the screen, and just before you do the final F10, you can take the values that you have created in Calculated fields and Summary Variables and reference them.

Of course, you can also use
Other, Information, Field Statistics,
DBSUM() and similar,
and a variety of Crosstab and summary operations to do the results faster in many cases.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
csda@mediaone.net

Gary Smith
07-05-2000, 08:26 PM
Keith,
Attached is a zip file that demonstrates 2 different ways to capture summary values in a report. Run the method1 and method2 scripts.
Gary

Keith George
07-06-2000, 12:05 PM
Thank you Ira & Gary, I have printed your answers and will look at both methods.

I "will" be back ;-)


Regards,
Keith

PS
I'm not sure if this is the way to reply to more than one person!!!