Good, so I need to create very complex reports from my database.If I do this with SQL, the query itself will be complicated, and I will have to manipulate the results a bit later, at the code level.How do libraries such as Jasper Reports / Crystal Reports and friends save time in developing such reports?What will they give me?
These tools may not necessarily save you a lot of time writing SQL, but they will give you a nice, clean presentation of the data for your clients.
When it comes to writing a request, they won’t give you much. Some of the Business Intelligence tools (though not one of the open sources that I know of) give you the infrastructure for point and click requests. The developer still has to do the difficult work of setting them up, especially for complex queries in order to ensure that the data is simple enough for the user.
, , , , (HTML, PDF ..), , .
, SQL . :
SQL, , , .
Jasper / . , JasperReports Java, .
, Jasper Reports/Crystal Reports , ?
Jasper, Crystal , Jasper , XML JavaBeans. ( Crystal)
?
, Jasper, , .
, , - , , - ( ) .. , .
, , , . Microsoft Crystal. Java JasperReports iReport.
JasperReports .
Jaspersoft ( JasperReports)
, , , Jasper Docmosis, , . SQL , . , SQL + , SQL.
. , , , , , , Reporting - , . , .
, , DBA , SysAdmin , , , , , , .. - , , , -, Jasper, , Jasper - .
, , . , . Jasper. . . -, , . , .
. , - . , , . , . - , , . . . , . Reporting , .
, , 14- Crystal Reports , . Crystal Reports . Crystal Report . , , .
, Crystal Reports, . , , www.combit.net.
One important thing that Crystal Reports gives you is the ability to do Subreports, that is, several related queries that return nested result sets. This can really simplify the individual queries you write. Take a look at http://vb.net-informations.com/crystal-report/vb.net_crystal_report_subreport.htm
Source: https://habr.com/ru/post/1736662/More articles:Что такое более быстрый способ объединения значений этой структуры Python в один словарь? - performanceRails: включить индекс с полями_for form helper - ruby-on-railsI am not prompted to select the homepage - asp.netOpenId + Facebook Connect - loginCan I get a ListBox WPF to inherit brushes from a parent element? - .netHow can I restrict asp.net management actions based on user role? - authenticationПоказывать приветственную страницу Eclipse RCP при каждом запуске - eclipse-rcphttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1736665/using-mercurialtortoisehg-is-there-a-way-to-set-repository-permissions&usg=ALkJrhj0WsuG_CfSfbTAhQyo6zvBGbzz-AHow to disable OK button of modal dialog in jQuery - jquery-uiWhy gcc warns of incompatible structure assignment with `self = [super initDesignatedInit]; 'call a derived class? - gccAll Articles