We are presently extensively using Jasper Reports Studio 6.16 and JR Server installed at Maxapex.
Insert SYSDATE in report:
1. define a variable
2. enter in "expression" : new SimpleDateFormat("dd/MM/yy").format(new Date())
3. put the variable as a field on the report
or try to insert from the "Current Date" from the "Composite Elements" (right hand).
a textfiled will be generated [new java.util.Date()] and the standard format (pattern) is: MMMMM dd, yyyy
if you like adjust the date format, you can use --> Textfield --> pattern --> and an editor can be opened and you may choose from various formats
Generic procedure:
in my previous project I always had defined the pl/sql process on respective pages - now, as we will have more reports to produce I have defined a generic procedure in the database reading as follows:
CREATE OR REPLACE PROCEDURE JASPER_GENERIEREN
(
Q_PARAMETER IN VARCHAR2, -- used for ID of a dataset
REPORT_NAME in VARCHAR2 -- used for the report name
) AS
l_additional_parameters varchar2(100);
begin
-- set the url for the j2ee application
-- better retrieve that from a configuration table
-- xlib_jasperreports.set_report_url(:G_REPORT_URL);
xlib_jasperreports.set_report_url('jasper.maxapex.net:8090/JasperReportsIntegration/report');
-- construct addional parameter list
l_additional_parameters :='PARAMETER01='||PARAMETER01;
-- call the report and pass parameters
xlib_jasperreports.show_report (
p_rep_name => 'XXXXXX/'||REPORT_NAME, -- Replace your Workspace name
p_rep_format => 'pdf',
p_data_source => 'XXX_A123456_1234', -- REPLACE !!
p_out_filename => 'Dokument_'||REPORT_NAME||'.pdf',
-- p_rep_locale => 'de_DE', -- this is optional
-- p_rep_encoding => 'UTF-8', -- this is optional
p_additional_params => l_additional_parameters);
-- stop rendering of the current APEX page
apex_application.g_unrecoverable_error := true;
end JASPER_GENERIEREN ;
Within the APEX page no. 16 I defined a button, which calls the pl/sql process namely:
JASPER_GENERIEREN(:P16_ID,:P16_AMS_DOK_NR);
on the page it looks like:
Assuming one like to save the report in a table straight away.... - the next tipp will contain that procedure...
