asimkin
-
Posts
196 -
Joined
-
Last visited
Community Answers
-
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
-
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
-
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
-
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
-
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
-
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
-
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 -
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}
-
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.