hadzio

Thank you - this is what I am doing now. Having dozens or hundrets of occurences of "30" is pretty time consuming. Also, when cells are merged, the "30" may not be matching with other columns in another place, and this makes the search more difficult. Thanks Pawel

Hi All, I work with JasperStudio 6.5.1.final and when I compile my report I can see error messages (screenshot 01). However, I cannot see in which line they are. According to the Editor preferences they should be visible as red bullets on the Vertical scroll bar (screenshot 02) but they are not. Does anybody know how to set up the editor to show line numbers? Or any other ideas how to figure our in which line the error occurs? Thanks and regards Pawel

I am also looking for any documents describing the schema and repository tables as I would like to write my own reports for monitoring and statistics as well. Has anybody seen it? Regards Pawel

Not about paginated and non-paginated, but I have just noticed that my reports generate two files, HTML and Excel and then they run the SQL query twice. If I generate only one output format, the SQL is run only once. However, when I specify 4 output formats (e.g. Html, Excel, PDF, CSV) the SQL is still run only twice and not four times. Is this expected?

Hi All, I have a report that selects data from an Oracle PL/SQL function. This function executes a quite complex logic behind and returns a table to the query executor (JasperServer). If I run this report from JasperServer just by clicking the report name it works well and returns the results as expected, the same if I run it from JasperSoft Studio. However, if I set up a scheduler and the report is run from the scheduler on the given time, it also runs well and returns correct results, but the PL/SQL function in executed TWICE on the Oracle database. I can see it because the function produces log messages in the database (twice). The second execution starts immediatelly after the first one completes. This has never happened to me when selecting from tables or views or other functions. And this is happening ONLY when the report is scheduled or "Run in Background...". Does anybody have any ideas why this is happening and what might be the reason for that behaviour? Part of my report XML is below. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- <queryString language="SQL"> <![CDATA[sELECT (TRUNC(SYSDATE) - to_number(TO_CHAR(sysdate, 'd')) - 6) week_start, (TRUNC(SYSDATE) - to_number(TO_CHAR(sysdate, 'd')) + 1 - 1/24/3600) week_end, b15.subrepid, b15.subrepname, b15.numof, b15.volume, b15.revenue FROM TABLE(bs01.TEST_XBTOP_P_reports.bsr015()) b15]]> </queryString> <field name="WEEK_START" class="java.sql.Timestamp"/> <field name="WEEK_END" class="java.sql.Timestamp"/> <field name="SUBREPID" class="java.lang.String"/> <field name="SUBREPNAME" class="java.lang.String"/> <field name="NUMOF" class="java.math.BigDecimal"/> <field name="VOLUME" class="java.math.BigDecimal"/> <field name="REVENUE" class="java.math.BigDecimal"/> <sortField name="SUBREPID"/> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- My PL/SQL function is: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- CREATE OR REPLACE PACKAGE body TEST_XBTOP_P_reports AS -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- FUNCTION bsr015 RETURN xbtop_y_bsr015_tab AS r_tab xbtop_y_bsr015_tab := xbtop_y_bsr015_tab(); subrepid CHAR(2); subrepname CHAR(35); numof NUMBER; volume NUMBER; revenue NUMBER ; systimestamp_hostname VARCHAR2(200 CHAR); BEGIN -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- I run JasperReports Server Community 6.3 and Oracle SE 11.2.0.3.0. Any ideas would be more then appreciated. Thank you and kind regards Pawel

Hi, I am using TIBCO Jaspersoft® Studio 6.3.1.final and I have a report with 15 subreports embeded in the main report in this way: <subreport><reportElement x="0" y="320" width="1000" height="20" uuid="504fbc60-0036-46a1-9a04-d42bda10a85f"/><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><subreportExpression><![CDATA["BSR015_17_eu_roamed_text.jasper"]]></subreportExpression></subreport> When I open the main report and click "Project -> Build All" (or press Ctrl+B) it compiles only the main report and does not compile subreports (it does not create *.jasper files). When I open each of them and compile individualy then it works well. Is there any way to compile all subreports at the same time? Thank you and kind regardsPawel

Hi, I would like to connect to Cassandra 3.9.0 (DataStax DDC) from JasperReports Server community edition (Product Version: 6.3.0, Build: 20160629_1853) and from Jaspersoft Studio 6.3.1.final. When I create a Data Adapter for Cassandra Connection (no user/no password) and then click Test it works OK and says Successful. The same works well from cqlsh and from DatastaxDevCenter 1.6 as well. But when I write a CQL query for my report and click "Read fields" it does not show anything. So I cannot even see Fields in my report. My CQL query is simple: select customer_name, bs_customer_id, crm_customer_id, my_id from customers I could see similar questions on this forum already but no helpful answer :( Any ideas where the issue might be? Thanks and regards Pawel

I have a similar issue with Cassandra 3.9.0 and JasperReports Server community edition (Product Version: 6.3.0, Build: 20160629_1853) and Jaspersoft Studio 6.3.1.final. When I create a Data Adapter for Cassandra Connection (no user/no password) and then click Test it works OK and says Successful. The same works well from cqlsh and from DatastaxDevCenter 1.6 as well. But when I write a CQL query for my report and click "Read fields" it does not show anything. So I cannot even see Fields in my report. My CQL query is simple: select customer_name, bs_customer_id, crm_customer_id, my_id from customers Any ideas where the issue might be?

May I use Oracle as a repository for JasperReports Server Community 6.3? Is it supported? Thank you Pawel