报表框架整合记录20210422

UReport2
http://wiki.bsdn.org/pages/viewpage.action?pageId=76448360
http://www.bstek.com/
http://www.bsdn.org/projects/ureport/deploy/ureport-sample/
https://blog.csdn.net/wsh100863/article/details/80798026
https://blog.csdn.net/wsh100863/article/details/80798026
https://blog.csdn.net/dazhongyue/article/details/77898136
https://blog.csdn.net/dazhongyue/article/details/77645457
https://blog.csdn.net/qq_34302802/article/details/107087317

JasperReport
https://blog.csdn.net/weixin_30826095/article/details/95289750
https://blog.csdn.net/dullchap/article/details/51799070
https://blog.csdn.net/tzdwsy/article/details/50595313
https://www.yiibai.com/jasper_reports/jasper_report_sections.html
https://blog.csdn.net/qq_37568049/article/details/78741225?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromBaidu~default-6.control&dist_request_id=&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromBaidu~default-6.control
https://community.jaspersoft.com/project/jasperreports-server/releases
https://blog.csdn.net/SHIYUN123zw/article/details/79155230?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromBaidu~default-2.control&dist_request_id=&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromBaidu~default-2.control

how to export to excel and csv format in jasper report
https://www.e-learn.cn/qa/answer/677728/1644051.html
https://www.136.la/net/show-1168.html
https://www.136.la/shida/show-144444.html
https://community.jaspersoft.com/
https://community.jaspersoft.com/project/jaspersoft-studio/releases
https://community.jaspersoft.com/project/jasperreports-library/releases
https://community.jaspersoft.com/documentation?version=61916
https://www.cnblogs.com/diyunpeng/p/5934909.html
https://codingdict.com/sources/java/net.sf.jasperreports.engine/53114.html

https://downloadly.ir/software/programming/stimulsoft-reports/
https://downloadly.ir/?s=Stimulsoft
https://github.com/stimulsoft
https://blog.csdn.net/xiaochuachua/article/details/84292899
https://search.maven.org/search?q=g:com.stimulsoft AND a:stimulsoft-reports-libs
https://www.stimulsoft.com/en/products/reports-java
https://www.stimulsoft.com/en/faq/reports-java#q1
https://www.stimulsoft.com/en/faq/reports-java#q2
https://forum.stimulsoft.com/viewtopic.php?f=19&t=58731
https://forum.stimulsoft.com/viewtopic.php?f=19&t=58735
https://forum.stimulsoft.com/viewtopic.php?f=19&t=48001
https://forum.stimulsoft.com/viewtopic.php?f=19&t=55533
https://forum.stimulsoft.com/viewtopic.php?f=19&t=53531
https://forum.stimulsoft.com/viewtopic.php?f=19&t=49481
https://forum.stimulsoft.com/viewtopic.php?f=19&t=40090

https://www.stimulsoft.com/en/samples/java
https://www.stimulsoft.com/en/samples/java/create-report-with-relations-in-runtime
https://www.stimulsoft.com/en/samples/java/export-report-from-code
https://forum.stimulsoft.com/viewtopic.php?f=19&t=56568
https://www.stimulsoft.com/en/samples/java/copy-components-between-reports
https://www.stimulsoft.com/en/samples/java/create-report-with-mysql-database-in-runtime
https://www.stimulsoft.com/en/samples/java/create-report-with-relations-in-runtime
https://www.stimulsoft.com/en/samples/java/export-report-from-code
https://www.stimulsoft.com/en/samples/java/export-report-with-the-export-dialog
https://www.stimulsoft.com/en/samples/java/run-the-java-web-designer
https://www.stimulsoft.com/en/samples/java/run-the-java-web-viewer
https://www.stimulsoft.com/en/samples/java/run-the-web-designer-and-web-viewer-with-javaserver-faces
https://www.stimulsoft.com/en/samples/java/runtime-report-creation
https://www.stimulsoft.com/en/samples/java/using-oracle-database

Bio
User Name 24820693
Real Name jeely yu
E-mail 24820693@qq.com
password:Darjeely1314!@#
Location United States
State/Province California
Company Info
Primary Role IT - Developer
Company hk
Company Size 1-100 Employees
Stats
Member For 1 min 9 sec
Last Access Mar 30 2021 - 8:46pm
Profile Complete

4.8
(6 reviews)
JasperReports® Server

=============================================================================================================================================================

http://127.0.0.1:8090/finereport/page_demo/parameter.html
http://127.0.0.1:8080
http://127.0.0.1:8080/hxfl-JasperReportDemo-master
http://127.0.0.1:8081//jasper/pdf

https://www.cnblogs.com/hunttown/p/13488486.html
Stimulsoft javaweb
https://github.com/stimulsoft/Samples-Java/archive/master.zip
https://github.com/stimulsoft/Samples-Java/tree/master/jsfstimulsoft
https://www.stimulsoft.com/en/samples/java/run-the-java-web-viewer
https://www.stimulsoft.com/en/products/reports-java
https://demo.stimulsoft.com/

==============================================
参考demo记录
downloadGoogle 目录

正常运行
demo-spring-thymeleaf-jasper-master
JRBeanCollectionDataSource
JRBeanCollectionDataSource
jasperreports-demo-master
jasperReports-master
SPRING-MVC-JasperReport-master
spring-mvc-jpa-jasper-report-example-master

downloadcode目录
jasperreport-demo-master
https://www.cnblogs.com/xyyz120/category/1695447.html
http://localhost:8080/test/jasper?type=html
http://localhost:8080/test/jasper?type=pdf

xyyz150-jasperreport-demo-master
http://localhost:8080/test/jasper?type=html
http://localhost:8080/test/jasper?type=pdf
https://www.cnblogs.com/xyyz120/category/1695447.html

simplecode目录
actiongo-report-srping-boot-master
alvinJasperReport-master
Jasper-pdf-master
http://localhost:8081/jasper/pdf
jasperreport-springboot-master
javamenc-jasperreports-master
justinware-jasperreportdemo-master
nn200433-easy-print-master
xinhuan666-jasperReports-master

http://localhost:9090/

http://localhost:8080/test/jasper?type=html
D:apache-maven-3.3.9confsettings.xml

D:apache-maven-3.3.9 epository

====================================
https://mvnrepository.com/artifact/net.sf.jasperreports
https://www.cnblogs.com/lay2017/p/9859340.html

https://github.com/FDVSolutions/DynamicJasper

ar.com.fdvs
DynamicJasper
5.3.1

net.sf.jasperreports jasperreports-fonts 6.16.0

整合完毕
http://localhost:8070/hngeology/index.do
http://localhost:8070/hngeology/jasper?type=html

http://localhost:8070/hngeology/jasper?type=html

http://localhost:8070/hngeology/report.do
http://localhost:8070/hngeology/reportxls.do

sys/core/sysReportPreview.jsp
/WEB-INF/jsp/sys/core/sysReportPreview.jsp

http://localhost:8070/hngeology/sys/core/sysReport/preview.do?pkId=2620000001590039

http://localhost:8070/hngeology/sys/core/sysReport/show.do

http://localhost:8070/hngeology/jasper?type=html

导出pdf测试成功
http://localhost:8070/hngeology/report
http://localhost:8070/hngeology/download

导出xls测试没有成功
http://localhost:8070/hngeology/reportexcel

导出excel资料
JRXlsxExporter
SimpleXlsxReportConfiguration
https://blog.csdn.net/agogwalker/article/details/70232348
https://blog.csdn.net/weixin_36225384/article/details/114253582?utm_medium=distribute.pc_relevant.none-task-blog-baidujs_title-0&spm=1001.2101.3001.4242
https://www.cnblogs.com/qiushuiblog/p/10821145.html
https://blog.csdn.net/wangmengdi123/article/details/80305385
https://www.jb51.net/article/161337.htm
https://stackoverflow.com/questions/3737308/how-to-export-to-excel-in-jasperreports
https://www.tutorialspoint.com/jasper_reports/jasper_exporting_reports.htm
http://jasperreports.sourceforge.net/sample.reference/jasper/
http://jasperreports.sourceforge.net/sample.reference/datasource/index.html
https://sourceforge.net/p/jasperreports/code/ci/6.16.0/tree/jasperreports/demo/samples/webapp/
http://jasperreports.sourceforge.net/sample.reference.html

嵌套iframe
https://blog.csdn.net/wangmengdi123/article/details/80305385?spm=1001.2014.3001.5501
http://localhost:8070/hngeology/gd/statisticanalysis/statisticssum/frontpage.do

导出
javamenc-jasperreports-master
MyJasperReportWebPrint-master
JasperWeb-master

导出excel白色背景设置
https://blog.csdn.net/wangjun5159/article/details/51152403
https://blog.csdn.net/wangjun5159/article/details/51281145
https://www.cnblogs.com/laoyeye/p/7707149.html

@GetMapping("/report")
public void report(HttpServletResponse response) throws JRException, IOException {

    String template = JasperReportUtil.getJasperFileDir("chapter1");
    String fileName ="outpdfname";
    HashMap<String, Object> parameters = new HashMap<String, Object>();
    parameters.put("name", "xiaoming");
    List<HashMap> list = new ArrayList<>();
    for (int i = 0; i < 100; i++) {
        HashMap<String, String> item = new HashMap<String, String>();
        item.put("Field1", "Field1-" + i);
        item.put("Field2", "Field2-" + i);
        list.add(item);
    }
    String jasperPath = JasperReportUtil.getJasperFileDir("chapter1");

    ClassPathResource resource = new ClassPathResource(jasperPath);
    InputStream jasperStream = resource.getInputStream();
    JasperPrint jasperPrint = getJasperPrint(jasperStream, parameters, list);
    response.setContentType("application/x-pdf");
    response.setHeader("Content-disposition", "inline; filename=" + fileName + ".pdf");
    final OutputStream outStream = response.getOutputStream();
    JasperExportManager.exportReportToPdfStream(jasperPrint, outStream);
}
	
http://localhost:8070/hngeology/excelweb.do	

http://localhost:8070/hngeology/downloadpdf.do

http://localhost:8070/hngeology/downloadxlsx.do

http://localhost:8070/hngeology/downloadxls.do

http://localhost:8070/hngeology/downloaddoc.do

http://localhost:8070/hngeology/downloadrtf.do

http://localhost:8070/hngeology/downloadpptx.do

http://localhost:8070/hngeology/downloadcsv.do

http://localhost:8070/hngeology/excelweb.do

http://localhost:8070/hngeology/excelweb.do

http://localhost:8070/hngeology/gd/statisticanalysis/statisticssum/frontpage.do

http://localhost:8070/hngeology/gd/statisticanalysis/jaspertest/frontpage.do
/WEB-INF/jsp/gd/statisticanalysis/jaspertestFrontpage.jsp

=====================================================

pdf中文字体解决
微软雅黑
msyh.tff

STSONG.TTF
导出字体moses.jar
https://www.cnblogs.com/xyyz120/p/12681258.html

原文地址:https://www.cnblogs.com/Jeely/p/14689489.html