Introduction: –
Most of the users are using dashboards. If we want to give an option to an end user so that they can export the data (in CSV) form of individual reports at the dashboard level. Right now, the CSV export at dashboard level is taking a snapshot and exporting it. This is especially useful when we have implemented the cascading at dashboard level.
Below are the steps to deploy
- Download the above zip file
-
- Create a folder named “hwf” and Copy the “Adhoc_CSV.hwf” in the below path
...\hi\hi-repository\hwf
- Copy the “excelFile_CSV.jsp” in the below path
...hi\apache-tomcat-9\webapps\hi-ee\WEB-INF\jsp
- Extract and Copy “Library Jars” and place in the below server location
...hi\apache-tomcat-9\webapps\hi-ee\WEB-INF\lib
- copy the folder “hwf” into the below path
..\hi\apache-tomcat-9\webapps\hi-ee\WEB-INF\classes\com\helicalinsight
- Restart the server
- Open the Adhoc report in edit mode and apply JS and CSS scripts to Add CSV export button for the report then save the report
Take script and css from the file > JS Editor script.txt
To enable the CSV Button Customization option please follow the below steps
- Create a folder named “hwf” and Copy the “Adhoc_CSV.hwf” in the below path
- Click CSV button then automatically .csv file gets downloaded.
When the above script is applied a “CSV” button will appear on the report. This will enable you to export the data into CSV format for any kind of chart/table/cross tabular as well.
-
Thank You,
Shreshtha SHil
Helical Insight