Skip to Content
0
Former Member
Jul 17, 2008 at 03:37 PM

Selecting Records for Specific Report Section

22 Views

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