Hello all,
I installed iReport and was making some tests, already create one Report with some parameters that I'm hardcoding when I run the report, I'd like to know how pass this values through APEX, until now I have this:
begin
xlib_jasperreports.show_report ( p_rep_name => 'TESTEREP',
p_rep_format => 'pdf',
p_data_source => 'Kunden',
-- Is this the name of my DB Connection?? Because I don't have a data_source on the iReport
p_out_filename => 'Teste1.pdf',
p_rep_locale => '', -- This value is where the report is saved ??
p_rep_encoding => '', -- This one is like UTF-8?
p_additional_params => :p5_additional_params);
-- What is the sintax to pass the parameters?
-- It's name must be the same of the parameters that i'm receiving at the iReport? Or just the order matters?
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end;
What is necessary to load an image of a BLOB column at the iReport, I tried to open "directly" but it returns me:
oracle.sql.BLOB@1b87a10
Best Regards,
Alan Martini.