People Code Based Reporting System People Soft Developers
People. Code Based Reporting System Ø People. Soft Developers always missed a decent Reporting System that is Integral and uses core programming language (People. Code). Ø Initially, People. Soft addressed reporting requirements thru third party software like SQR/Crystal. Ø Later, People. Soft introduced XML publisher. Ø However none of these software can be better than a Reporting System where Developer uses only People. Code that is also People. Soft core Programming Language. SRI Technologies Pty Ltd (www. sritech. com. au) 1
People. Code Based Reporting System A New Concept of Generating Reports in People. Soft Ø No SQR, Crystal, RFT File or XMLPublisher. Ø Just People. Code. Ø Colourful Crisp PDF Report Documents. SRI Technologies Pty Ltd (www. sritech. com. au) 2
People. Code Based Reporting System Fast Development Ø 80% of the code is auto-generated. Ø Developer needs to fill-in People. Code in the auto-generated template. Ø Developer codes only against Report Events like Report Header/Footer, On-Break etc. Ø Reporting System Assembles all People. Code functions to produce pdf report. SRI Technologies Pty Ltd (www. sritech. com. au) 3
People. Code Based Reporting System High Productivity Ø Handful of Report and Print APIs. Ø Produce PDF and/or CSV file. Ø Split PDF file based on conditional data SRI Technologies Pty Ltd (www. sritech. com. au) 4
People. Code Based Reporting System Report On Data Flexibility Ø Report is produced from Input Data Stream that can be from: v Database using SQL select: ü - While &SQL. Fetch(&Rec) … v Flat Data File ü - While &f. MYFILE. Read. Line(&Line) … ü - &FILE. Read. Rowset(); v Array ü - For &i = 1 To &Rec. Array. Len… SRI Technologies Pty Ltd (www. sritech. com. au) 5
People. Code Based Reporting System Programming Flexibility Ø Developer is in full control of the output. Ø Report page is available as canvas. Ø Use handful of Print/Draw methods to fill the page as you wish. v Print text, image, barcode, lines, boxes. Ø Output is only limited by the imagination of Developer. SRI Technologies Pty Ltd (www. sritech. com. au) 6
People. Code Based Reporting System Only Three Report APIs If &MY_REPORT. Init. Report(&Init. Args) = true then While &SQL. Fetch(&Rec) &MY_REPORT. Submit. Data(&Rec, …); End-while; &MY_REPORT. Finalize. Report(&Rec, …); End-if; SRI Technologies Pty Ltd (www. sritech. com. au) 7
People. Code Based Reporting System Handful of Print APIs Ø Print. Str - Print string on the current line at specified column position. Ø Print. Str. Abs - Print string at specified (x, y) point of the current page. Ø Print. Image - Print Image at specified (x, y) point of the current page. Ø Draw. Line - Draw Line from (x 1, y 1) to (x 2, y 2) points of the current page. Ø Draw. Box - Draw Rectangle from (x 1, y 1) to (x 2, y 2) points of the current page. Ø Print. Str. Wrap – Print string with wrap SRI Technologies Pty Ltd (www. sritech. com. au) 8
People. Code Based Reporting System Print Attributes (Font/Size/Colour) Ø Print String in variety of Fonts Ø Print String in variety of Font Sizes Ø Print String in variety of Font Colours SRI Technologies Pty Ltd (www. sritech. com. au) 9
People. Code Based Reporting System Print Attributes (Alignment) Ø Print string left justified Ø Print string right justified Ø Print string centring current line SRI Technologies Pty Ltd (www. sritech. com. au) on 10
People. Code Based Reporting System Print Attributes (Appearance) Ø Print text string in bold Ø Print text string in italic Ø Print text string with underline SRI Technologies Pty Ltd (www. sritech. com. au) 11
People. Code Based Reporting System Report Appearance Ø Report pages can be mix of: v Varying Page Sizes: ü A 0 to A 6, LETTER v Varying Page Orientations: ü Portrait, Landscape or mix v Varying Page margins v Varying Font sizes SRI Technologies Pty Ltd (www. sritech. com. au) 12
People. Code Based Reporting System Process Flow Reporting System Collection of Application Classes Instantiate Report App Class Object Initialize Report Loop Thru Data Input Stream 1. Receive Data Row 2. Submit Data Row to Report System 3. Consolidate Data Rows (if required) Report Events 1. rpt_begin, end 2. page_header, footer 3. detail_section, skip, init 4. On-Break Events People. Code maintained by Developer in System Created Templates Finalize Report aep_rpt. log Func. Lib People. Code PDF and/or CSV file SRI Technologies Pty Ltd (www. sritech. com. au) 13
People. Code Based Reporting System Advantages/Salient Features Ø Just People. Code: No other Programming Language skill required Ø High Productivity: Developer only codes against Report Events Ø Host Language is People. Code: Better than SQR/XML/XDO Languages Ø Ease of code management: All Reporting Objects are part of App. Designer Project Ø Fine control to developer: Code based Reporting System that gives full control to developer SRI Technologies Pty Ltd (www. sritech. com. au) 14
People. Code Based Reporting System Advantages/Salient Features Contd. . . Ø PDF/CSV File: Produced PDF and/or CSV Ø Large % of code is auto generated: Report Application Package and Reporting Events Functions template are auto generated Ø Split PDF file based on data conditions: Produce multiple output PDF files Ø One App Engine: Process and Report can be combined in one App Engine Program SRI Technologies Pty Ltd (www. sritech. com. au) 15
People. Code Based Reporting System Advantages/Salient Features Contd. . . Ø Flexible Input Data Stream: Report can be produced from variety of input data streams (Select-Loop/Flat File/Array). Report may NOT be based on one big complex Select Statement Ø Page sizes, Orientations: Report can have mix of page sizes/orientations Ø Font sizes/Colours: Variety of font sizes and colours supported Ø Integration: Well integrated with People. Tools SRI Technologies Pty Ltd (www. sritech. com. au) 16
People. Code Based Reporting System Advantages/Salient Features Contd. . . Ø Use of existing Business Logic: Developers can make use of business logics already available as People. Code function/methods in their reports Ø Exclude Data from the report: Developers can exclude data from the Input Stream just before Printing them Ø Open Source System SRI Technologies Pty Ltd (www. sritech. com. au) 17
People. Code Based Reporting System Cost Benefit/Savings Ø People. Code based Reporting System is very simple, flexible, powerful and integral that makes it a cost effective Business Intelligence Reporting option under People. Soft. Ø Better than conventional BI solutions that are complex, restrictive, external, expensive and ineffective. SRI Technologies Pty Ltd (www. sritech. com. au) 18
People. Code Based Reporting System Useful Related Links Ø Reporting System: www. sritech. com. au/rpt_main. php Ø Page Attributes: www. sritech. com. au/rpt_pages. php Ø Fonts and Colors: www. sritech. com. au/rpt_fonts. php Ø Sample Reports: www. sritech. com. au/rpt_examples. php SRI Technologies Pty Ltd (www. sritech. com. au) 19
People. Code Based Reporting System Examples/Reference Docs Ø My First PDF Report Using People. Code: www. sritech. com. au/my_first_pdf_report_using_peoplecode. pdf • • • Application Engine People. Code: www. sritech. com. au/aep_my_frst_pdf_rpt_appengine. txt Func. Lib People. Code: www. sritech. com. au/aep_my_frst_pdf_rpt_funclib. txt PDF report generated: www. sritech. com. au/aep_my_frst_pdf_rpt. pdf Ø Printing PDF Invoice Using People. Code: www. sritech. com. au/aep_printing_invoice_using_peoplecode. pdf • • • Application Engine People. Code: www. sritech. com. au/aep_printing_invoice_appengine. txt Func. Lib People. Code: www. sritech. com. au/aep_printing_invoice_funclib. txt PDF report generated: www. sritech. com. au/inv-0001. pdf SRI Technologies Pty Ltd (www. sritech. com. au) 20
People. Code Based Reporting System Interested to explore further ? Ø Download Fully Functional copy of the software. Ø Url: www. sritech. com. au/download. php SRI Technologies Pty Ltd (www. sritech. com. au) 21
People. Code Based Reporting System Presentation by SRI Technologies Pty Ltd Web Site: www. sritech. com. au Thank you !!! SRI Technologies Pty Ltd (www. sritech. com. au) 22
- Slides: 22