R/Basic and the Banded Report Writer - Arev 3.12 (AREV Specific)
At 30 NOV 1997 03:08:19AM John Kapaona wrote:
I have written several R/Basic subroutines for
use with collector windows to display certain
criteria for reporting. Does anyone know how
to show your information in a banded report?
It's much nicer than R/List.
Any Help is appreciated.
Happy Holidays
John @ NuWare
At 01 DEC 1997 08:17AM Don Bakke wrote:
John,
I have written several R/Basic subroutines for use with collector windows to display certain criteria for reporting. Does anyone know how to show your information in a banded report? It's much nicer than R/List.
I'm not sure exactly what this criteria is used for, but if you want to launch a pre-defined banded report from R/Basic just use a line like this:
Perform "RUNREPORT REPORTNAME (P"If you have any active select lists this will take advantage of them. If you need to modify the structure of the banded report then you could open the record up and make your changes and then call the above code.
Does that help?
At 11 DEC 1997 09:25AM Larry wrote:
John,
Maybe you are referring to how to pass the variables you collect in your window to the report itself. Such as:
Window prompt for Date Range _
User answers : 1/1/97 -] 6/1/97
How to pass the "1/1/97 -] 6/1/97" to the report so it shows in the header?
I could never find how to get RLIST or the Banded Report Writer to print a variable like that. So I created a little function that puts up to 10 variables in an AREV table. So your RBASIC program calls the function to load the report-variable table with all the variables you want to display on the report. Then, you just put the fields from the report-variable table on the report. The report-variable table is keyed with the username+report name for multi-user security.
Being a new user of AREV, and not finding much support in the manuals or anywhere else, this is what I came up with. I would be glad to hear from anybody who knows of an easier solution. If anybody wants the code, I would be glad to share it.