Jump to content
Changes to the Jaspersoft community edition download ×

asimkin

Members
  • Posts

    196
  • Joined

  • Last visited

Community Answers

  1. asimkin's post in Need to Display values in each pie in HTML5 Pie Chart was marked as the answer   
    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
  2. asimkin's post in Create Table Element in jasper Programically was marked as the answer   
    Hi,
    please find attached a sample Java code to create Table component dynamically.
    Hope, this helps you to achieve your requirements
    Best regards,
    Andrew
  3. asimkin's post in Convert Varchar to Float via Domain Calculated Fields was marked as the answer   
    Hi,
    you can specify your custom function in WEB-INFapplicationContext-semanticLayer.xml to convert varchar to float.
    There is str2int function already defined in the file, within "sqlserverGenerator" bean:
    <entry key="str2int">
                        <value>"cast(" + sqlArgs[0] + " as numeric(10,0))"</value>
    </entry>
     
    You can add your custom one like
    <entry key="str2float">
                        <value>"cast(" + sqlArgs[0] + " as float)"</value>
    </entry>
    then restart the server and use str2float() function in Domain Calculated field
    Best regards,
    Andrew
  4. asimkin's post in How i can insert xml data into table component? was marked as the answer   
    Hi,
    it seems the issue caused by empty datasource of the main report.
    I was able to build a report in Jaspersoft Studio that returns required data, please find attached JRXML file.
    I created XML data adapter using provided XML file, and use it as the main report datasource:
    <queryString language="xPath"><![CDATA[/]]></queryString> The Table component has the following JSDatasource Expression:
    <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/addressbook/person/name")]]></dataSourceExpression>[/code]Also, find attached printscreen of the report output.
    Hope, this helps.
    Best regards,
    Andrew
  5. asimkin's post in How to create Reports in Jasper which consume data from REST API in JSON format. was marked as the answer   
    Hi,
    you can find details in the article
    http://community.jaspersoft.com/wiki/how-use-json-remote-data-source-version-561
  6. asimkin's post in Date Picker Input Control - Start Week on Sunday not Monday was marked as the answer   
    Hi,
    for relative dates, you can change week start day in WEB-INFclassesrelativedate.properties file.
    For other cases, week start day is hard-coded in scripts located in bower_componentsjquery-uiuii18n for each locale:
    firstDay: 1
    If you modify the scripts, you have to re-optimize them or configure JasperReports Server to use non-optimized scripts:
    http://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v561/customizing-javascript-files
    Hope, this helps
  7. asimkin's post in Cant pass multiple values as input control at jasperserver was marked as the answer   
    Hi,
    I'm not familiar with Apex in details but from what I found out, Apex calls JasperReports server reports using HTTP API like
    http://jasperreport-server/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/report_name&output=pdf&j_username=jasper_user&j_password=jasper_password&rep_parm=parm_value
    If this is the case, to pass multiple values for a parameter, you should include it multiple time in the call:
    http://jasperreport-server/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/report_name&output=pdf&j_username=jasper_user&j_password=jasper_password&rep_parm=parm_value_1&rep_parm=parm_value_2&rep_parm=parm_value_3
     Hope this helps
  8. asimkin's post in Generating reports based on ROLES was marked as the answer   
    I think you can simply use LoggedInUserRoles builtin parameter in report query:

    select * from table where  $X{IN, role_name, LoggedInUserRoles}

  9. asimkin's post in How to scale/zoom report embedded through visualize.js was marked as the answer   
    JSFiddle examples below may help you:
    Disable autoresize and resize report manually - http://jsfiddle.net/6c8mu5my/15/
    Fit report to container - http://jsfiddle.net/NesterOne/7ChRr/
    You may need to change URL in the second example.
×
×
  • Create New...