Trying to move as much logic as I can to my VServer/VReports using the scripts feature. Not much documentation on SQL with scripts, however. So I need a little help.
Invoice report (grouped by userID and then sorted on userID and sDate(asc)) which can result in numerous pages. For instance, John Doe (userID 1) worked 3 jobs which are all listed on one page. Jane Doe (userID 2) worked 4 jobs and are listed on the second page (report is grouped by userID), etc, for as many individual people within a time frame.
On page pre-build, I have SQL get the nextVal('invoiceNumber') from a table where I manage my sequences. This will be the invoice number for each page, which I assign to a SQL variable. How can I assign that SQL variable to a field on my report?
And secondly, can SQL scripts interact with JS scripts and vice versa?
Thanks,
Scott