This discussion is archived
2 Replies Latest reply: Nov 15, 2013 10:11 PM by Priyasagi RSS

How to Use Temporary table on report builder

5d02e924-c0cd-41fd-99b7-799311491075 Newbie
Currently Being Moderated

Hi community!

Well, i'm trying to build a temporary table based report in Oracle Report Builder. in "After Parameter Form Trigger" I've placed a stored procedure that populate a temporary table and I've based my report on it. The problem is Report shows no data. When i execute this procedure directly on database and i perform a select on my temporary table, it show all inserted data.

 

I hope somebody can to help me because I tried many ways to build this report with my temporary table and always looks blank.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points