This blog talks about D3 DayHour Charts integration with Jaspersoft
All the reports are develop using ireport 5.5 professional and jasper server 5.5
As html component of jasper server does not load any scripts in the html component, we loaded the script in one of the decorator page (jsp page). The page is located at the location:
C:\Jaspersoft\jasperreports-server-5.5\apache-tomcat\webapps\jasperserver-pro\WEB-INF\decorators\decorator.jsp
In the page we included the scripts which we want to load. We added the following code in the jsp page at line no 46:
<script type=”text/javascript” language=”JavaScript” src=”${pageContext.request.contextPath}/scripts/d3.v3.min.js”></script>
The script to be added should be kept at location:
C:\Jaspersoft\jasperreports-server-5.5\apache-tomcat\webapps\jasperserver-pro\scripts
Meaning of DayHour Chart:-
This chart represents functioning of any particular thing during different hour of different days. These graph can be used to view variations in different situations.
Integration with JasperServer:
The data which we use for developing the calendar view can be fetched from any database. The data fetched from database is stored in a variable and is then accessed in the html component using the same variable. Applying this of process makes the report dynamic instead of static. Few parameters can also be added in the report which can be used in query and/or html component.
Generally for these type of charts we pass a variable which contains required data containing date, hour and a value associated with that particular date and hour. The string is created according to JSON format, so that when accessed in script tag, can be easily converted to JSON object using eval function.
Any variable/parameter can be accessed as shown below:
“<script> var arr =”+$V{variable1}+” </script>”
Parameter in query:
Select * from table_name
where date between $P{parameter1} and $P{parameter2}
The sample code of static chart can be found at:
http://bl.ocks.org/tjdecke/5558084
The steps on how to integrate it with jasperserver was discussed in my previous blog(D3 Integrating with Jasperserver).
Avi Dawra
Best Open Source Business Intelligence Software Helical Insight is Here
