Another newbie problem:
I have a report that calls an Oracle stored procedure. The query in the stored procedure returns two record types. Only one row is of the first type; the values in which I want displayed only on the header. The second record type may consist of several rows which I want displayed on the detail section of the report.
An example query:
SELECT 1 AS RECORD_TYPE,
first_name, --name of user requesting the report
last_name --to be shown on the header
FROM users
WHERE userid = <passed to the sp>
UNION ALL
SELECT 2,
first_name,
last_name
FROM employee;
I tried working with Section Expert and Selection Expert but neither provided a way to do what I wanted.
Is there a way to do it in CR?
Thanks,
Arnel