Training manual/guide
Contents
1. 18 Build a data source 18 Flat File Data 19 IDB Data SOULCe ass sees ese ere eee eee eee eS eee oe eee eee 19 b Prepared by Mian Aasim Mahmood Page 3 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer C Scripted Data Source 19 d Web Services Data Source 19 e AIVIL Data SOUNET AERE a T ra a aa a a Oe Soe etre A 19 18 Build a data set ee 20 19 How to Create Drill down Reports 23 20 Presenting the Data Set in a Table or Lay out the report 23 21 View the Report 24 22 Saving the Report ee 24 23 Howto Deploy and Export the Reports 25 24 How report open in web browser 25 25 How view report in report viewer 25 26 How to Export the Reports in different formats 26 27 Report deployment options2. 27 28 APls ee eee eee ee 27 a Design Engine API DE API 27 b Report Engine API RE API 27 C Chart Engine API CE API 27 d IRunAndRenderTask 27 e IRunTask 27 f IGetParameterDefinitionTask 27 g IDataExtractionTask 27 29 How to Create and Configure and Apply the Master Page 28 30 Designing the page header and footer 28 31 Howto display text in the header and footer 28 32 Specifying a header size 29 33 Displaying page numbers the current date and other text 29 34 Displaying an image 30 35 Excluding header content from the first page 30 36 How to exclude header content from the first page 30 37 Howto Create the Cross Tabs reports 31 38 Creating across ta
3. Group Row3 Group Row4 and Group Row5 Now drag fields from column of Available Fields to column of Group and Summaries Prepared by Mian Aasim Mahmood Page 33 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Group Dimensions Group Column 1 this group create using Add button Container Size Name this field drag from Available fields Group Row1 this group create using Add button Shipper Name this field drag from Available fields Group Row2 Commodity Name Group Row3 Sector Name Group Row4 Port of Departure Group Row5 Line Name Summery Field Already this head is available there Total Container this field drag from Available fields we create this field in Computed columns Cross Tab Cube Builder Cross Tab Cube Builder Organize your data for the cross tab by specifying grouping hierarchies and summary data fields Name Data Cube dsCross Available Fields Groups and Summaries Container Saf Code E Shipper Name El Group Rowa E Comodity Name Group Rows Container Sige Mame Load List Cde Sector Name E e El Group Rowd Add Shipper Name shipping Line Code Shipping Line Name shipping Line Short Name Total Container Tea m g int Shipper Code str Load List No m E Port of Departure Name Edit E Group Row5 ES E Shipping Line Name Delete Ga Summa
4. Style N Bookmark 3 eee E Can shrink User Properties Font Sane Sent Named Expressions Event Handler Color i Black Dianea Whitespace Auto O No Wrapping Lat Normal Element ID Height Background color I Auto Display T Size Block m points ep M Preformatted e Outline BIRT reports are organized as a tree structure with the overall report as the root and separate categories for styles report content data sources data sets report parameters and more The Outline view provides a compact overview of your entire report structure P ca ti Resour O i y t Navigat Outline K a E rptCity rptdesign 4 B Data Sources A dsRilGroup a Data Sets gt E dsCity fa Data Cubes Report Parameters thy E Variables Body MasterPages CA SRESE Styles Embedded Images Libraries T Scripts G Prepared by Mian Aasim Mahmood Page 11 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Resource Explorer BIRT allows the reuse of report objects such as tables data sources and styles Objects created for reuse are stored in a library file To browse the contents of report libraries BIRT supplies a Resource Explorer view This view list all libraries within the resource folder in addition other shared content such as images and JavaScript files tS Navigat o Outline fm Resour 3 gt
5. Query Define a sql query text using available items dsRilGroup Query Text a db_accessadmin lexec procRptcCity 8 db_backupoperator 2 TE db datareader TE db_datawriter ER db_ddladmin OR M3 db_denydatareader if we want to use query then write WB db_denydatawriter select statement 2 db_owner GE db_securityadmin BE dbo 1 select from tblcity E guest TE INFORMATION_SCHEMA TE sys Schema All Filter All Show system tables Show alias Apply Filter When adding selected items to SQL Quote all identifiers es SQL SELECT statement in Edit Data Set 6 Choose Finish to save the data set If you typed the query correctly Edit Data Set appears If you made a mistake an error message appears before Edit Data Set opens Edit Data Set displays the columns you specified in the query and provides options for editing the data set 7 Choose Preview Results to make sure the query is valid and that it returns the correct data Prepared by Mian Aasim Mahmood Page 21 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Data Source Query Output Columns Computed Columns Parameters Filters Bahawalnagar Bahawalnag Property Binding Bahawalpur Bahawalpur Settings Bhakkar Bhakkar Preview Output Parameters Bhalwal Bhalwal Preview Results lt I Burewala Burewala Chailianwala Chailianwala I Total 8 0 record s shown Data r
6. x project E rptCity rptdesign prjRILGROUP Project in the Navigator view Create a new report You can create a report in the following ways Start with a blank report design amp Use a predefined report template For each template BIRT Report Designer provides a cheat sheet which contains step by step instructions to help you create the report Start with a blank report design 1 Choose File gt New gt Report New Report appears New Report is slightly different in BIRT RCP Report Designer New Report ba Report Create a new report Enter or select the parent folder prjRILGROUP lt E prjAFU E prjRIL i prj RILGROUP lt I Filename rptCity rptdesign Pec Ne New Report in BIRT Report Designer In BIRT Report Designer in the tree view of the available folders select the project that you created 1 This step applies only to BIRT Report Designer users Prepared by Mian Aasim Mahmood Page 16 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 2 Type the text as the file name rptCity rptdesign 3 Choose Next New Report provides options for starting with a blank report and several report templates anme i Choose the type of report you want to create ole Report templates Preview a Standard Blank Report lt 3 Ell My First Report Simple Listing Grouped Listing Dual Column Listing Dual Column Chart amp
7. I 1 I 7 3 aop onea ned oa 5 Ai Country Name Province Name City Code City Short Name City Name z Country Mame Province Name City Code City Short Name City Name E F TT i t Layout Master Page Script AML Source Preview Prepared by Mian Aasim Mahmood Page 10 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer e Report Preview You can test your report at any time with real data The preview is a window directly within Eclipse El rptCity rptdesign 52 Refresh Report at Note Current maximum number of data rows ts limited to 0 Click to change Preview Preferen Country Name Province Name City Code Pakistan Punjab 1 Pakistan Punjab 2 Fakistan Punjab 3 Pakistan Puniah 4 a mi m Layout Master Page Script XML Source Preview City Short Name Attock Bahawalnagar Bahawalpur Rhakkar City Name Attock Bahawalnagar Bahawalpur Ahakkar e Property Editor Presents the most commonly used properties in a convenient format that makes editing quick and easy BIRT also integrates with the standard Eclipse property view to provide a detailed listing of all properties for an item E Property Editor Table 2 Ek Problems E Properties Properties Binding Groups Map Highlights Sorting Filters General General onder Mame Margin Page Break Width 5 938 in Visibility Vertical alignment Auto Table of Contents
8. Prepared by Mian Aasim Mahmood Page 17 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Connecting to the database Build a data source Before you begin designing your report in the layout editor you build a BIRT data source to connect your report to a database or other type of data source When you build a data source you specify the driver class data source name and other connection information that is specific to the type of data source For this tutorial you use the sample database Classic Models that is already configured for use with BIRT Report Designer You do not need to specify the connection information for this sample database Choose Data Explorer If you use the default report design perspective Data Explorer is to the left of the layout editor next to Palette If Data Explorer is not open choose 1 Window gt Show View Data Explorer oo J se Palette ES Data B ylorer x rea E Data Sources Data Sets New Data Source Ga Data Cubes iggy Report Parar LE Paste nA Variables Data Explorer 2 Right click Data Sources then choose New Data Source from the context menu New Data Source displays the types of data sources you can create New Data Source Select a Data Source Type or Choose a Connection Profile Provide all the settings for a new data source or choose a pre defined connection profile Create from a data source type in
9. Listing Ell Side by Side Chart amp Listing El Chart amp Listing Cross Tab Description Create a blank report with no predefined content _ Show Report Creation Cheat Sheet a o Report templates in New Report 4 Select Blank Report then choose Finish Your new report appears in the main window This aoe Mie the layout editor The layout editor shows an empty report page File Edit sisi Data ii Navigate Project Run Window Help 3 il Bi yiQ iGM ihr rSero i 10x fH Fe E Report Design G E Palette 5 3 a Data Explorer Ba ptdesign r Pointer Select iS Rectangle Select Report Items h Label AZ Text ab Dynamic Text E Data al Image EE Grid E List E Table lft Chart E Cross Tab E Quick Tools Aggregation Layout Master Page Script XML Source Preview es Navig 2 E Outlin f Reso 2A 2 Property Editor Report Da E Problems E Console E Properties aop a B g oY Properties prjAFU General General 5 prjRIL a a 2a lt m Description Author L Cormeen Created by Eclipse BIRT Designer Version 3 7 1 v20110905 Build lt 3 7 1 v20110905 1820 gt ues Propet Path CA Users aasim mahmood workspace pjRILGROUP rptCity ptdesign RTE Title Event Handler Themes None Report Orientation Left To Right R Blank report design
10. No syntax error was found in current script BX a bow Container Size Name Operators Iii Wiides WWW Category Sub Category Double Click to insert Available Data Sets E dsCrossTak ll Load List Code a Native JavaScript Function str Load List No BIRT Functions int Shipper Code Operators Shipper Name 4l 7 4 om e Choose Preview Results to confirm that the query is valid and that it returns the correct data If you created the SELECT statement and computed field correctly you should see the results in Preview Result These are the data rows that the query returns Prepared by Mian Aasim Mahmood Page 32 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Data Source Preview Results Query Apat Columns Load Gigs ety PE ne Shines Shaaper hha Geus o E A as Portis Parole Computed Columns ISB 4261 4110 ERC KIM C GEAR WHE 36 klamat 4114 BLOOME COMPUTE 64 JFE INT 4115 ALTON L ELECTRO 55 Los Ani 4116 RIETER Spare Parts 65 ZRH ZL 4119 THERM BURNER 31 GT 4122 BYWORT Purnp Unit 68 TALBUI aara P Cama a S o i a E i a en ae ee Parameters Filters Property Binding Settings Preview Output Para Preview Results A oO Un amp WwW ho ke Total 1 000 record s shown Result contains more records that are not displayed e Choose OK to save the data set Add
11. O a amp Shared Resources oo Introduction E a rptCity rptdesign Cheat Sheets Learning a new tool is always a challenge but Eclipse offers an innovative solution cheat sheets These are short bits of documentation that walk you through new tasks EARBA Sheets E3 h po My First Report The customer listing report tutorial helps you build your first report It provides step by step instructions for building a report that lists customer names phone numbers and contact names The report uses data from the sample database ClassicMlodels s b Start the tutorial CF E Chek to Restart Script Editor Scripting adds business logic to reports during data access during report generation or during viewing The code editor provides standard Eclipse features for editing your scripts syntax coloring auto complete and more An interesting new feature for BIRT 2 3 is the ability to debug scripts while the report is running We can add these tools from Main menu gt Window gt show View gt Data Explorer ri Q oe f New Window fy Tie es ee ST Wt New Editor Palet I Data 22 E lA data view is not available Open Perspective k Project Run Window Help Show View 3 Data Explorer 5 i Customize Perspective Navigator Save Perspective As a Outline Alt Shift Q 0 ar Reset Perspective ia Palette Ch Close Perspect
12. The workspace is the directory where your work will be stored If you do not specify otherwise Eclipse creates the workspace in your user directory C Users username workspace This workspace directory is used as the default content area for your projects as well as for holding any required metadata For shared or multi workspace installs you must explicitly specify the location for your workspace using the dialog or via the data command line argument Prepared by Mian Aasim Mahmood Page 7 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer BIRT should look like the following illustration New Window New Editor Hide Toolbar Welcome to the Eclipse IDE for Java a Open Perspective Show View Customize Perspective Save Perspective As Reset Perspective Close Perspective Close All Perspectives Navigation Preferences Now click the Window menu a drop down will open Menu gt Window gt Open Perspective gt Others Now a dialog box will open like i 5 ey pa 7 n F faa CVS Repository Exploring Database Debug Lig Database Development r Debug Jawa Gd Java Browsing 7 Java EE default fe Java Type Hierarchy amp Java Script JPA C Planning Plug in Development EB Remote System Explorer is Report Design Fa Resource Eo Team Synchronizing Gi Weh Now select the Report Design and press button OK Prepa
13. a cross tab to the report You use the palette to add a cross tab 1 Choose the palette then drag a cross tab element from the palette to the report A cross tab appears in the report 5 tptCrossTabuptdesign 5 gt E Cross Tab gt eae pa em ize acae phe ante Eire ege poe ecreis eme poe ete bre ene poe eoe Go ange pae eme ie nr poe eme Tze eme poe ente o E l Drop data fieldfs to define columns here oo 5 4 MW j _ Layout Master Page Script XML Source Preview 2 Choose Data Explorer expand Data Sets and then expand dsCrossTab data set name to display the fields in the data set Organize data for the cross tab 1 Drag field Container Size Name into the cell of column Cross Tab Cube Builder appears Or in Data Explorer gt Cube gt right click gt New In this procedure you set up e A data group or dimension whose values to use as the row headings e A data group or dimension whose values to use as the column headings e Asummary field or measure whose aggregate values to use in the cells of the cross tab 2 Now open new dialog box with the name of Cross Tab Cube Builder Leave the name field as default cube name There are two columns with the name of Available fields and second is Group and Summaries In column of Group and Summaries add a new group using Add Button with the name of Group Column1 Then add another group with the name of Group Row1 Group Row2
14. and pre configured for use Installation of the BIRT All in One package is as simple Once you have downloaded required package unzip the package into your chosen directory C Eclipse as base installation directory This will create an eclipse directory that contains eclipse exe Run eclipse exe to start the designer For BIRT 2 2 and later you will need Java 1 5 This is the same for Windows or any UNIX like Operating System Create a windows short cut e From the desktop right click choose New Shortcut e For location enter C Eclipse eclipse exe without quotes e Click Next e Enter Eclipse for the shortcut name Running Eclipse After installing the Eclipse SDK in a directory you can start the Workbench by running the Eclipse executable included with the release you also need a Java SE 5 JRE not included with the Eclipse SDK On Windows the executable file is called eclipse exe and is located in the eclipse sub directory of the install Double click the eclipse exe INDIGO Loading Workbench cl Copyright Eclipse contributors and others 2000 2011 All rights reserved Eclipse is a trademark of the Eclipse Foundstion Inc Gracle and Java are registered trademarks of Oracle and or itsafiliates Other names may be trademarks of their respective owners Selecting a workspace When the Workbench is launched the first thing you see is a dialog that allows you to select where the workspace will be located
15. choose Add e On Grand Total use the default values then choose OK e Preview the report Grand totals appear in the last row and last column of the cross tab A new column is added to the cross tab i rptCrossTab rptdesign x SA Refresh Report Note Current maximum number of data rows is limited to 0 Click to change Preview Preferences Grand Total 1 10Feet 20Feet 40Feet Hon Total Container Container BLOCKING Lahore Dry Port EQUIPMENT AND TOOLS LONDON AIRPORT SPARE PARTS HEATHROW AIR PIA PORT LONDON Steel Foot Lahore AirPort PIA Steel Rod COLOMBO AIR PORT Lahore AirPort PIA SEOUL AIR PORT 2 KOREA AB HARBIN FOOD YEAST EXTRACT FLAV Singapore Seaport INGREDIENTS CO LTD R BASE19 Fi dji Layout Master Page Script AML Source Preview Cross tab with a new column to display grand totals Format the cross tab Now that the cross tab displays the correct data we can focus on improving the presentation of data in the cross tab we perform the following tasks in this section e Display string in empty cells e Use darker lines around the cross tab and around the cells Display string in empty cells If there is no container for a particular Shipper name the cell displays nothing Because an empty cell can be interpreted as missing data you can display a string such as 0 00 or to indicate that the value iS zero 1 Choose Layout to return to the layout editor 2 Select the cro
16. the following list lt Create from a connection profile in the profile store Classic Models Inc Sample Database Flat File Data Source Hive Datasource JDEC Database Connection for Query Builder Scripted Data Source Web Services Data Source XML Data Source Data Source Name dsRilGroup lt Cancel New Data Source Prepared by Mian Aasim Mahmood Page 18 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer a Flat File Data Source Supports tab comma semicolon and pipe delimited data b JDBC Data Source Supports connections to relational databases c Scripted Data Source Allows you to communicate with Java objects or to any data you can get from you application d Web Services Data Source Supports connections to a web service A wizard helps you point at a service through a WSDL and select the data e XML Data Source Supports data from XML 3 Select Classic Models Inc Sample Database from the list of data source types Use the default data source name and then choose next Connection information about the new data source appears New IDEC Data Source Profile 28 Create a new data source Create a new cata source Driver Class com microsoft sglserver jdbc SQLServerDriver 4 0 lt Database URL jdbcisqlsersern sh sereer databasenarme dbRIL User Name ril E sija Password TT lt lt INDI URL Manage Oriwers Test Connection Bid
17. DOH Steel Foot Lahore Air Port PLA 0 0 0 1 rl Steel Rod COLOMBO AIR 0 0 0 1 PORT ia J i Hi gt i Layout Master Page Script XML Source Preview Border lines around the cross tab and around the cells BIRT uses two predefined styles crosstab and crosstab cell to set the default appearance of the overall cross tab and the cells respectively 1 Choose the Outline view 2 Expand the Styles item to show the crosstab and crosstab cell styles ts Nav n Out x itt Res a ER 4 fal rptCrossTab rptdesign gt A Data Sources Data Sets ial Data Cubes ga Report Parameters i Variables E Body ig MasterPages a H Styles 44 crosstab A crosstab cell A report ee Embedded Images Gd Libraries amp Scripts Outline view displaying the crosstab styles Prepared by Mian Aasim Mahmood Page 38 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 3 Right click the crosstab style then choose Edit Style 4 On Edit Style choose Border The colors of the borders are set to Gray 5 Change the color of all the borders to Black Style Modify the desired style properties All report elements that use this style are automatically updated to reflect the new format General Border Font Background Style Text Block Box Top Solid x Border Bottom Solid v Format Number SSNS Format DateTime Left Solid Format String Right Solid Page Break
18. DP As ODS As SA As PDF As POSTSCRIPT As PPT and As XLS File Edit Insert Element Data Page Navigate Search Project Run Window Help t E 1 Pie HA Gr en m E a El Debug Report l A View Report r amp os Generate Document Fi 5 Data i O E rptCity rptdesign as a A a T Data SBR ai External Tools E dskilGroup Data Sets 4 i Ga Data Cubes G Report Parameters i 5 Variables Country Name Province Name City Code Country Name Province Name City Code E Prepared by Mian Aasim Mahmood 1 In Web Viewer 2 As DOC 3 As HTML 4 As ODP 5 As ODS 6 As ODT 7 As PDF 8 As POSTSCRIPT 9 As PPT As XLS Page 26 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Report deployment options Once you create your report designs there are several different ways to generate the report output Obviously you can run these reports directly from the BIRT Designer but you can also run BIRT reports from the command line generate BIRT reports from you Java application using the BIRT APIs integrate and customize the example web viewer or deploy your reports with third party components and report servers AP Is BIRT supplies several APIs and an example J2EE application for generating and viewing reports The major APIs are the Design Engine API DE API Report Engine API RE API and the Chart Engine API CE API In add
19. If the header size you specify however is not sufficient to display a large image the report overrides the specified header size and resizes the header to display the image in its entirety Increasing the header size is one way to increase the space between the header content and the report content However because header size applies only to PDF output this technique is not recommended if you want to create a master page that serves both PDF and HTML output equally well The preferred technique to add space between the header content and report content is to increase the padding at the bottom of the text or label element placed in the header Alternatively if you use a grid to organize multiple elements you can add a row at the bottom of the grid and set the row size Property Editor Master Page 23 gt Problems E Properties a O Properties General General padise Mare Simple MasterPage Margin Header Footer Header height 13 in Background color EC Auto iy Comments Footer height 0 5 in Orientation Auto Advanced Width 8 5 in Type US Letter hi Height 11 in Displaying page numbers the current date and other text Common header and footer information includes the page number report generation date company name author name copyright information and confidentiality statements BIRT Report Designer provides predefined text elements for displaying some of these common items including the cur
20. Map Width Highlights Comments Top Restore Defaults et Border colors set to Black 6 Choose OK to save your change to the crosstab style 7 In Outline right click the crosstab cell style then choose Edit Style Use the same steps to set all the border colors to Black then choose OK In the layout editor the lines around the cells and around the cross tab appear in black Refresh Report Note Current maximum number of data rows is limited to 0 Click to change Preview Preferences AB HARBIN FOOD AST EREERGF FLAV R Seaport INGREDIENTS COLTD YEAST EXTRACTS Pompei CHINA POV ABB ELEKTRIK SANAYI A S SWITCHGEAR TYPE ISTANBUL PORT himin c a rm huowyv Steel Rod a AIR Eara Air Port Sep AIR PORT aji Master Page Script XML Source Preview Cross tab showing black borders 8 Preview the report shows a portion of the generated cross tab Prepared by Mian Aasim Mahmood Page 39 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Link CSS file with report 1 In Resource Explorer right click Shared Resources then choose Add Resource ts Navig Qutlin fait Resou am Cf es aw Shared Reso New b Add Resource Copy Paste Delete Move Rename ae Refresh Choose Add Resource 2 In Add Resource specify the CSS file to place in the resource folder e In Source File type the path to the CSS fi
21. NT AND TOOLS LONDON AIRPORT 2 SPARE PARTS HEATHROW AIR PORT PIA 1 ONDON Steel Foot Lahore Air Port PIA 1 Steel Rod COLOMBO AIR PORT 4 Lahore Air Port PIA 1 SEOUL AIR PORT 2 KORFA AB HARBIN FOOD INGREDIENTS CO YEAST EXTRACT FLAV R BASE19 Singapore Seaport 1 LTD YEAST EXTRACTS POWDERS QINGDAO CHINA 1 SFAPORT ABB ELEKTRIK SANAYIA S SWITCHGEAR TYPE UNIGEAR ISTANBUL PORT 2 TURKY ABB INDUSTRIES L L C TURBO RECON BEARING ASSY C S LA36 DUBAI PIA 1 CHARGING DIVISION DURAI HAF FAGSS3390 ABB OY DRIVES FREQUENCY CONVERTER HEL SINKI PORT 1 lt 4 tre b Layout Master Page Script XML Source Preview Preview of the cross tab data In preview mode the row headings display the Shipper Name Commodity Name Sector Name Port of Departure and Line Name the column headings display Container Size 10 Feet 20 Feet 40 Feet Non Container and the summary Cell display the totals number Ha aa a a ee ae TOT 77 z7r Pe Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Add grand totals in Cross Tab Row Wise Each number that is displayed in the cross tab represents the container total of a particular shipper name for a particular commodity name In this procedure we can add grand totals to display the total container for each container size e Choose Layout to return to the layout editor e In layout editor select the cross tab border e In Property Editor choose the Row Area tab e Choose Grand Totals th
22. Page 23 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer In the layout editor the table cell in which you dropped the Country Name field contains a data element that displays Country Name Above this data element is a label element that the layout editor automatically added to the header row This label displays the field name as static text It serves as the column heading 7 Drag Province Name from Data Explorer and drop it in the second cell in the detail row 8 Drag City Code and drop it in the third cell in the detail row 9 Drag City Short Name and drop it in the third cell in the detail row 10 Drag City Name drop it in the third cell in the detail row 11 Choose Preview the tab at the bottom of the layout editor BIRT Report Designer generates and displays the report in HTML format Scroll down to see the entire report View the Report Finally our report is finished Preview the results by clicking on the Preview tab which is located along the bottom of the view Alternatively you may select a preview option from the File menu Refresh Report Note Current maximum number of data rows ts limited to 0 Click to char El rptCity rptdesign 3 70 Country Name Province Name City Code City Shorn Name City Name Pakistan Punjab 1 Attock Attock Pakistan Punjab 2 Bahawalnagar Bahawalnagar Pakistan Punjab 3 Bahawalpur Bahawalpur Pakistan Punjab a Bhakkar Bhakkar Pakistan P
23. SE BIRT Report Designer How to Create and Configure and Apply the Master Page BIRT provides two kinds of master pages a simple master page with just a page header and footer and a graphic master page that provides full control over page layout A base master page element provides the properties common to the two master page types E rptCity rptdesign eo O gt 4 Layout Script XML Source Preview Designing the page header and footer The default master page includes a text element that displays the current date in the page footer If you preview your report you see that the current date appears on the bottom left of every report page You can delete or edit this text element You can add other elements to the master page by dragging them from the palette and dropping them in the page footer or header Observe the following rules m You can place elements in the header and footer only You do not place elements in the report content area because the contents of those elements would overlap report data m You cannot place more than one element directly in the header or footer To place multiple elements insert a grid then insert the elements in the grid How to display text in the header and footer 1 In the layout editor choose the Master Page tab The layout editor displays the master page The palette displays additional elements under AutoText specifically for use in the master page 1 To display a single text ele
24. Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Training manual guide Eclipse BIRT Prepared by Mian Aasim Mahmood Page 1 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer ECLIPSE Business Intelligence and Reporting Tools BIRT Eclipse IDE for Java and Report Developers Version Indigo Service Release 1 Build id 20110916 0149 c Copyright Eclipse contributors and others 2000 2011 All rights reserved About Eclipse Eclipse IDE for Java and Report Developers s Version Indigo Service Release 1 Build id 207 10916 0149 c Copyright Eclipse contributors and others 4000 2011 All rights reserved Visit http eclipse org This product includes software developed by the Apache Software Foundation http apache org i HDOOODO Installation Details Prepared by Mian Aasim Mahmood Page 2 of 43 Solution Heights Pvt Ltd OMNANAABOTH wR AO THN DB e e e O zaa paNn ow e Ss m N za gt panow j k 13 14 15 16 17 a User Manual Guide of ECLIPSE BIRT Report Designer Sr No Topic Page No BIRT Overview 05 BIRT Report Introduction 05 a a oe Ne 05 Charts 05 Crosstabs 05 L
25. ag and drop functionality live chart preview data filtering and parameterization Chart elements can be presented in PNG JGP BMP and SVG output which support drilling through and highlighting toggling visibility and client side script e Cross Tab The Cross Tab element is also new for BIRT 2 2 and can be used to display data contained within a BIRT data cube In previous versions of BIRT the number of columns in a table element had to be known at design time whereas with the cross tab element the number of columns and rows can be dynamic This element also supports hierarchal aggregation and display of data allowing cube dimensions to be placed on rows and columns and measuring data to be displayed at appropriate intersections e Aggregation Aggregation elements are new for BIRT 2 2 and provide functionality to add aggregate elements to the report using the new aggregation builder The Aggregation Builder supplies over twenty five different functions such as SUM MIN MAX and AVERAGE For reference http www infoq com articles birt2 intro Prepared by Mian Aasim Mahmood Page 14 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Start New Report Using Query and Stored Procedure Crate a new project You can create one project to organize all your reports or create multiple projects to organize your reports by categories For each project that you create Eclipse creates a directory in yo
26. ate shortcut urati A if Add to favorites 4 my H View source Layout Master Page Script XML Source Preview When you want to view your report first open the BIRT RCP Designer on your desktop Then open the shortcut in a web browser and you should see the report as HTML The report will be updated every time the link is refreshed How view report in report viewer In Preview mode right click on report name in Navigate window A popup window will appear with many option select Report gt Run Report like illustration 3 Palette Data Explorer gt A R rptCity rptdesign 3 Refresh Report Note Current maximum number of data rows is limited to 0 Click to change Preview P New gt Country Name Province Name City Code City Short Name City Name Open Pakistan Punjab 1 Attock Attock Open With gt p Pakistan Punjab 2 Bahawalnagar Bahawalnagar Copy Pakistan Punjab 3 Bahawalpur Bahawalpur a SI Paste SS Navigator of O S Del Pakistan Punjab Bhakkar Bhakkar m elete D e gt prjAFU ec Pakistan Punjab 5 Bhalwal Bhalwal E pr i a amp prjRILGROUP Rename Pakistan Punjab 6 Burewala Burewala ie project Sa Import Pakistan Punjab 7 Chailianwala Chailianwala E rptCity rptdesigt i kad EPEC Hy tp J t Export Pakistan Punjab 8 Chakwal Chakwal Refresh Pakistan Punjab 9 Chichawatni Chichawatni E l n Report gt G Generate Document gt Validate A Run Report Source Previ
27. b 31 39 gt Create a NEW TeDOl lex acces tech een A eater aie ae ee et aera e a Bee 31 40 Build a data source 31 41 Build a data set 31 42 Add across tab to the report 33 43 Organize data for the cross tab 33 44 Insert data in the cross tab 35 45 Add grand totals in Cross Tab Row Wise 36 46 Add grand totals in Cross Tab grand total s Column Wise 37 47 Format the cross tab 37 48 Display string in empty cells 37 49 Border lines around the cross tab and around the cells 38 50 Howto link CSS file on Report 40 Prepared by Mian Aasim Mahmood Page 4 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer BIRT Overview 1 BIRT Report Introduction BIRT is an Eclipse based open source reporting system for web applications especially those based on Java and Java EE BIRT has two main components a report designer based on Eclipse and a runtime compone
28. columns and detail rows to create for the table The dialog also prompts you to select a data set to bind with the table 3 In Insert Table specify the following values e Number of columns 5 e Number of details 1 Insert Table Table size Number of columns 5 Number of details 1 Data Set None E Auto Summarize On Use these dimensions for new tables 4 Choose Data Explorer 5 In Data Explorer expand Data Sets and then expand City The columns that you specified in the query appear below City 6 Drag Country Name from Data Explorer and drop it in the first cell in the table s detail row The detail row displays the main data in the report In the generated report the detail row repeats to display all the data rows from the data set S Pal B Dat 3 gt O 53 rptCity rptdesign 23 E a Data Sets os a Eoo os Fa eo ae a Fa e Foe eo Ea ce Es cn a e EP dsCity te City Code City Short Name City Mame Province Code Ls Data Sources m ny fu Province Name City Code City Short Name City Name Country Mame Province Mame City Code City Short Name City Name Province Mame Country Code Country Name Record Status ial Data Cubes fy Report Parameters fs Variables ima p po fie fim e Th j Layout Master Page Script XML Source Preview 2 Dragging a column from Data Explorer and dropping it in a table cell Prepared by Mian Aasim Mahmood
29. eld s to define rows 6 Group Column1 drag Container Size name and drop it in the cross tab area that displays Drop data field s to define columns 7 Summary Fields drag Total Container and drop it in the cross tab area that displays Drop data field s to be summarized here Ho se Palette 8 Data Explor 23 Ea rptCrossTab rptdesign 23 0 amp Data Cubes Ea gt DataCube dsCrossTab p IFT na s Ea aA pa i g A a rs SO ma Sa o h Se a i SC a Se pa j Oe Ga Groups Dimensions T mi a 8 Group Columni E Container Size Nap l Group Rowl El Shipper Name l Group Row2 E Comodity Name l Group Row3 El Sector Name l Group Row4 El Port of Departure Nar l Group Row5 El Shipping Line Name Comodity A Name Sector E Name Port of M Departur Shipping gt Line Name er Here Heer Hers Shinra gf IS iTotai Container J Eq Container_ Group Rows Or Pa Rows Fields Group Columns or Columns Field Jg t lt T t Layout Master Page Script XML Source Preview gj Summary Fields Measures Hil Summary Field El Total Container Inserting data in the cross tab 8 Choose Preview to preview the cross tab output E rptCrossTab rptdesign 22 ad Refresh Report Note Current maximum number of data rows ts limited to 0 Click to change Preview Preferences 10Feet 20Feet 40Feet Non Container 3 AA F E BLOCKING Lahore Dry Port 1 EQUIPME
30. en choose Add e On Grand Total use the default values then choose OK E Property Editor Cross Tab 14 Be Problems C Properties Ea O Properties Binding Row Area column Area Map Highlights Sorting Filters Sub Totals Grand Totals Grand Totals I Page Break pu yO OO Data Field i dd Grand Total m i ees Edit Grand Total Remove Creating grand totals in the cross tab row area A new row is added to the cross tab In this row is a label that displays Grand Total pptrossTabyptdesign DE Refresh Report Note Current maximum number of data rows is limited to 0 Click to change Preview Preferences FRANCE ALCOHLIC BEVERAGES DRINKS TO INCLUDE BOND ITEMS NEW ORLEANS i LISTEN AFL OW ALCON LABORATORIES INC CORNEAS COLAMBO AIR PORT COLOMBO AIR PORT i ELECTRO SURGICAL Los Angeles Air Port L INSTRUMENTS PIA 2 ALCON PHARMACEUTICALSLTD ELECTRO SURGICAL Los Angeles Air Port PIA i SWITZERLAND INSTRUMENTS ma OPHTHALMIC EQUIPMENT ZURICH AIR PORT PIA l Grand Total 4 T40 556 919 4 it Layout Master Page Script XML Source Preview ry Cross tab with a new row to display grand totals Prepared by Mian Aasim Mahmood Page 36 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Add grand totals in Cross Tab grand totals Column Wise e In Property Editor choose the Column Area tab e Choose Grand Totals then
31. et k l ee 2 New Data Set Create a new data set Data Source Selection type filter text JDBC Data Source dsRilGroup Data Set Type SOL Stored Procedure Query Data Set Name dsCity SOL SELECT QUERY SOL Stored Procedure Query Cancel New Data Set 3 Use the default values for the other fields e Data Source Selection shows the type and name of the data source that you created earlier e Data Set Type indicates that the data set uses a SQL Stored Procedure query Prepared by Mian Aasim Mahmood Page 20 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 4 Choose NextThe Query page displays information to help you create a SQL query Available Items lists all the schemas in the data source including CLASSICMODELS which you use for this tutorial and other reports you want to create with the sample database You can click the plus sign next to CLASSICMODELS to display the tables The text area on the right side of this dialog shows the following required keywords of a SQL SELECT statement 5 Inthe text area type the following SQL SELECT statement Exec ProcrptCiry Although the data set editor shows table and column names in uppercase letters you can type these names in the case you prefer because SQL is not case sensitive If you do not want to type the query you can drag columns and tables from Available Items to the text area e New Data Set
32. etters amp Documents 2 522 ec rrr ner re rere nee 05 Compound Reports 05 The Anatomy of Report 05 Dalar aa Na aN a E E a A aaa a A 05 Data Transforms 05 BUSINGSS LOE CA ts testen R a eee A R a E S 05 Presentation tesisine aa Se See Sr a a eee See ees 05 Prerequisite of BIRT 06 Requirements 06 Where Do Get BIRT 06 Installing BIRT from the All in One Installation 06 How to Install and Configure 07 Create a windows short cut 07 Selecting a workspace 07 Basic Tools of BIRT Report Designer 09 Data Explorer 09 Palette eee een re rr re rn rr rr rrr erect ceee 10 Navigator 10 LAVOUL VIEW S e RADA nanne Ses ses eae seer se Sea eS See e Sees 10 Report Preview 11 Propert
33. ew Show in Remote Systems view gt Debug Report R A gt Sn Px Problems E Console 2 Properties un As After click the sub menu Run Report main report will open in BIRT report viewer in report viewer there is a button on top with the name of Export report Prepared by Mian Aasim Mahmood Page 25 of 43 Solution Heights Pvt Ltd S BIRT Report Viewer E Qa User Manual Guide of ECLIPSE BIRT Report Designer BIRT Report viewer tl EY B a B Province Name City Short Name Punjab Attock Funjab Bahaw alnagar Punjab Bahawalpur Punjab Bhakkar Punjab Bhalwal Burewala Punjab How to Export the Reports in different formats On click the button a dialog box will appear Export report City Name Attock m e Bahawainag Bahawalpur Bhakkar Bhalwal Burewala Now we can export our report in many formats like Excel Post Script PDF Word Power Point Open Document Text etc using combo of Export Format We can also use other options according to our printing requirements using this dialog Export Report Export Format PDF i rc S MMMM Alpages Current page Pages Enter page number s andor page range s For example 1 6 or 1 3 6 Auto O Actualsize Fitto whole page Another way to export the repot in different format is like as illustration Main menu gt View Report gt different format like Web viewer As Doc As HTML As O
34. i Settings New Data Source Driver Class com microsoft sqlserver jdbc SQLServerDriver v4 0 Database URL jdbc sqlserver sh server databasename dbRIL 4 Choose Finish BIRT Report Designer creates a new data source that connects to the sample database It appears within Data Sources in Data Explorer E Palette H8 Data Explorer s4 EH a A Data Sources E dsRilGroup 3 Data Sets gl Data Cubes iy Report Parameters A Variables Data Sources in Data Explorer Prepared by Mian Aasim Mahmood Page 19 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Build a data set Now you are ready to build your data set A data set identifies the data to retrieve from the data source If your report connects to a JDBC data source such as the sample database you use a SQL SELECT statement to specify the data to retrieve To create a new Data Set right click on the Data Set folder and select New Data Set from the context menu 4 A Data Sources o dsRilGroup ay Palette 8 Data Explorer 3 gt EEN E Data Sets p Ga Data Cul New Data Set lg Report P New Joint Data Set i Variables G Paste 1 In Data Explorer right click Data Sets and choose New Data Set from the context menu 2 In New Data Set dialog box select the data source select the data set type there are two data set type one for Store procedure and second for open select query S New Data S
35. ian Aasim Mahmood Page 13 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer e List Presents data from a data set in any kind of format List elements also act as containers for other elements Lists differ from other container elements in that they iterate over data sets that are bound to the list The default list element has a header footer and detail section When the list is rendered the header and footer are usually displayed once while the detail section is displayed for every row of the data set that is bound to the list Within the detail section you may have a text element or another container element such as a grid table or another list e Table Table elements are similar to list in that they are container elements that iterate over bound data sets but are represented in tabular format The table element layout is similar to an HTML table Table elements have header footer and detail sections as well as columns e Chart Displays a business chart such as a pie chart line chart etc The chart element allows charts to be inserted into the report design When a chart element is placed in the Report Editor the Chart Builder Wizard automatically displays This wizard is used for designing the chart and offers three design tabs Select Chart Type Select Data and Format Chart Thirteen primary chart types and many combinations of sub types are available with BIRT 2 2 The Chart Builder provides dr
36. ition to the APIs BIRT supports scripting using either Java or JavaScript within report designs e Design Engine API DE API Use the Design Engine API DE API to create a custom report designer tool or to explore or modify BIRT report designs The BIRT Designer uses this API You can call this API within a BIRT script to modify the currently running report design e Report Engine API RE API Use the Report Engine API to run BIRT reports directly from Java code or to create a custom web application front end for BIRT e Chart Engine API CE API Use the Chart Engine API to create and render charts apart from BIRT Birt report engine tasks There are several tasks supplied by the Report Engine API that can be used to generate report output A few key tasks are listed below e RunAndRenderTask Use this task to run a report and create the output directly to one of the supported output formats This task does not create a report document e RunTask Use this task to run a report and generate a report document which is saved to disk e IGetParameterDefinitionTask Use this task to obtain information about parameters and their default values e DataExtractionTask Use this task to extract data from a report document The BIRT viewer uses this class to extract report data into CSV format For Reference BIRT Reference Card Started with BIRT pdf Prepared by Mian Aasim Mahmood Page 27 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIP
37. ive ia Problems Alt Shitt Q X Close All Perspectives Properties Property Editor fables f iit Resource Explorer L a Other Alt Shift Q Q Prepared by Mian Aasim Mahmood Page 12 of 43 Solution Heights Pvt Ltd Report Items Elements User Manual Guide of ECLIPSE BIRT Report Designer BIRT provides a variety of report items or Elements for use when creating your report Report items appear in the Palette view Report items include i pees e Data Explorer Fy k Pointer Select i Rectangle Select i Report Iterns Label Al Text ab Dynamic Text E Data Insert a text block wi al I optional CLOB Data ee Expression s FER Grid List Table liig Chart ER Cross Tab E gt Quick Tools E Aggregation Label Label elements are used for displaying static text As with most report elements the text can be externalized for localization and supports such properties as hyperlinking font sizing and highlighting Simple piece of text such as City Name Text Displays a multi line block of text defined within the report Can contain embedded formatting and value expressions Text that can include HTML formatting and computed values Used to create headings form letters mail merge effects etc Use to include richly formatted text to your report including the ability to integrate HTML formatting with your dynamic data Dynamic Text Displays a database column tha
38. ject in which to save your report 3 Type the report name like rptCrossTab or any required name 4 Choose Finish A blank report appears in the layout editor Build a data source Before you begin designing your report in the layout editor you create a data source to connect your report to the database 1 Choose Data Explorer 2 Right click Data Sources and choose New Data Source from the context menu 3 Select JDBC data source from the list of data sources use the default data source name then choose next Select driver class and Database URL from combo Type user name and password of database and test the connection using button of Test Connection 4 Choose Finish BIRT Report Designer creates a new data source that connects to the sample database It appears within Data Sources in Data Explorer Build a data set In this procedure you build a data set to indicate what data to extract from different tables 1 In Data Explorer right click Data Sets and choose New Data Set 2 On New Data Set select the Data Source type the name of Data Set like dsCrossTab 3 Use the default values for the other fields o SQL Select Query if we want to get data on report through select query o SQL Stored Procedure Query if want to get data on report through already define SP 4 Choose Next Query displays the information to help you create a SQL query The text area on the right side shows the required keywords of a SQL SELECT statemen
39. le or choose Browse to locate and select the file e In File Name optionally type a new name for the CSS file e In Folder read only path value shows the location of the BIRT resource folder Add the CSS file to this root folder or choose Browse to select a subfolder in which to place the CSS file e 4 Choose Finish The CSS file appears in Resource Explorer and it is available to any report design Expand the file to display all styles Example of values specified in Add Resource Add Resource Add Resource Add resource to resource folder Source File D Manual amp Guide for BIRT Eclipse CS5 File StleBIRT ces Browse File Name StyleBIRT css Folder C Users aasim mahmood workspace prjyRILGROUP Browse Add Resources with values supplied fs Navig G Qutlin f Resou 3 eel amp 4 arees Fa rptCity rptdesign i rptCrossTab rptdesign a E styleSheet css AccordDiv accordion ontent accordionHeader alternatetd BigBoldT ext BigBoldT extWhite Big T ext E E E Resource Explorer showing the styles in a CSS file Prepared by Mian Aasim Mahmood Page 40 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 3 Link the CSS file to the report by performing the following tasks e Choose Outline e Right click Styles then choose Use CSS File e In Use CSS choose Browse to select the CSS file to link to the report The Browse dialog di
40. ment in the header or footer drag the desired element from the palette and drop it in the header or footer For example to display the page number insert either the Page element or the Page n of m element 2 Todisplay multiple text elements in the header or footer a Insert the grid element in the header or footer Delete the date element from the default footer first b On Insert Grid specify the number of columns and rows for the grid If for example you want to display two elements on the same line specify 2 columns and 1 row i rptCity rptdesign 3 i gt E Header gt E Grid gt SAAZIO INTES NATH ONAL Layout Script XML Source Preview Prepared by Mian Aasim Mahmood Page 28 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Specifying a header size The size of the header in the generated report can be different when rendered in PDF and in HTML For an HTML report the header dynamically resizes to accommodate its contents and the header always appears directly above the report content In an HTML report the header height property is ignored For a PDF report the header also dynamically resizes to accommodate its contents Unlike the HTML report you can specify a fixed size for the header If you specify a header size of one inch and you insert an image that is half an inch in height the report displays half an inch of space between the image and the report data
41. nload the BIRT visit http download eclipse org birt downloads Prepared by Mian Aasim Mahmood Page 43 of 43
42. nt that you can add to your app server BIRT also offers a charting engine that lets you add charts to your own application With BIRT you can add a rich variety of reports to your application e Lists The simplest reports are lists of data As the lists get longer you can add grouping to organize related data together orders grouped by customer products grouped by supplier If your data is numeric you can easily add totals averages and other summaries e Charts Numeric data is much easier to understand when presented as a chart BIRT provides pie charts line amp bar charts and many more BIRT charts can be rendered in SVG and support events to allow user interaction e Crosstabs Crosstabs also called a cross tabulation or matrix shows data in two dimensions Sales per quarter or hits per web page e Letters amp Documents Notices form letters and other textual documents are easy to create with BIRT Documents can include text formatting lists charts and more e Compound Reports Many reports need to combine the above into a single document For example a customer statement may list the information for the customer provide text about current promotions and provide side by side lists of payments and charges A financial report may include disclaimers charts and tables all with extensive formatting that matches corporate color schemes 2 The Anatomy of Report BIRT reports consist of four main parts data data tran
43. ontent from the first page 1 Inthe layout editor choose Master Page The layout editor displays the master page 2 In the property editor choose Header Footer The property editor displays the header and footer properties 3 Deselect Show header on first 4 Choose Preview to verify the report output If the report contains more than one page the header content appears on all pages except the first Property Editor Master Page 3 aru Problems H Properties ma O Properties ay 1 Border Header Footer Margin a V Show header on first V Show footer on last Header Footer Comments Advanced For reference http my safaribooksonline com book databases birt 0321442598 designing a multipage report ch21levisec3 Prepared by Mian Aasim Mahmood Page 30 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Create the Cross Tabs reports Creating a cross tab This tutorial provides instructions for creating a cross tab that displays sales totals by state and product line The cross tab uses data from different tables in the Sample database Now you perform the following tasks e Create a new report e Build a data source e Build a data set e Add across tab to the report e Organize data for the cross tab e Insert data in the cross tab e Add grand totals e Format the cross tab Create a new report 1 Choose File gt New gt Report 2 On New Report select a pro
44. option to apply HTML only selectors such as link and visited to customize the style of hyperlinks e Choose Include CSS file at view time e In URI type the location of the CSS file Type a full or relative URL 6 Choose OK The linked CSS file and its styles appear under Styles in Outline The style names appear in gray indicating that they are not defined in the report design but rather are linked from an external file Outline sae a linked CSS file and its styles Ez Navigator ne Outline ms Ti Resource Ex E P a B retCrossTab rptdesign GA Data Sources gt sa Data Sets b Lal Data Cubes G3 Report Parameters js Variables gt E Body bs Ly MasterPages Styles 44 crosstab Aq crosstab cell 44 report CSS file 4 StyleBIRT css linked to ma Embedded Images the report E Libraries Scripts Prepared by Mian Aasim Mahmood Page 42 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer http www opensourcestrategies com ofbiz ofbiz birt odf http www javabeat net articles print ohp article id 75 http www meteorite bi report design with birt http www infog com articles birt2 intro http my safaribooksonline com book databases birt 0321442598 designing a multipage report ch21levisec3 Visit http eclipse org For tutorial visit htto www eclipse org birt ohoenix tutorial For information Visit http www ecliose org birt phoenix intro For Dow
45. ows returned by a SQL SELECT statement 8 Choose OK When you re finished the Data Set should look like the Figure 1 13 1 Notice that the result columns are part of the list This is important because we can drag these columns onto objects in the view to create an association between a view object and the result column lt 2 Palette H8 Data Explorer X aml CA Data Sources 2a Data Sets dsCity City Code City Short Name City Name Province Code mg Province Name Country Code Country Name Record Status G Data Cubes G Report Parameters ifs Variables m a a a Prepared by Mian Aasim Mahmood Page 22 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Create Drill down Reports Presenting the Data Set in a Table or Lay out the report In this procedure you insert elements in the report page to display the data from the data set that you created previously You start by inserting a table element then you insert data elements in the table It is important to understand the functionality that the table provides The table lterates through all the data rows that a data set returns Enables you to lay out data easily in a row and column format 1 Choose Palette The palette displays all the elements that you can place in a report 2 Drag a table element from the palette and drop it in the report in the layout editor Insert Table prompts you to specify the number of
46. red by Mian Aasim Mahmood Page 8 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Now Eclipse BIRT Report Designer open like bellow illustration S Report Design Eclipse i i sl I I AMY le Cl File Edit Navigate Search Project Run Window Help a ie Q7 Egr y v ARa Fy WA Report Design G me Palette Ki t8 Data Explorer E zA oe A palette is not available 5 Navig g Outlin 52 fi Reso O l Property Editor i Problems Console Properties Tos A line i i 5 as y M OE Oe SEE The property editor is not available Basic Tools of BIRT Report Designer Application development with BIRT starts with the report designer This Eclipse based set of plug ins offers a variety of tools to build reports quickly Some of these are listed below e Data Explorer Organizes your data sources connections and data sets queries The data set editor allows you to test your data set to ensure the report receives the correct data Within this view multi dimensional cubes can be created using existing data sets Cubes are currently used when building dynamic cross tables This view also is used to design report parameters ze Palette R Data Explorer 23 i peta ie 4 Data Sources E dsRilGroup a amp Data Sets dsCity City Code City Short Mame City Mame Province Code a mn m i A Province Mame i Country Code Country Name Record Status Ga Data C
47. rent date page number author name and file name These items are available on the palette when the master page is displayed E En rptCityrptdesign x F E Footer E Grid gt nm d co Printed By at Raazig Head Office Print Date amp Time lt valueof gt new Da Page Numi fi Bi 4 HT I Layout Script AML Source Preview Prepared by Mian Aasim Mahmood Page 29 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Displaying an image You can insert static and dynamic images in a master page You insert an image in a master page the same way you insert an image in the report layout The difference is that you cannot insert an image inside a table in the master page Therefore when you insert a dynamic image directly on the master page the same image the image in the first data row appears on every page i rptCity rptdesign 1 mn E Header 3 Grid gt JAA ZO ikt PSaRATIONS e ma H Script XML Source Preview i Layout Excluding header content from the first page It is common practice to display header content on every page except the first For example a report displays a title in bold and large font on the first page but in a smaller font at the top of the other pages Controls whether headers appear on all pages or all except the first as described in the following procedure How to exclude header c
48. ry Fields Measures Drop a field here to create a su H Summary Field El Total Container COUNT Cross Tab Cube Builder displaying two groups and a summary field 3 Choose Finish to save the cube message box appear in cross tab dialog box Cross Tab A data cube has been created successfully To finish creating a cross tab drag the fields from the created data cube to the cross tab container Don t show this message again 4 Press button ok Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Insert data in the cross tab Saved Cube appear in Data Explorer You insert data from the cube into the row column and detail areas of the cross tab e Drop data field s to define column here e Drop data field s to define rows here e Drop data field s to be summarized here 1 On Data Explorer gt Data Cube dbCrossTab under the first group Group Row1 drag Shipper Name and drop it in the cross tab area that displays Drop data field s to define rows 2 Group Row2 drag Commodity Name and drop it in the cross tab area that displays Drop data field s to define rows 3 Group Row3 drag Sector Name and drop it in the cross tab area that displays Drop data field s to define rows 4 Group Row4 drag Port of Departure and drop it in the cross tab area that displays Drop data field s to define rows 5 Group Row5 drag Shipping Line Name and drop it in the cross tab area that displays Drop data fi
49. s to the BIRT newsgroups where you can ask questions about BIRT The homepage is also where you can get the various BIRT distributions such as the All In One Eclipse package which is Eclipse pre packaged and configured with BIRT the BIRT Standalone Report Designer and information about retrieving and building BIRT from source We can also install BIRT as a plug in to go into an already existing Eclipse installation or you can retrieve the BIRT Standalone RCP package Installing BIRT from the All in One Installation As with most BIRT installations the All in One package is available from the Download BIRT link http download eclipse org birt downloads This will typically take you to the current and stable release of BIRT The developers seem to agree that the All in One package is the typical way to go as it is the first link on the page _ Se Home Downloads Users Members Committers Resources Projects About Us Search 9 i amp E he Sata ote pop BIRT Report Downloads BIRT Home Latest BIRT Report Designer Release Build 3 7 1 5 The fastest way to get started designing BIRT reports on Windows Introduction Everything you need to start designing BIRT Reports including the full Eclipse SDK Download Pre requisites Java 1 5 JDK JRE Install Already have Eclipse installed Get all the BIRT plugins for your existing Eclipse environment or use Update Manager Pre requisites Java 1 5 JDK JRE BIRT hss dependencies on
50. sforms business logic and presentation e Data Databases web services Java objects all can supply data to your BIRT report BIRT provides JDBC XML Web Services and Flat File support as well as support for using code to get at other sources of data BIRT s use of the Open Data Access ODA framework allows anyone to build new UI and runtime support for any kind of tabular data Further a single report can include data from any number of data sources BIRT also supplies a feature that allows disparate data sources to be combined using inner and outer joins e Data Transforms Reports present data sorted summarized filtered and grouped to fit the user s needs While databases can do some of this work BIRT must do it for simple data sources such as flat files or Java objects BIRT allows sophisticated operations such as grouping on sums percentages of overall totals and more e Business Logic Real world data is seldom structured exactly as you d like for a report Many reports require business specific logic to convert raw data into information useful for the user If the logic is just for the report you can script it using BIRT s JavaScript support If your application already contains the logic you can call into your existing Java code e Presentation Once the data is ready you have a wide range of options for presenting it to the user Tables charts text and more A single data set can appear in multiple ways and a single repor
51. splays the resource folder and the CSS files in the folder ts Naviga DE Outline 3 imi Resour 0O 7 a Gil rptCrossT Use C55 File i Ug Data 3 b es Data S gt amp Data d Import CSS Style B Ma Repor New Style Us Variabj b C Body Delete p Lf Maste A Paste p Silis a Embedded Images a Libraries h Scripts Choose Use CSS File Reload CS File Select a C55 file to be included inthe report w ze Shared Resources StyleBIRT css 9 Please select a file Browse showing the CSS file in the resource folder 4 Select the CSS file then choose OK Use CSS displays the selected CSS file and the styles in that file Use CSS Use CS5 file in report design Select a CS5 file from shared libraries folder and use its styles in report design File Name StyleBIRT css Include C55 file at view time Apply only to HTML format View time location of the CSS file URI e g http mydomain test css myfolder test css Available styles from StyleBIRT css Ad tl 44 colhead 4 skint i reports header Notifications Yl in body Cannot import style I OK Cancel Use CSS showing the selected CSS file and its styles Prepared by Mian Aasim Mahmood Page 41 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 5 Optionally link a CSS file at report view time using the following steps Use this
52. ss tab Select the entire cross tab by clicking on the tab in the lower left corner of the cross tab 3 In Property Editor choose the Properties tab then choose Empty Rows Columns 4 Infield of In For empty cells type O Prepared by Mian Aasim Mahmood Page 37 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Property Editor Cross Tab 3 8 Problems E Properties po 0 Properties Binding Row Area Column Area Map Highlights Sorting Filters Margin aas Empty Rows Columns gon Select the checkbox if empty rows and columns are to be shown at a cross tab level Border o q E Show empty rows Comodity Name Page Break Sector Name Visibility Port of Departure Name Shipping Line Mame Empty Rows Columns Table of Contents Bookmark aes show empty columns Comments User Properties 7 Named Expressions Event Handler Advanced For empty cells show 0 a I F Empty Rows Columns properties of the cross tab 5 Preview the report Cells that were previously empty now display 0 E iptCrossTabuptdesign 2 Refresh Report Note Current maximum number of data rows ts limited to 0 Click to change Preview Preferences Grand Total 10Feet 20Feet 40Feet Non Total E Container Container AA F E BLOCKING Lahore Dry Port 0 0 0 EQUIPMENT AND TOOLS LONDON AIRPORT 0 0 0 2 2 SPARE PARTS HEATHROW AIR PLA 0 0 0 1 a PORT LON
53. t 5 We can use SQL SELECT statement to indicate what data to retrieve we can type the column and table names or we can drag them from Available Items to the appropriate location in the SELECT statement or we can call the Stored Procedure from database using EXEC SPName like EXEC ProcRptLkpExportFclData Prepared by Mian Aasim Mahmood Page 31 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer e Choose Finish to save the data set Edit Data Set displays the columns specified in the query and provides options for editing the data set e Choose Computed Columns and then choose New to create a computed field that calculates required fields e On New Computed Column specify the following values Dialog box name New Computed Columns a In Column Name type Total Container b In Data Type select String c In Aggregation leave it blank d In Expression type row Container Size Name e Choose OK to save the computed field New Computed Column Column Name Total Container Data Type String Aggregation Expression row Container Size Name Fy OK Cancel Alternatively We can open the expression builder to construct the expression by selecting the appropriate data set fields data set field names are case sensitive in Expression you typed row Container Size Name Expression Builder JavaScript E Soe Expression Builder G
54. t can contain HTML formatted CLOB data Allows for advanced CLOB data manipulation through expressions Use to integrate your static text with dynamic or conditional data Data Displays a database column or a computed value Provides formatting data set or computed value with optional formatting Data elements are the essential element for displaying values from data sources Using the Expression Builder data values can be altered and manipulated For example if a data set contains a column for first name and another for last name using the expression builder you can concatenate the values into one data element Use to include data from your connection in the report dataSetRow contactLastName dataSetRow contactFirstName Image Any kind of image supported by a web browser Image elements are used to include pictures in the report output BIRT supports retrieving images from a URI embedding the image in the design dynamic images BLOB from a data source and image files in a resource folder Grid Provides a tabular arrangement of report items much like an HTML table Grid elements act as containers for other report elements and are used to position elements in a logical manner Grid elements are configured in tabular format For example if your report is displaying product sales and you want a chart representation to the right of your table data you would add a grid element with one row and two columns Prepared by M
55. t can present data from multiple data sets Prepared by Mian Aasim Mahmood Page 5 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer Prerequisite of BIRT Requirements BIRT has a fairly small set of requirements to run depending on your use There are no Operating System requirements to run BIRT as it is a Java application and should run on any platform that Java will run on For the BIRT Report Designer any platform that will run Eclipse will work e As far as hardware requirements are concerned recommendation is at least a Pentium 3 processor with at least 512 MB of RAM for the BIRT Report Designer e For BIRT 2 2 and later you will need Java 1 5 Eclipse 3 7 requires at least a Java SE 5 Eclipse 3 7 is compatible with Eclipse 3 6 and all earlier 3 x versions If you had installed additional features and plug ins into your old Eclipse you should re install them in the new Eclipse e For the connectivity with SQL server required driver of JDBC sqljdbc4 you can download this driver from here http www mediafire com 3ycmaelhoot http www 4shared com file 3aJkYoTN sgljdbc4 html Where Do Get BIRT The typical location for everything that is related to BIRT is going to be the Eclipse website at http www eclipse org birt phoenix This will bring you to the BIRT homepage Here you can get the latest news on BIRT including status of upcoming releases news on books conferences and acces
56. the following Eclipse projects In certsin downlosds such as the Allinone these sre already included but in others such as the framework you will be required to downlosd them Tutorial Sample Database Examples integration FAG Wiki Communi ty Choose a Reference Designer Version 3 7 1 SDK Download e eee es Project Organization Project Development Plan Building BIRT 4 Went a dedicated report designer Simple to use RCP Version of the BIRT Report Designer for report developers on the Windows platform Pre requisites Java 1 5 JDK JRE m ke 1 J is Latest BIRT Runtime Release Build 3 7 1 Need to deploy BIRT into your Jave Javs EE spplicstion Get the deployment components of BIRT You do not need this if you are just Deployment ETR e sa ao M ta 0 Y 0 g Need a different download Additionally older and pre release versions of BIRT are available from the More Downloads section of the BIRT Download Page From this link you can retrieve older releases current milestone builds and the latest nightly release for those who want to stay on the cutting edge Prepared by Mian Aasim Mahmood Page 6 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Install and Configure The BIRT All in One installation package is a large ZIP file roughly 242 Mb This ZIP file contains a full Eclipse installation with the BIRT plug ins already installed
57. ubes f Report Parameters m A Variables Prepared by Mian Aasim Mahmood Page 9 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer e Palette Contains the standard BIRT report elements such as labels tables and charts and is used in conjunction with the Layout View to design reports aes Palette x B Data Explorer k Pointer Select 0 Rectangle Select i Report tems Ebi Label AE Text ab Dynamic Text E Data Insert a text block wi Gal Image Spina 8 ia HE Grid J List E Table ling Chart ER Cross Tab Quick Tools E Aggregation e Navigator Under the navigator you can create and manage projects reports libraries templates and various other files that would be contained in your projects If you wanted to rename the folder or create folders to organize report elements such as file locations it can all be done under the Navigator The Navigator can be used to do many of the same functions that you can perform under the menu bar under the File section If your workspace contains many different reporting projects you can also use the Navigator to go into those projects GS Navigat 3 a pe Outline fii Resour O Fl i E prjAFU ES prjRIL a EE pRILGROUP X project z rptCity rptdesign prjRILGROUP e Layout View Layout editor that provides drag amp drop creation of the presentation portion of your report E mptCityptdesign 5 H fal gt
58. unjab I Bhalwal Bhalwal Pakistan Punjab E Burewala Burewala Th 4 ih I Layout Master Page Script XML Source Preview Preview of report data Saving the Report To save the report select Save from the File menu This preserves all the work you ve done up to this point as a rptdesign file and allows you to resume the report creation at a later time The rptdesign file is also used to generate a report to the user dynamically as will be described in the next section Prepared by Mian Aasim Mahmood Page 24 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer How to Deploy and Export the Reports How report open in web browser Once you saved your report as an rptdesign file you can use the report as HTML by using a web browser In Preview mode right click on the window and select Create Shortcut from the context menu as shown in the illustration BIRT will place a URL shortcut on your desktop that contains the rptdesign file El rptCity rptdesign 23 oa Refresh Report Note Current maximum number of data rows ts limited to 0 Click to change Preview i Country Name Province Name City Code City Short Name City Name Fakistan Punjab 1 Peace aaa Back Pakistan Punjab 2 Tare walnagar Pakistan Punjab 3 Wwalpur Pakistan Punjab a car Pakistan Punjab 5 fal Pakistan Punjab 6 Wala Select all Pakistan Punjab T anwala Pakistan Punjab a wal Datliotan OQirniah m o Cre
59. ur file system Eclipse organizes files by projects You can create one project to organize all your reports or create multiple projects to organize your reports by categories For each project that you create Eclipse creates a directory in your file system 1 Choose File gt New Project New Project displays the types of projects that you can create New Project el Sel Select a wizard lt gt Create a new Report Project Wizards type Filter text b General a E gt Business Intelligence and Reporting Tools ee ODA Designer Plug in Project lt a ODA Runtime Driver Plug in Project eq Report Project lt lt gt Ge CVS Echpse Modeling Framework gt Ee EIB b E Java Le p 6 Java EE JavaScript b Ley JAB New Project 2 Expand Business Intelligence and Reporting Tools select Report Project then choose Next 3 In New Report Project in Project name type the project name like prjRIL Group New Report Project Report Project Create a new report project Project name prjRILGROUP iv Use default location default a New Report Project Prepared by Mian Aasim Mahmood Page 15 of 43 Solution Heights Pvt Ltd User Manual Guide of ECLIPSE BIRT Report Designer 4 To add the project choose Finish You can now see the project in the Navigator view aes Ts o eis j c Navigat 25 gz Outline fit Resour aa le s oe E priAFU ES prjRIL a E prjRILGROUP
60. y Editor 11 Outline 11 Resource Explorer 12 Cheat Sheets 12 Script Editor 12 Report Items Elements 13 Label m ooO 13 TEKET GS Pdea Se a es eee Ae oh ay Se ere ake an re ne E et ale 13 Dynamic Text 13 Data eei e S e ees e E a E S E E A a e S 13 Mave a a a a eed ie a a a ee ee Ses 13 Grid 2 ee nnn 13 List 2 n 2 ee nnn 14 Table 14 Chart 14 Cross Tab oo er rrr rrr rr re rr enn n nnn 14 Aggregation 22 2 nee re er ere rr eee nnn 14 How to Start New Report Using Query and Stored Procedure 15 Cratea new project es so feeassec ete e eee sees ee tase ees ees lessees seer 15 Create a NeW TEPOll lt SS sass sae reer erties eee eerie es aes eee 16 Connecting to the database
Download Pdf Manuals
Related Search