March 21st, 2007, 09:36 AM
|
#1 (permalink)
|
| Caveat Emptor
Join Date: Mar 2005 Location: Out of my mind
Posts: 3,241
| Any XML Publisher Guru's out there?
Looks like our shop will be moving away from SQR programs to XML Publisher. I get assigned the fun task of doing this. No training of course
SQR was a C-like language that allowed you to embed SQL in it..for example Code: Begin-Procedure New-Hires
Begin-Select
emplid,
last_name,
first_name
let $name = &last_name || ',' || &first_name
let $emplid = rtrim(&emplid, ' ')
do Print-Employee-Detail-Line
from employee_table
where hire_date >= '2007-01-01'
End-Select
End-Procedure New-Hires What was nice about this is you could call other routines in a result set (like above), do all kinds of calculations and other neat stuff and create some really cool reports, and most importantly in my job, DATA FILES!
I'm ok with generating a simple report via XML, I just wonder if someone can point me to how one creates data files |
| |