alexandre.massy

Hi everyone, I would like to use the RESTFul Service of APEX in order to schedule a JasperReports Server report and save it on the server. I've read the guide and tried to implement the Restful Services Reference in order to try this, but I just can't get anything working and I don't really know how it works (can't find any help on the Internet). In fact, the user should be able to click a button on the APEX page to launch the report and save it on the server, automatically. If there is any other way than using APEX Web Services and JRS Scheduling I'm on it (and if it is possible to auto print it, it would be great too ...). Hope anyone as a clue. AM

Hi, I'm trying to populate a global temporary table with a stored procedure (Oracle) before reporting in JasperSoft Studio so I can have some subreports using that filled temp table. This stored procedure looks like this : CREATE OR REPLACE PROCEDURE EXEC_TMPTABLE (pdate IN DATE) AS BEGIN package.init_tmptable; package.procedure1(pdate): package.procedure2(pdate); package.procedure3(pdate); commit; END;I tried to put some pl/sql to call this stored procedure : {call EXEC_TMPTABLE($P{DATE}) } After the call, I'll have to call several subreports that will use the previously filled temp table. Unfortunatly, I keep having a blank document and nothing comes out. Does anyone have an idea ?