Unanswered: Getting data in Report Builder from Global Temporary Table
is there any person help me regarding Global Temporary Table.
the problem i am facing is that. when i create global temporary table & after inserting data into the table , and after calling a report from the Form Builder 6 . it does'nt show any record in the Report Builder 6.
as long as i remain in the form builder 6, it shows the records on the screen. when i call report in the same session , it deletes all records from table.
i could'nt understand this mechanism.
i think it expire the user session when we call report from the form directly.
if this is due to this problem , then how can we resolve this situation.