How to change report columns programatically?
From: <oldorder_at_yahoo.com>
Date: Mon, 17 May 1999 08:38:09 GMT
Message-ID: <7hokhh$2oc$1_at_nnrp1.deja.com>
[Quoted] Is there a way to alter Reports 5.0's report column output using PL/SQL? I'm trying to use a cursor to add a report's column value with another SQL query resultset, and place it in a new column?
Date: Mon, 17 May 1999 08:38:09 GMT
Message-ID: <7hokhh$2oc$1_at_nnrp1.deja.com>
[Quoted] Is there a way to alter Reports 5.0's report column output using PL/SQL? I'm trying to use a cursor to add a report's column value with another SQL query resultset, and place it in a new column?
FOR shipped_row IN shipped LOOP
:MY_COL = (:REQ + shipped_row.sp);
END LOOP;
But Reports Builder reports :MY_COL as a bad bind, though it's in the report
layout.
What is exactly wrong?
Kok Ming
Undergrad Faculty of IT, QUT Brisbane
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 17 1999 - 10:38:09 CEST