Jump to content
We've recently updated our Privacy Statement, available here ×

asimkin

Members
 View Profile  See their activity

  • Posts

    196

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by asimkin

  1. asimkin
    Use CaseCustomer would like to configure TIBCO JasperReports® Server to write logs to one more file in Catalina logs folder, in addition to default one. ResolutionBy default, TIBCO JasperReports® Server writes logs to ${jasperserver.root}/WEB-INF/logs/jasperserver.log[/code]log file. This is configured in WEB-INF/log4j.properties. In order to write logs to one more file, a new logger (let's call it catalinaOut) should be added to log4j.rooLogger property: log4j.rootLogger=ERROR, stdout, fileout, catalinaOut[/code]and the appender details: # additionally, write to catalina.outlog4j.appender.catalinaOut=org.apache.log4j.RollingFileAppenderlog4j.appender.catalinaOut.File=${catalina.home}/logs/cataline.outlog4j.appender.catalinaOut.MaxFileSize=10MBlog4j.appender.catalinaOut.MaxBackupIndex=2log4j.appender.catalinaOut.layout=org.apache.log4j.PatternLayoutlog4j.appender.catalinaOut.layout.ConversionPattern=%p %t %c - %m%n[/code]Server restart required. Solution tested with TIBCO JasperReports® Server v.7.1.0 AS-20190225
  2. asimkin
    Use CaseCustomer created an Ad Hoc Chart with a long title. He would like the title to be displayed as multiline text. ResolutionAd Hoc View Title set with 'Click to add a title' option does not support multiline text. Instead of that, customer should set title with text.title Highcharts property in Advanced Chart Formatting mode: https://api.highcharts.com/highcharts/title.text https://community.jaspersoft.com/wiki/advanced-chart-formatting The property supports some formatting tags including <br>: Solution tested with TIBCO JasperReports® Server v.7.1.0 AS-20190218
  3. asimkin
    Use CaseCustomer created a JRXML report with HTML5 chart with a Date field as Categories Level. He would like to show weekends in different color in xAxis labels. ResolutionPlease find attached sample report which implemented solution. The idea is to use xAxis.formatter property which is a Javascript function returns required style color based on date: https://api.highcharts.com/highcharts/xAxis.labels.style Code of the function: "function(){var cl='#666666'; d=new Date(this.value); var n=d.getDay(); if (n==0 || n==6) {cl='red';}; return '<span style="color:'+cl+'">'+this.value+'</span>'}"[/code]The function checks if date is a weekend (0 is Sunday , 6 is Saturday) and returns red color. Otherwise, default color is used (#666666) Please note, in order to use formatter function, you should enable a special property: com.jaspersoft.jasperreports.highcharts.function.properties.allowed=true as described in article: https://community.jaspersoft.com/wiki/using-functions-html5-charts-highcharts Solution tested with TIBCO JasperReports® v.7.1.0 AS-20190218, case #01677997
  4. asimkin
    Use CaseCustomer created an Ad Hoc View and Report and noted that generate SQL query conatins LIMIT clause, like SELECT field1, field2, ... FROM table ... LIMIT 200001 Per customer's comment, LIMIT clause leads to parallelization prevention in PostgreSQL. He would like to completely remove LIMIT in generated queries. ResolutionAd Hoc Engine uses limitSQLMap property of postgreSQLGenerator bean to add LIMIT clause in SQLs. The bean specified in WEB-INFapplicationContext-semanticLayer.xml configuration file: <property name="limitSQLMap"> <map> <entry key="AT_END" value="limit _row_limit_"/> </map> </property> In order to remove LIMIT in Ad Hoc queries, the property should be commented out and server restarted. Please note, all Ad Hoc Views and Ad Hoc Reports will be affected by the changes. Solution tested with TIBCO JasperReports® Server v.7.1.0 AS-20191502, case #01679102
  5. asimkin
    Hi, please check if a solution described in article https://community.jaspersoft.com/wiki/how-pass-java-list-or-list-chart-datasource-jrxml-based-reports could help you. Best regards, Andrew
  6. asimkin
    Use CaseCustomer created an Ad Hoc Table Report with a group. By default, the report may display more than 1 group in a single page. Customer would like to force a page break after every group of the report. ResolutionAd Hoc Engine automatically creates a Group element in the generated Ad Hoc Table Report if underlying Ad Hoc View has a group. The Group element has a property called 'Start New Page' (isStartNewPage) : http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRGroup.html#isStartNewPage-- If this option is set to True, it forces a page break at the end of the group (that is, at the beginning of a new group). By default, the property is set to False in the generated Ad Hoc Report. This can be changed by opening the Ad Hoc Report in TIBCO Jaspersoft® Studio, 'Repository Explorer' tab and setting the property value to True: Solution tested with TIBCO JasperReports® Server v.7.1.0
  7. asimkin
    Use CaseCustomer has a requirement to remove/hide 'Hide Column' menu from report viewer Table JIVE. Other options (Filter, Sorting etc) must remain available. ResolutionOne of possible way to achieve the requirement is to create a custom theme with CSS code which hide the required item menu - Hide Column You can check TIBCO JasperReports® Server Admin Guide for more information about themes: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v71/themes The idea is to create a custom theme which contains only 1 special css file - overrides_custom.css which takes precedence over styles. The CSS file content is /* Hide 'Hide Column' JIVE menu */ ul.pmenu li.pmenuitem[key=hideColumn] { display: none !important; } Please find attached custom theme which implements the solution. What you should do is to load the theme to TIBCO JasperReports® Server and make it active. Solution tested with TIBCO JasperReports® Server v.7.1.0 Ref. Case 01673524
  8. asimkin
    So, 'Select All' is just a value of the single select inpuit control, right? Did you try to specify the parameter's Default Value Expression property as "Select All"? Best regards, Andrew
  9. asimkin
    Hi, first of all, I'd like to mention all the SQL queries must return identical set of fields, in your scenario. In order to achieve the requirements, you could use $P!{} syntax : https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/using-parameters-queries-0 The idea is to create an additional hidden parameter which uses selected by user option from drop-down list to specify according query, like IF($P{Parameter1}.equals("Q1"),"select orderid as id from orders",IF($P{Parameter1}.equals("Q2"),"select shipvia as id from orders","select 1 as id")) Then, the report dataset query should be like $P!{p_query} Find attached sample report that demonstrates the idea. Hope, this helps. Best regards, Andrew
  10. asimkin
    Hi, unfortunately, it's not clear what you want to achieve. Per the question subject, the parameter in question is Single Select. But you are looking for a way to select all values? Please explain it more detailed. Best regards, Andrew
  11. asimkin
    Issue DescriptionCustomer created an Ad Hoc Report from Ad Hoc View based on a domain Later, the domain structure was modified and some items removed. Now, if end-user opens the report, he gets message: "The report contains one or more items that are not in the source data.You must edit the Ad Hoc View that was used to create this report, and re-save the report." Customer customized the message as described in article https://community.jaspersoft.com/wiki/customizing-ad-hoc-report-missed-items-message But as it turned out, HTML style tags like font color, bold etc are not supported. Customer would like to use HTML style tags in the message [toc]ResolutionTIBCO JasperReports® Server uses a special template to process Ad hoc Reports with missed itesm: Public > Templates > Error Report (ds_error_report.jrxml filename) The template contains a TextField element to display a message. In order to process HTML tags, the element's Markup property should be set to html: Please refer to printscreen with enabled HTML tags: Solution tested with TIBCO JasperReports® Server v.7.1.0
  12. asimkin
    Use CaseCustomer has a requirement to move 'Repository' quick link from 'Admin Home' page to 'Home' page. ResolutionIn order to achieve the requirements, some changes should be done in WEB-INFapplicationContext-rest-services.xml config file. Especially, comment out section <entry key="repository"> <bean class="com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.workflow.dto.UserWorkflow"> <property name="name" value="repository"/> <property name="label" value="repository.title"/> <property name="description" value="repository.description"/> <property name="parentName" value="admin"/> </bean> </entry>[/code]line ~453 and add section <entry key="repository"> <bean class="com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.workflow.dto.UserWorkflow"> <property name="name" value="repository"/> <property name="label" value="repository.title"/> <property name="description" value="repository.description"/> <property name="parentName" value="main"/> </bean> </entry>[/code]after section <entry key="admin"> ..... </entry> line ~426 Solution tested with TIBCO JasperReports® Server v.7.1.0 Ref. Case 01675120
  13. asimkin
    Issue DescriptionCustomer created a JRXML report which uses relative date parameters and a query like SELECT col1, col2, date_column FROM table1 WHERE $X{BETWEEN, date_column, p_start_date, p_end_date} where p_start_date and p_end_date are net.sf.jasperreports.types.date.DateRange type parameters. User noted that generated SQL did not include interval endpoints: SELECT col1, col2, date_column FROM table1 WHERE date_column > ? and date_column < ? which did not meet requirements. He needs to include interval endpoints : SELECT col1, col2, date_column FROM table1 WHERE date_column >= ? and date_column <= ? How to achieve it? ResolutionThe $X{} clause function supports special syntax to include interval endpoints into generated SQL - [ and ] characters. Using $X{[bETWEEN],...} function makes SQL generator include both endpoints into a query: (<column_name> >= ? AND <column_name> <= ?) Also, it is possible to include only left or right endpoint: $X{[bETWEEN,...} $X{BETWEEN],...} More details are available in JasperReports Library Sample reference: http://jasperreports.sourceforge.net/sample.reference/query/index.html Solution tested with TIBCO JasperReports® Server v.7.1.0 Ref. Case 01667206
  14. asimkin
    Hi, what you could try is to use net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name} property: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name} https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls Best regards, Andrew
  15. asimkin
    Hi, the link I posted just explains that the error message comes from MS SQL Databasse and is out of JasperReports control. Best regards, Andrew
  16. asimkin
    Hi, it seems this error message comes from underlying database: https://www.cuba-platform.com/discuss/t/sqlserverexception-the-server-supports-a-maximum-of-2100-parameters/1991 and is not managed by JasperReports Server Best regards, Andrew
  17. asimkin
    Hi, try to set plotOptions.pie.dataLabels.distance property to a negative value with 'Use expression' option checked, please check attached printscreen: https://api.highcharts.com/highcharts/plotOptions.pie.dataLabels.distance Best regards, Andrew
  18. asimkin
    Hi, you may find useful a solution to encrypt both username and password in the URL as described in the article: https://community.jaspersoft.com/wiki/how-encrypt-username-url Best regards, Andrew
  19. asimkin
    Hi, unfortunately, for Today and Yesterday dates, a plain text values are used in jasperserver_messages*.properties bundle files SEARCH_DATE_TODAY=Today SEARCH_DATE_YESTERDAY=Yesterday There is an enhancement request to make that values configurable as well. Hope, this helps. Best regards, Andrew
  20. asimkin
    Hi, in case of Ad Hoc report, you can achieve the requirement by setting group property 'Start New Page' to true in Jaspersoft Studio, please find attached printscreen.
  21. asimkin
    Issue DescriptionCustomer created an Ad Hoc Report from Ad Hoc View based on a domain Later, the domain structure was modified and some items removed. Now, if end-user opens the report, he gets message: "The report contains one or more items that are not in the source data.You must edit the Ad Hoc View that was used to create this report, and re-save the report." Customer would like to customize that message. [toc]ResolutionIn TIBCO JasperReports® Server v.7.1.0 a new mechanism was implemented to process situation when data source (domain) used for Ad hoc Views and Reports changed (filds were removed, renamed etc). As a part of these changes, a new property was added for missed Ad Hoc Report items in bundle files, property name is report.missing.data.source.fields[/code]The property value can be changed to required message. Please refer to printscreen with default mesage and customized one
  22. asimkin
    Hi you have to specify parameters mapping in Properties > Dataset > Parameters menu, please find attached printscreen. Best regards, Andrew
  23. asimkin
    Hi, you may find useful a solution described in article https://community.jaspersoft.com/wiki/how-merge-table-rows-repeated-values except rotating the first text field labels Best regards, Andrew
  24. asimkin
    Use CaseCustomer noticed that a new template appeared in TIBCO JasperReports® Server v.7.1.0 - 'Error Report', and would like to know purpose of the template. ResolutionIn TIBCO JasperReports® Server v.7.1.0 a new mechanism was implemented to process situation when data source (domain) used for Ad hoc Views and Reports changed (filds were removed, renamed etc). As a part of these changes, a new template was added - Public > Templates > Error Report, filename is ds_error_report.jrxml The template used when end-user tries to open an Ad Hoc Report with missed items/fields. If in previous versions of the product an exception with stacktrace displayed to the user, from v.7.1.0 a user-friendly message shown instead: Ref. Case 01660041
  25. asimkin
    Use CaseCustomer would like to limit the export formats (PDF, Excel, CSV etc) available for dashlets but couldn't find a way to achieve it. ResolutionBy default, TIBCO JasperReports® Server v.7.1.0 supports the following export formats: PDF Excel (Paginated) Excel RTF CSV ODT ODS DOCX XLSX (Paginated) XLSX PPTX Thj list of formats is code in a Javascript file: webappsjasperserver-proscriptsbower_componentsbi-dashboardsrcdashboardviewbasecomponentViewTraitreportTrait.js Export formats defined as: exportOptions = [ { label: i18n['jasper.report.view.hint.export.pdf'], action: 'pdf', params:{outputFormat: "pdf"} }, { label: i18n['jasper.report.view.hint.export.excel'], action: 'excel', params:{outputFormat: "xls"} }, { label: i18n['jasper.report.view.hint.export.excel.nopag'], action: 'excel.nopag', params:{outputFormat: "xls", ignorePagination: true} },...[/code]Unfortunately, there is no UI or a config file to limit the list of export formats. The only way is to change the Javascript file and comment unrequired formats, like /*** { label: i18n['jasper.report.view.hint.export.excel.nopag'], action: 'excel.nopag', params:{outputFormat: "xls", ignorePagination: true} },***/[/code]Please note, that all dashlets will be affected by the changes. By default, JasperReports Server uses optimized versions of scripts located in folder webappsjasperserver-prooptimized-scripts In order to test the changes, you can add ?_opt=false parameter to URL to load non-optimized scripts and check if the changes meet your requirements: https://community.jaspersoft.com/wiki/can-i-test-customizations-jasperreports-server-javascript-running-optimization-process If everything is OK, you should re-generate optimized scripts as described in JasperReports Server Ultimate Guide: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v710/customizing-javascript-files Solution tested with TIBCO JasperReports® Server v.7.1.0 Ref. Case 01667711
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore