Pentaho Reporting 3.5 for Java Developers- P9

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:14

Thêm vào BST

Báo xấu

173
lượt xem 7
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Tham khảo tài liệu 'pentaho reporting 3.5 for java developers- p9', công nghệ thông tin, kỹ thuật lập trình phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Pentaho Reporting 3.5 for Java Developers- P9

example 279- 284 expression element, attributes 277 properties 185 grouping property 276 report 187 metadata, defining 277 running 190 module properties, defining 278, 279 summary 188 EXP(Value1) function 201 script 195 functions, formula F date time functions 199, 200 logical functions 200 FALSE() function 200 mathematical functions 201, 202 FIND(Search; Text[; Index]) function 202 miscellaneous functions 204, 205 formula expression 250 report specific functions 204 formula function text functions 202, 203 date time functions 199 logical functions 200 G mathematical functions 201 text functions 202 general group, rendering property formula function, implementing 3-D 156 about 285 anati-alias 156 Default Constructor method 286 bg-color 156 Description property 286 bg-image 156 display-name property 286 border-color 156 FunctionCategory getCategory() method plot-bg-alpha 156 286 plot-border 156 int getParameterCount() method 286 plot-fg-alpha 156 parameter..description property 286 show border 156 parameter..display-name property 286 Group Count function 188 public boolean isParameterMandatory(int grouping.ordinal property 294 position) method 286 grouping property 294 public Type getValueType() method 286 regex formula functio example 287- 290 H Type getParameterType(int position) method 286 HASCHANGED(Text) function 204 formula, working with HOUR (time) function 199 data types 197 HQLDataFactory, DataFactory functions 199 implementations operators 198, 199 DefaultSessionProvider 131 syntax 197 example 132- 134 FunctionCategory getCategory() method interface 130 286 StaticSessionProvider 131 functions HSQLDB advanced 192 about 54 common 186 configuring, with ElectroBarn Schema 54 image 194 HTML implementing 285 interactive reports 239 [ 352 ]
I ISEVEN(Value) function 205 Is Export Type function 188 icon property 294 ISLOGICAL(Value) function 205 IF(Expression; ReturnTrue; ReturnFalse) ISNA(Expression) function 205 function 200 ISNONTEXT(Value) function 205 image functions ISNUMBER(Value) function 205 barcode 194 ISODD(Value) function 205 sparkline 194 ISREF(Value) function 205 sparkline, properties 194 ISTEXT(Value) function 205 survey scale 195 initialize method 117 J installing Pentaho Reporting 29 JavaScript Expression 196 interactive reports, HTML Java’s Naming and Directory Interface about 239 (JNDI) append-body-footer property 239 using 124 append-body property 239 JFreeReport 10, 11 append-header property 239 JndiConnectionProvider, DataFactory class property 239 implementations CSS, including 241 examples 125 dashboard example 241- 245 Java’s Naming and Directory Interface events 240 (JNDI), using 124 JavaScript, including 241 setConnectionPath method 125 name property 239 setPassword method 125 on-click event 240 setQuery method 125 on-double-click event 240 setUsername method 125 on-key-down event 240 on-key-pressed event 240 K on-key-up event 240 KettleDataFactory, DataFactory on-mouse-down event 240 implementations on-mouse-move event 240 example 143- 145 on-mouse-over event 240 initializing 142 on-mouse-up event 240 Kettle tool 141 properties 239 reporting HTML DOM, manipulating 241 title property 239 L xml-id property 239 LabelElementFactory class 269 interactive reports, Swing layout.xml file, serialized report format event callbacks, retrieving 229 data-body 256 example 232- 238 data-body XML element 256 Internet Relay Chat. See IRC example 259, 260 IRC 21 group 255 int getParameterCount() method 286 group-body 256 INT(Value) function 201 layout-processors 255 ISBLANK(Value) function 204 layout XML elements 254 ISERROR(Value) function 204 preprocessor 255 ISERR(Value) function 205 primary namespaces 254 [ 353 ]
report elements 256 AVERAGEA(Value1; Value2; …) 201 report-footer 255 AVERAGE(Value1; Value2; ...) 201 report-header 255 COS(Value1) 201 LEFT(Text; Length) function 202 EVEN(Value) 201 legend group, rendering process EXP(Value1 201 legend-border 157 INT(Value) 201 legend-bg-color 157 LN(Value1) 201 legend-font 157 LOG10(Value) 201 legend-font-color 157 LOG(Value; Base) 201 location 157 MAXA(Value1; Value2; ...) 201 show legend 157 MAX(Value1; Value2; ...) 201 LEN(Text) function 202 MINA(Value1; Value2; ...) 202 line chart, supported charts MIN(Value1; Value2; ...) 202 example 166 MOD(Value1; Value2) 202 line-size property 165 ODD((Value) 202 line-style property 165 PI() 202 show-markers property 165 POWER(Value; Power) 202 use 165 SIN(Value) 202 link properties, elements SQRT(Value) 202 html-anchor 98 SUMA(Value1; Value2; …) 202 url 98 SUM(Value1; Value2; ...) 202 url-tooltip 98 VAR(Value1; Value2; …) 202 url-window-title 98 MAXA(Value1; Value2; ...) function 201 LN(Value1) function 201 MAX(Value1; Value2; ...) function 201 LOG10(Value) function 201 METADATA function 204 logical data type 197 Metadata Query Language (MQL) 135 logical functions, formula functions MetaTableModel API 320, 321 AND(Expression1; Expression2; ...) 200 MID(Text; Start; Length) function 202 FALSE() 200 MINA(Value1; Value2; ...) function 202 IF(Expression; ReturnTrue; ReturnFalse) MINUTE (time) function 199 200 MIN(Value1; Value2; ...) function 202 NOT(Expression) 200 miscellaneous functions, formula functions OR(Expression1; Expression2; ...) 200 CHOOSE(Index; Value1; Value2; ...) 204 TRUE() 200 COUNTA(Value1; Value2; ...) 204 XOR(Expression1; Expression2; ...) 200 COUNTBLANK(Reference) 204 LOG(Value; Base) function 201 COUNT(Value1; Value2; ...) 204 LOWER(Text) function 203 HASCHANGED(Text) 204 ISBLANK(Value) 204 M ISERROR(Value) 205 ISERR(Value) 205 mathematical functions, formula functions ISEVEN(Value) 205 ABS(Value) 201 ISLOGICAL(Value) 205 ACOSH(Value) 201 ISNA(Expression) 205 ACOS(Value) 201 ISNUMBER(Value) 205 ASIN(Value) 201 ISODD(Value) 205 ATAN2(Value1;Value2) 201 ISREF(Value) 205 ATAN(Value) 201 ISTEXT(Value) 205 [ 354 ]
NA() 205 OR(Expression1; Expression2; ...) function mobile reporting 200 about 316 output formats building 317- 319 cell outputs 112, 113 iPhone BI extension example 318, 319 paging 114 report, designing 318 report, viewing in Excel 113 report server, developing 317, 318 rich graphics limitations 114 module.description property 278 module.name property 278 P module.producer property 278 module.version.major property 278 padding styles, bands module.version.minor property 278 bottom 91 module.version.patchlevel property 278 left 91 MOD(Value1; Value2) function 202 right 91 MONTH (Date) function 199 top 91 Multidimensional OLAP Data Access page behavior properties, bands (MDX) 13 avoid-page-break 92 orphans 92 N pagebreak-before 92 widows 92 name attribute 277 page-break-after attribute 114 NamedStaticDataFactory, DataFactory page-break-before attribute 114 implementations Page function 186 example 121, 122, 123 Page Of Pages function 186 query syntax 120 parameter..description property 286 using 120 parameter..display-name property 286 name property 239 Pentaho Report Designer NOT(Expression) function 202 additional data sources 115 NOW() function 199 bands 88 Numeric data type 197 downloading 28 prerequisites 28 O report, building 30 user interface, components 85-88 ODD((Value) function 202 visual layout 105 on-click event 240 Pentaho Reporting on-double-click event 240 .prpt bundle file format 249 on-key-down event 240 about 5 on-key-pressed event 240 architecture 22 on-key-up event 240 Chart Editor 153, 154 on-mouse-down event 240 community 340 on-mouse-move event 240 Cross tabs 219 on-mouse-over event 240 DataFactory implementations 119 on-mouse-up event 240 data source example, setting up 53, 56 OpenDocument format (ODF) 23 data source metadata 319 Options group, rendering property expressions, implementing 275 horizontal 156 extending 275 series-colors 156 features 6, 10, 12 ordinal property 294 [ 355 ]
fonts, issues 112 IRC channel 340 fonts, working with 111, 112 online documentation 340 formulas,working with 196 Pentaho Reporting, features functions, properties 185 advanced reporting algorithm 12 GNU Lesser General Public License business friendly license 22 (LGPL) 5 charts, embedding 16 history 10, 11 Cross Tab Reports 18 installing 29 custom formulas 17 integrating, into Swing applications 41-45 data sources 13 integrating, into Tomcat J2EE 48-50 extensibility 21 Java API used, for building report 264 interactive reporting 18 LibFormula 196 Java API 21 output layer, working with 332 JFreeChart engine used 16 parameter types, defining 184 output formats 13, 14 Pentaho Report Designer 11 Pentaho Report Designer, using 15 Pentaho Reporting Engine 5 reporting server 21 Pentaho Reporting Engine Data API 115 report parameterization 16 Pentaho Reporting Flow Engine 11 rich authoring tools 20 Pentaho ReportingOutputProcessor rich formating 15 interface 333 roadmap 22 prerequisites 27, 28 style expressions 17 report function, implementing 275 sub-reports 17 shortcut key table 112 Pentaho Reporting Engine Data API sub-reports 209 about 115 supported charts 153 ContextAwareDataFactory interface 117 timeline 11, 12 DataFactory, deserializing 118 uses 6 DataFactory interface 115, 116 using, with BI server 305 DataFactory, serializing 118 Pentaho Reporting, architecture MetaTableModel interface 119 LibBase 22 TableModel interface 115, 117 LibDocBundle 23 Pentaho Reporting, extending LibFonts 23 BeanShell expression, implementing 290 LibFormat 23 expressions, implementing 275 LibFormula 23 formula function, implementing 285 LibLoader 23 report element, implementing 291 LibRepository 23 report functions, implementing 285 LibSerializer 24 Pentaho Reporting, output layer LibXml 24 DesignerContextAction, implementing 334 Report Engine Core project 24 OutputProcessor interface 333 Report Engine Extensions project 24 OutputProcessorMetaData interface 332 Pentaho Reporting, community PojoObject output example 334-339 backlog, viewing 340 RenderNode Document Object Model 333 bugs, submitting 340 Report Designer, updating 334 code, contributing 341 working with 332 Enterprise Edition 341 forums 340 founder, Thomas Morgner 340 [ 356 ]
Pentaho Reporting, using with BI server 3-D 156 about 305 advanced group 192. 193 ad hoc reports, creating 315 anti-alias 156 BI server, downloading 306 bg-color 156 BI server, installing 306, 307 bg-image 156 data sources, managing 313- 315 border 156 data users, managing 313- 315 border-color 156 permissions, configuring 310 chart-title 156 report bursting feature 310- 313 chart-title-field 156 report emailing feature 310- 313 data-source 155 report, publishing 307, 308 dependencyLevel 157 report, scheduling 308, 309 general group 156 pie chart, supported charts horizontal 156 example 168 legend-border 157 explode-pct property 167 legend-font 157 explode-slice property 167 legend group 157 ignore-nulls property 166 location 157 ignore-zeros property 166 name 155 label-format property 167 no-data-message 155 legend-label-format property 167 options group 156 rotation clockwise property 167 plot-border 156 PI() function 202 required group 155 PmdDataFactory, DataFactory series-colors 156 implementations show-legend 157 domain Id 135 title-font 156 example 136- 141 title group 156 IPmdConnection Provider 135 REPLACE(Text; Start; Length; New) XMI file 135 function 203 POJO (Plain Old Java Object) 12 report POWER(Value; Power) function 202 additional output formats, adding 51, 52 PreviewDialog API 229 dynamic images, including 180 property element, attributes embedding, in Swing application 38 hidden 277 embedding, in Tomcat J2EE application 45 mandatory 277 example, localizing 207 name 277 fields, localizing 206 value-role 277 internationalizing 205 public boolean isParameterMandatory(int Pentaho Reporting, incorporating into position) method 286 Swing application 41- 45 public Type getValueType() method 286 Pentaho Reporting, incorporating into Tomcat J2EE 48- 50 R reportbuilding, Pentaho Reporting’s Java API used 264 RelationalGroup class report parameterization 183 about 267 static images, including 180 configuring 268 Swing example application, setting elements, adding 267 up 38- 40 rendering property, supported charts [ 357 ]
Tomcat J2EE application example, setting registering 231, 232 up 45- 47 PageDrawable API, methods 232 report bands. See bands report parameterization report functions about 183 Hide Page Header & Footer 187 exceptions 184 Hide repeating 187 parameters, providing 184 Is Export Type 187 parameter types, defining 184 Row Binding 187 REPT(Text; Count) function 203 Show Page Footer 188 Resource Message Format Expression 234, Report Designer. See Pentaho Report 235 Designer report specific, formula functions report, building ISEMPTYDATA() 204 about 30 ISEXPORTTYPE(ExportDescriptor) 204 column headings, creating 34 METADATA(Field; Domain; Name) 204 common report bands 267 ROWCOUNT(GroupName) 204 dataset, defining 32 required group, rendering property data source, adding 265 data-source 155 data source, configuring 32, 33 name 155 details band, populating 35 no-data-message 155 elements, adding 268, 269 Rich Text Format (RTF) 13 expression, adding 266 RIGHT(Text; Count) function 203 functions, adding 266 Row Banding Function 187 Java API example 270-272 running function Java API used 264- 272 Average (Running) 191 layout, defining 267 Count (Running) 190 parameters, defining 265 Count Distinct 191 previewing 36 Group Count (Running) 190 RelationalGroup class 267 Maximum (Running) 191 report tittle, creating 34 Minimum (Running) 191 saving 36 Percent of total 191 starting with 30, 31 Sum(Running) 190 summary, creating 36 Wizard Java API 272 Q report element, implementing about 291 queryData method 116 ElementType class, defining 291 query syntax 116 element XML element, attributes 292 example 294-303 S metadata, defining 292-294 Script functions read and write handler, defining 294 Bean-Scripting Framework (BSF) report elements. See elements Bean-Scripting-Host (BSH) 195 ReportHyperlinkListener JavaScript 196 calling 230 Single Value Query 196 use case 230 SECOND(Time) function 190 ReportMouseListener serialized report format about 229, 231 .prpt bundle example file, building 263, 264 callbacks 231 [ 358 ]
.prpt bundle example file, running 263, 264 layout:page-footer element 261 about 249 layout:page-header element 261 additional files 262 layout:watermark element 261 content.xml file 262 page-definition element 260 datadefinition.xml file 250 style root XML element 260 dataschema.xml file 263 style-rule element 260 data source folder 253, 254 sub-reports layout.xml file 254 about 209 META-INF/manifest.xml file 262 adding 209 meta.xml file 263 chart sub-report example 215 mimetype file 263 multi-page sub-report example 210- 214 serialized report format settings.xml file side-by-side sub-report example 217, 218 250 SUBSTITUTE(Text; Old; New[; Which]) styles.xml 260 function 203 series dataset property, supported charts SUMA(Value1; Value2; …) function 202 category-column 161 SUM(Value1; Value2; ...) function 202 value-column 161 Summary function Single Value Query function 196 Calculation 190 SIN(Value) function 202 Count 188 size and position property, bands Count of Page 190 box-sizing 90 Group Count 188 dynamic-height 89 Maximum 189 fixed-position 90 Minimum 189 height 89 Sum 188 invisible-cosumes-space 89 Sum for Page 190 layout 89 Sum Quotient 189 max-height 90 supported charts max-width 90 about 153 preferred-height 89 area chart 162 preferred-width 90 area chart, example 162, 163 visible 89 bar chart 163 width 89 bar line chart 172 x location 89 bubble chart 174 x-overflow 90 Category Dataset 154 y location 89 category series rendering properties 157 y-overflow 90 dataset properties 160, 172 SQLReportDataFactory, DataFactory Extended XY Line chart 177 implementations Extended XY Line chart, Difference Chart DriverConnectionProvider 124 177 DriverConnectionProvider,configuring 124 Extended XY Line chart, example 178, 179 setting up 123 Extended XY Line chart, ext-chart-type StaticConnectionProvider 124 property 178 SQRT(Value) function 202 Extended XY Line chart, Step Area Chart styles.xml, serialized report format 177 about 260 Extended XY Line chart, StepChart 177 examples 261, 262 line chart 165 layout:layout-processors element 261 multi pie chart 170 [ 359 ]
multi pie chart, by-row property 170 RIGHT(Text; Count) 203 multi pie chart, example 171 SUBSTITUTE(Text; Old; New[; Which]) 203 multi pie chart, label-format property 170 TEXT(Value) 203 pie chart 166 TRIM(Text) 203 ring chart 169 UNICHAR(Number) 203 ring chart, example 170 UNICODE(Text) 203 ring chart, section-depth property 169 UPPER(Text) 203 scatter chart 175 URLENCODE(Text; Encoding) 203 scatter chart, dot-height property 175 text style properties, elements scatter chart, dot-width property 175 bg-color 96 scatter chart, example 176 encoding 97 series dataset 154 h-align 96 series dataset properties 161 line-height 96 Time Series Dataset 155 overflow-text 97 waterfall chart 171 text-color 96 waterfall chart, example 172 text-wrap 96 XY Area chart 176 trim 97 XY Bar chart 176 trim-whitespace 97 XY charts, example 177 v-align 96 XY Line chart 176 v-align-in-band 96 XY series dataset properties 161 TEXT(Value) function 203 XY series rendering properties 159, 172 Time data type 198 Survey Scale element 103 TIME function 230 Swing TIME(Hour; Minute; Second) function 272 interactive reports 229 timeline, Pentaho Reporting 11 Swing application TIMEVALUE function 230 Pentaho Reporting, integrating into 41- 45 TIMEVALUE(Text) function 272 report, embedding 38 title group setting up 38-40 chart-title 156 chart-title-field 156 T title-font 156 title property 239 TableModel interface, Pentaho Reporting TODAY() function 200 Engine Data API Tomcat J2EE application non-applicabe methods 118 additional output formats, adding 51, 52 using 117 example, setting up 45-47 Text data type 197 Pentaho Reporting, integrating 48-50 text functions, formula functions report, embedding 45 EXACT(Text1; Text2) 202 TRIM(Text) function 203 FIND(Search; Text[; Index]) 202 TRUE() function 200 LEFT(Text; Length) 202 T(Value) function 203 LEN(Text) 202 Type getParameterType(int position) LOWER(Text) 203 method 286 MID(Text; Start; Length) 203 REPLACE(Text; Start; Length; New) 203 REPT(Text; Count) 203 [ 360 ]
U x-incl-0 159, 172 x-max 159, 172 UNICHAR(Number) function 203 x-min 159, 172 UNICODE(Text) function 203 x-font 159 UPPER(Text) function 203 x-sticky-0 159, 172 URLENCODE(Text; Encoding) function 203 x-tick-fmt-str 159, 172 user interface, Pentaho Report Designer x-tick-font 159, 172 element properties 88 x-title 159, 172 menu and toolbar 86 x-tick-interval 159 messages panel 88 x-vtick-label 159, 172 report canvas tab panel 87 y-font 160, 172 report element palette 87 y-incl-0 160, 172 report Explorer 87 y-max 160, 172 uses, Pentaho Reporting y-min 160, 172 business intelligence reporting 7 y-sticky-0 160, 172 data warehouse reporting, examples 7 y-tick-fmt-str 160 financial reporting 8 y-tick-font 160, 172 financial reporting, features 9 y-tick-interval 160, operational reporting 6 y-title 160, 172 operational reporting, examples 6 operational reporting, limitations 6 Y V YEAR(Date) function 200 VAR(Value1; Value2; …) function 202 Z visual layout, Pentaho Report Designer 105 grid, enabling 105, 106 Z ordering 108 W WEEKDAY(Date) function 200 Wizard Java API defining 273 X xml-id property 239 XOR(Expression1; Expression2; ...) function 200 XY series dataset properties, supported charts x-value-column 161 y-value-column 161 XY series rendering property, supported charts enable-log-axis 160 log-format 160 x-font 159, 172 [ 361 ]
Thank you for buying Pentaho Reporting 3.5 for Java Developers Packt Open Source Project Royalties When we sell a book written on an Open Source project, we pay a royalty directly to that project. Therefore by purchasing Pentaho Reporting 3.5 for Java Developers, Packt will have given some of the money received to the Pentaho project. In the long term, we see ourselves and you—customers and readers of our books—as part of the Open Source ecosystem, providing sustainable revenue for the projects we publish on. Our aim at Packt is to establish publishing royalties as an essential part of the service and support a business model that sustains Open Source. If you're working with an Open Source project that you would like us to publish on, and subsequently pay royalties to, please get in touch with us. Writing for Packt We welcome all inquiries from people who are interested in authoring. Book proposals should be sent to author@packtpub.com. If your book idea is still at an early stage and you would like to discuss it first before writing a formal book proposal, contact us; one of our commissioning editors will get in touch with you. We're not just looking for published authors; if you have strong technical skills but no writing experience, our experienced editors can help you develop a writing career, or simply get some additional reward for your expertise. About Packt Publishing Packt, pronounced 'packed', published its first book "Mastering phpMyAdmin for Effective MySQL Management" in April 2004 and subsequently continued to specialize in publishing highly focused books on specific technologies and solutions. Our books and publications share the experiences of your fellow IT professionals in adapting and customizing today's systems, applications, and frameworks. Our solution-based books give you the knowledge and power to customize the software and technologies you're using to get the job done. Packt books are more specific and less general than the IT books you have seen in the past. Our unique business model allows us to bring you more focused information, giving you more of what you need to know, and less of what you don't. Packt is a modern, yet unique publishing company, which focuses on producing quality, cutting-edge books for communities of developers, administrators, and newbies alike. For more information, please visit our website: www.PacktPub.com.
Java EE 5 Development with NetBeans 6 ISBN: 978-1-847195-46-3 Paperback: 400 pages Develop professional enterprise Java EE applications quickly and easily with this popular IDE 1. Use features of the popular NetBeans IDE to improve Java EE development 2. Careful instructions and screenshots lead you through the options available 3. Covers the major Java EE APIs such as JSF, EJB 3 and JPA, and how to work with them in NetBeans 4. Covers the NetBeans Visual Web designer in detail DWR Java AJAX Applications ISBN: 978-1-847192-93-6 Paperback: 228 pages A step-by-step example-packed guide to learning professional application development with Direct Web Remoting 1. Learn Direct Web Remoting features from scratch and how to apply DWR practically 2. Topics such as configuration, testing, and debugging are thoroughly explained through examples 3. Demonstrates advanced elements of creating user interfaces and back-end integration Please check www.PacktPub.com for information on our titles
LWUIT 1.1 for Java ME Developers ISBN: 978-1-847197-40-5 Paperback: 364 pages Create great user interfaces for mobile devices 1. Make your applications stand out with dazzling graphics that look and behave the same on different mobile devices 2. Log information on the runtime behavior of your program 3. Write applications with attractive visual effects like transitions and animations 3. Use localization so that your applications can adapt to different languages and locales Flex 3 with Java ISBN: 978-1-847195-34-0 Paperback: 304 pages Develop rich internet applications quickly and easily using Adobe Flex 3, ActionScript 3.0 and integrate with a Java backend using BlazeDS 3.2 1. A step-by-step tutorial for developing web applications using Flex 3, ActionScript 3.0, BlazeDS 3.2, and Java 2. Build efficient and seamless data-rich interactive applications in Flex using a combination of MXML and ActionScript 3.0 3. Create custom UIs, Components, Events, and Item Renders to develop user friendly applications Please check www.PacktPub.com for information on our titles