so you have tried:
stringvar array aTest;
aTest := MakeArray ("Hi", "Bye");
If that is not working, I am not sure as that is what Cr help has
Yes, stored procs are SQL...I think of them as batch files for SQL...a series of SQL commands. In addtion, you can create temp tables in a stored proc, which allows for massive flexibility in how you process your data.
Typically, I create 'super' rows of data, which in the case of an invoice might be invoice header and a detail line combined in one line. Or you can return multiple tables and link them in CR...but the bottom line is that you can create a datatable(s) that contains only the information that is needed for the report without additional columns...or with columns that do not exist in the database just for report processing.
Given this, OK, all my reports are written with stored procs as the method that the report gets its data, and after you've done a few, they are really easy to code.
In essence what you do is take all the work that CR needs to do to get the data, off of the application server and place it on the database server which tends to be a more powerful machine and then leave the display of the report to CR.
HTH