<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Discussion</title><link href="https://sourceforge.net/p/jrprintserver/discussion/" rel="alternate"/><link href="https://sourceforge.net/p/jrprintserver/discussion/feed.atom" rel="self"/><id>https://sourceforge.net/p/jrprintserver/discussion/</id><updated>2017-09-12T13:23:09.425000Z</updated><subtitle>Recent posts to Discussion</subtitle><entry><title>Display of numbers in Report (Number Format)</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/6c994dc2/?limit=25#2038" rel="alternate"/><published>2017-09-12T13:23:09.425000Z</published><updated>2017-09-12T13:23:09.425000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net637fe9fd631ce6d9efa52c11bcaa895f6c298e4e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Peter,&lt;/p&gt;
&lt;p&gt;first thing you have to know how your number are serialized into the data XML.&lt;br/&gt;
I.e. you have to know is the decimal separator a dot (US style) or a comma (German style) etc.&lt;br/&gt;
In your Report Query in APEX you can achieve a specific number format with the to_char function.&lt;br/&gt;
For example to use a dot:&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;select to_char(my_number_col, '99999999999.09999999'), ...
from   ...
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;Now to tell JR PrintServer how to transform the strings from the data XML for your fields that have a Java number type (i.e. BigDecimal), you have to specify the correct "xmlLocale" in your Report Template. (See the wiki page &lt;a href="https://sourceforge.net/p/jrprintserver/wiki/APEX%20Report%20Layouts%20for%20the%20JR%20PrintServer/"&gt;https://sourceforge.net/p/jrprintserver/wiki/APEX%20Report%20Layouts%20for%20the%20JR%20PrintServer/&lt;/a&gt;).&lt;/p&gt;
&lt;p&gt;In this case (dot) we should specify en_US. (This is also the default, if you don't specify this.)&lt;/p&gt;
&lt;p&gt;This should allow the correct data type conversion from the string contents of the data XML into Java number data types (this controlled by the settings xmlLocale and numberFormat in the Report Template).&lt;/p&gt;
&lt;p&gt;How you want to display Fields values inside your report is controlled by the "reportLocale" setting (this may differ from the xmlLocale setting).&lt;br/&gt;
This way you could have your number in US style (xmlLocale = en_US) inside the XML, but display them in your report nicely (with Java number formats) in German style (reportLocale = de_DE).&lt;/p&gt;
&lt;p&gt;Regards,&lt;br/&gt;
Michael&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Display of numbers in Report (Number Format)</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/6c994dc2/?limit=25#a116" rel="alternate"/><published>2017-09-11T12:38:22.521000Z</published><updated>2017-09-11T12:38:22.521000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net3ebe85c8b13c4286a460c5fdedd984ce6327544d</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Michael,&lt;/p&gt;
&lt;p&gt;We are facing some issues ragarding number values in the report.&lt;/p&gt;
&lt;p&gt;Numbers (with 2 numbers after the decimal point) are displayed without decimal seperator in the report.&lt;br/&gt;
==&amp;gt; 2,45 wil be displayed as 245&lt;/p&gt;
&lt;p&gt;The format of the XML data source is set to: java.math.BigDecimal but it does not work.&lt;/p&gt;
&lt;p&gt;If we just set the data type to string it shows correctly but it's hard to have conditional styles implemented.&lt;/p&gt;
&lt;p&gt;Also, how can we configure how the decimal setting is used (e.g. English / German) ?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Support for Translation Bundle</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/0aac8596/?limit=25#0aac" rel="alternate"/><published>2017-09-11T10:39:36.488000Z</published><updated>2017-09-11T10:39:36.488000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net16a951f6f013c67faf24dec27772cd3a10f3551e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Michael,&lt;/p&gt;
&lt;p&gt;Thanks for the reply, will try it and get back to you.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Support for Translation Bundle</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/0aac8596/?limit=25#b17c" rel="alternate"/><published>2017-09-09T13:05:21.144000Z</published><updated>2017-09-09T13:05:21.144000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net05824521af2e8bed28f55f58d0313c32151fcc21</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Peter,&lt;/p&gt;
&lt;p&gt;I guess you mean that yopu want to use a "Resource Bundle" containing translation strings that you want to use inside your report with "$R{...}".&lt;br/&gt;
That should work.&lt;br/&gt;
I.e., if you have specified in your jrxml the following:&lt;/p&gt;
&lt;p&gt;&lt;code&gt;&amp;lt;jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Departments" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" resourceBundle="project2/resources/Departments" whenResourceMissingType="Key" uuid="dbe7c04b-5ec9-4c69-bcb1-ce722659dd47"&amp;gt;&lt;/code&gt;&lt;/p&gt;
&lt;p&gt;Consider the resourceBundle attribute. It's set to "project2/resources/Departments".&lt;br/&gt;
This means that you have to place your resources files into a "resources" directory that is placed in a "project2" directory inside your configured reportPath directory.&lt;/p&gt;
&lt;p&gt;The resource files must have specific file names.&lt;br/&gt;
I.e.:&lt;br/&gt;
"Department_de_DE.properties" for German (Germany), "Department_de_AT.properties" for Germn (Austria)", "Department_fr" for French etc., and finally a default "Department.properties".&lt;/p&gt;
&lt;p&gt;Hope this helps.&lt;/p&gt;
&lt;p&gt;Regards,&lt;br/&gt;
Michael&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Support for Translation Bundle</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/0aac8596/?limit=25#f512" rel="alternate"/><published>2017-09-08T13:52:14.391000Z</published><updated>2017-09-08T13:52:14.391000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net02d6c8eee2a02e3d9eec51b3ed36cdc8436f52ed</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;is it possible to support Translation Ressources? I implemented it in the report and it works fine wiht JR Studio. When I upload all the report files incl. the TranslationResources.properties files it does not render saying it can not find the ressource files even thou they are in the correct directory.&lt;/p&gt;
&lt;p&gt;thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>java.lang.NullPointerException</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/00563cd3/" rel="alternate"/><published>2016-06-28T11:27:59.320000Z</published><updated>2016-06-28T11:27:59.320000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.nete9caa533e429b30c9c4dc21594fac92feebada1e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Yes, this Tomcat log looks just fine.&lt;br/&gt;
Please see also, my further comments above.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>java.lang.NullPointerException</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/00563cd3/" rel="alternate"/><published>2016-06-28T11:13:19.641000Z</published><updated>2016-06-28T11:13:19.641000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.nete9dfdfec67339e373a4412210879d851d0dc87aa</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Sebastian,&lt;/p&gt;
&lt;p&gt;nice to hear that we are moving forward.&lt;/p&gt;
&lt;p&gt;Now to your button: make sure that the button &lt;em&gt;submits the page&lt;/em&gt; so that you get into the Page Processing of your page.&lt;br/&gt;
There you should define a &lt;em&gt;PL/SQL process&lt;/em&gt;. I would code it this way:&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;declare
  l_blob blob;
begin
  l_blob := apex_util.get_print_document(
              p_application_id    =&amp;gt; :APP_ID, /* Never hard code an application id */
              p_report_query_name =&amp;gt; 'ew-test');
  --
  jrpserver.download(l_blob, 'ew-test', jrpserver.pdf /* Better to use the defined constant */);
  apex_application.stop_apex_engine;
end;
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;Now when you click the button the page should get submitted and as a reply you should get a File Save dialog or your browser may be able to display the prodeced PDF directly.&lt;/p&gt;
&lt;p&gt;I suppose that you get the JSON error because for whatever reason your button did not submit. Moreover, don't use a DA that executes PL/SQL code on button click - this does not work.&lt;/p&gt;
&lt;p&gt;Regards,&lt;br/&gt;
Michael&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>java.lang.NullPointerException</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/00563cd3/" rel="alternate"/><published>2016-06-28T10:28:29.623000Z</published><updated>2016-06-28T10:28:29.623000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net2e1221b3562bbbce40db786da6ad1e2933d866d1</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Ups have forgotten the Tomcat log - still looks good? But the file save dialog not comes up ...&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;2016-06-28 12:22:43.341 [44] net.sf.jasperreports.printserver.Configuration loadInternalConfiguration - INFORMATION: Loading internal configuration file "configuration.xml"
2016-06-28 12:22:43.341 [44] net.sf.jasperreports.printserver.JRWorker loadReport - INFORMATION: Loading report "ew-test.jasper"
2016-06-28 12:22:43.357 [44] net.sf.jasperreports.printserver.JRWorker work - INFORMATION: Filling report "ew-test.jasper"
2016-06-28 12:22:43.372 [44] net.sf.jasperreports.printserver.JRWorker work - INFORMATION: Exporting report "ew-test.jasper"
2016-06-28 12:22:43.388 [44] net.sf.jasperreports.printserver.PrintServlet processRequest - INFORMATION: Sending PDF report to client (6224 bytes)
2016-06-28 12:22:43.388 [44] net.sf.jasperreports.printserver.PrintServlet processRequest - INFORMATION: Report run finished
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;BR&lt;br/&gt;
Sebastian&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>java.lang.NullPointerException</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/00563cd3/" rel="alternate"/><published>2016-06-28T10:17:01.025000Z</published><updated>2016-06-28T10:17:01.025000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.net18cc3fab27d25a663221c2dfd3e3a303c71f655b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello Michael&lt;/p&gt;
&lt;p&gt;Sorry for the delay - holidays! ;-)&lt;/p&gt;
&lt;p&gt;Okay that was a good no-data idea for the report. Fixed.&lt;/p&gt;
&lt;p&gt;Now I can successfully print a report through the Shared-Components/Report Queries/ew-test/Test Report. Got a valid PDF. Happy it works!&lt;/p&gt;
&lt;p&gt;Further I tried to get this reproducable with PL/SQL code. But got a error message from my browser:&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;&lt;span class="n"&gt;Error&lt;/span&gt;&lt;span class="o"&gt;:&lt;/span&gt; &lt;span class="n"&gt;parsererror&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="n"&gt;SyntaxError&lt;/span&gt;&lt;span class="o"&gt;:&lt;/span&gt; &lt;span class="n"&gt;JSON&lt;/span&gt;&lt;span class="o"&gt;.&lt;/span&gt;&lt;span class="na"&gt;parse&lt;/span&gt;&lt;span class="o"&gt;:&lt;/span&gt; &lt;span class="n"&gt;unexpected&lt;/span&gt; &lt;span class="n"&gt;character&lt;/span&gt; &lt;span class="n"&gt;at&lt;/span&gt; &lt;span class="n"&gt;line&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt; &lt;span class="n"&gt;column&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt; &lt;span class="n"&gt;of&lt;/span&gt; &lt;span class="n"&gt;the&lt;/span&gt; &lt;span class="n"&gt;JSON&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt;
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;This procedure would be called with a button click:&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;declare
  l_blob blob;  
begin
  l_blob := apex_util.get_print_document(p_application_id    =&amp;gt; '103',
                                         p_report_query_name =&amp;gt; 'ew-test');

  jrpserver.download(l_blob, 'ew-test', 'pdf');
  apex_application.stop_apex_engine;
end;
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;APEX debug log:&lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;Elapsed,"Execution","Message","Level"   
0.01600,"0.00000","R E Q U E S T ajax plugin","4"   
0.01600,"0.00000","Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: de","4"  
0.01600,"0.00000","alter session set nls_language='GERMAN' nls_territory='GERMANY'","4" 
0.01600,"0.00000","NLS: CSV charset=WE8MSWIN1252","4"   
0.01600,"0.00000","...NLS: Set Decimal separator="",""","4" 
0.01600,"0.00000","...NLS: Set NLS Group separator="".""","4"   
0.01600,"0.00000","...NLS: Set g_nls_date_format=""DD.MM.RR""","4"  
0.01600,"0.00000","...NLS: Set g_nls_timestamp_format=""DD.MM.RR HH24:MI:SSXFF""","4"   
0.01600,"0.00000","...NLS: Set g_nls_timestamp_tz_format=""DD.MM.RR HH24:MI:SSXFF TZR""","4"    
0.01600,"0.00000","NLS: Language=de","4"    
0.01600,"0.00000","Application 103, Page Template: 12070764821148203","4"   
0.01600,"0.00000","Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)","4" 
0.01600,"0.00000","...fetch session state from database","4"    
0.01600,"0.00000","fetch items (exact)","4" 
0.01600,"0.00000","... sentry+verification success","4" 
0.01600,"0.00000","...Session ID 16210979895266 can be used","4"    
0.01600,"0.00000","...Setting session time_zone to +02:00","4"  
0.01600,"0.00000","...Check for session expiration:","4"    
0.01600,"0.00000","Run NATIVE/PLUGIN= request","4"  
0.01600,"0.21800","...Execute Statement: begin declare  
  l_blob blob     
begin   
  l_blob := apex_util.get_print_document(p_application_id    =&amp;gt; '103',  
                                         p_report_query_name =&amp;gt; 'ew-test')  

  jrpserver.download(l_blob, 'ew-test', 'pdf')  
  apex_application.stop_apex_engine 
end 
end ,4"
0.23400,"0.00000","Stop APEX Engine detected","4"   
0.23400,"0.00000","...Error data:","2"  
0.23400,"0.00000","......message: AJAX call returned server error ORA-20876: Stop APEX Engine for Execute PL/SQL Code.","2" 
0.23400,"0.00000","......is_internal_error: true","2"   
0.23400,"0.00000","......apex_error_code: APEX.AJAX_SERVER_ERROR","2"   
0.23400,"0.00000","......ora_sqlcode: -20876","2"   
0.23400,"0.00000","......ora_sqlerrm: ORA-20876: Stop APEX Engine","2"  
0.23400,"0.00000","......error_backtrace: ORA-06512: in ""APEX_050000.WWV_FLOW"", Zeile 2945    
ORA-06512: in Zeile 8   
ORA-06512: in ""SYS.DBMS_SYS_SQL"", Zeile 1815  
ORA-06512: in ""SYS.WWV_DBMS_SQL"", Zeile 1033  
ORA-06512: in ""SYS.WWV_DBMS_SQL"", Zeile 1047  
ORA-06512: in ""APEX_050000.WWV_FLOW_DYNAMIC_EXEC"", Zeile 895  
ORA-06512: in ""APEX_050000.WWV_FLOW_PLUGIN_UTIL"", Zeile 2542  
ORA-06512: in ""APEX_050000.WWV_FLOW_DYNAMIC_ACTION_NATIVE"", Zeile 456 
,2" 
0.23400,"0.00000","......error_statement: begin declare 
  l_blob blob     
begin   
  l_blob := apex_util.get_print_document(p_application_id    =&amp;gt; '103',  
                                         p_report_query_name =&amp;gt; 'ew-test')  

  jrpserver.download(l_blob, 'ew-test', 'pdf')  
  apex_application.stop_apex_engine 
end 
end ,2"
0.23400,"0.00000","......component.type: APEX_APPLICATION_PAGE_DA_ACTS","2" 
0.23400,"0.00000","......component.id: 5785403189263942","2"    
0.23400,"0.00000","......component.name: NATIVE_EXECUTE_PLSQL_CODE","2" 
0.23400,"0.00000","Stop APEX Engine detected","4"   
0.23400,"-","Final commit","4"  
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;BR&lt;br/&gt;
Sebastian&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>java.lang.NullPointerException</title><link href="https://sourceforge.net/p/jrprintserver/discussion/general/thread/00563cd3/" rel="alternate"/><published>2016-06-17T09:42:36.697000Z</published><updated>2016-06-17T09:42:36.697000Z</updated><author><name>Michael</name><uri>https://sourceforge.net/u/net-sf-michael/</uri></author><id>https://sourceforge.netb86d36f778ba447091490e4346408ce65b61498b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Sebastian,&lt;/p&gt;
&lt;p&gt;now with test.html we see that the template parameter in fact contains "ew-test.jasper" in /template/report/value.&lt;br/&gt;
The next question is: Is it also there when you execute the report from APEX? (The same stuff should be logged.)&lt;/p&gt;
&lt;p&gt;So, in your test with test.html the report file could be loaded and executed.&lt;br/&gt;
Then you only get an empty PDF - this is the case because your report uses a SQL query as its Data Source and hence needs a SQL Connection to query.&lt;br/&gt;
But JR PrintServer does not provide a SQL Connection to the report - it provides a Data XML Document, so your report should NOT use SQL as its query language but xPath to "query" the XML.&lt;br/&gt;
You can change this on JSS when you right click on the report node and select "Dataset and Query...".&lt;br/&gt;
For your test report you may enter here as Query the xPath expression "/" (just a slash to "produce" one row).&lt;/p&gt;
&lt;p&gt;Regards,&lt;br/&gt;
Michael&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>