BIRT is an open source, Eclipse-based reporting system that integrates with your application to produce compelling reports for both web and PDF.

BIRT provides core reporting features such as report layout, data access and scripting. The current released version is 2.0. Please try BIRT and tell us what you think by filling bugs reports & enhancement requests through Bugzilla as explained on the community page.

New and Notable Features within BIRT 2.0

• New BIRT Viewer
• JavaScript/Java Events And Report Debugging
• Runtime Data Source Property Binding
• Chart Builder and SVG Output
• Templates
• Libraries
• XML ODA
• URL Builder
• Multi-pass Aggregate, Sorting and Filtering
• Improved Report Performance and PDF Fidelity
• Dynamic Parameters/Cascading Parameters
• Expression Builder
• Importing of Style Sheets
• Report XML Editor
• Passing of External Object to Custom Data Sources
• Stored Procedures
• CLOB/BLOB Support
  

New and Notable Features within BIRT 2.0：
http://www.eclipse.org/birt/phoenix/project/notable2.0.php

project home:http://www.eclipse.org/birt/

new report viewer [截图]

The Viewer also supports data extraction to CSV format [截图]

export to CSV [截图]

它的report designer 还独立出来（不用依赖eclipse）直接打开　BIRT.exe　就ＯＫ．

马上小试了一下，发现之前好几点疑问都可以不用担心了，基本解决掉了:
1．AJAX的分页
　　只要自定义好报表/grid的宽以及高，实现css分页，初步感觉效果还不错（有待实际应用）

2．导出excel
      支持export to csv（虽然有中文乱码问题），另外当报表没有dataset(静态报表)时好象导不出．

3．BIRT and POJOs as datasources example
      http://tools.osmosis.gr/blog/archives/2005/06/birt_and_object.html

4．更人性化，提供四个servlet
　a. /frameset?__report=test.rptdesign   (工具条,目录导航,分页操作)
    b./preview?__report=test.rptdesign (工具条,目录导航,分页操作)

    c./run?__report=test.rptdesign
    d./download?__report=test.rptdesign

<table>
<tr>
 <td>
   <table>
    
   </table>
   <br/> <!--两个br分行标记-->
   <br/>
   <table>
    
   </table>
 </td>
</tr>
</table>

       解决方案：
       好在jasperreport还提供了很好的扩展方案.它允许我们自定义分页方式（就是说在两页/table之间能让我们放自己的代码），自己定义betweenPagesHtml 就ＯＫ了，可以能过ＣＳＳ定义分页．在这里，我就直接改它代码算了．大家可以自己选择.
    
net.sf.jasperreports.engine.export.JRHtmlExporter

<!--CSS代码-->
pageEnd {page-break-after:always}

if (betweenPagesHtml == null)
                        {
                            writer.write("<br class=\"pageEnd\">");   // 原来是两个 <br/>
                        } else
                        {
                            writer.write(betweenPagesHtml);
                        }

• Able to mix the ColumnTag and the ColumnsTag. Will need to use the method
  model.getColumnHandler().addAutoGenerateColumn(column);
• Every attribute of every tag will accept an EL Expression
• Will accept a Set for the collection now

部分使用说明 --by david xu

1  table 新增加var属性,支持定义bean name (可选择),可以不用${collectionName.memberName}这样难以理解的语法.
    用官方的话就是
    "Added TableTag var attribute. Used (optionally) as the name of the variable to hold the current bean. "
  

<ec:table
    collection="humanList"
    action="${pageContext.request.contextPath}/index.jsp"
    imagePath="${pageContext.request.contextPath}/images/table/*.gif"
    cellpadding="1"
    saveFilterSort="true"
    var="human"
    title="我的第一个tag table">
ec:table>
${human.name} 取得

[1.0.1-M2]
1.0.1-M2 release  by 官方

1. Things that changed and need to be aware of:

• The ColumnTag exportable attribute has been removed
  • Replaced with the viewsAllowed and the viewsDenied attributes (see items 3 and 4)
• Changed Cell interface
  • new interface ->public void init(BaseModel model, Column column);
  • Matches the View interface for consistency
  • The rowcount is part of the new Row bean. Can retrieve the rowcount by doing a model.getRowHandler().getRow().getRowCount()
• Changed View interface
  • new interface -> public void body(BaseModel model, Column column);
  • Matches the Cell interface for consistency
  • Can get the column position by doing column.isFirstColumn() and column.isLastColumn()
• New TableTag attributes to replace the deprecated collection attribute
  • The collection attribute has been deprecated in favor of three new attributes. The attributes are call tableId, items, and var
  • Read the full discussion for more information
• Moved the element back on the Cell for the FilterCell.
  • If you modified the HtmlView, and specifically the filter row, then remove the element in the View.

2. New RowTag with cooresponding Row Bean

• Able to do row level javascript onmouseover, onmouseout, and onclick
• Ability to do row level highlighting. See stylesheet change (below) for proper formating.
• Moved the stylesheet class attribute from the column () to the row ()

3. New ColumnTag attribute viewsAllowed

• Can specify whether the column should be used for the current view. The views include html, pdf, xls, csv, plus any custom views.
• If you specify a given view (or views), then only that view (or views) will use the column
• For example you can specify viewsAllowed="pdf" which will use the column for the PDF export, but not any other export or default html View
• Replaces the ColumnTag exportable attribute

4. New ColumnTag attribute viewsDenied

• Can specify whether the column should not be used for the current view. The views include html, pdf, xls, csv, plus any custom views
• If you specify a given view (or views), then only that view (or views) will not use the column
• For example you can specify viewsDenied="html" which will not use the column for the html View, but will for all the exports
• Replaces the ColumnTag exportable attribute

5. Enhancements

• Every attribute of every tag will accept an EL Expression
• Will accept a Set for the collection now
• Confirmed to work with a RowSetDynaClass (if send as List)
• Able to mix the ColumnTag and the ColumnsTag. Will need to use the method model.getColumnHandler().addAutoGenerateColumn(column);
• Improved the default stylesheet
  • My initial intentions were to just change the stylesheet to work with the row highlighting, but I ended up tweaking it enough that now it just works better. For instance if you have some filters turned off then it seamlessly flows with the statusbar because it no longer uses cellspacing. If you use the new stylesheet be sure to remove the table.cellspacing=2 from your extremecomponents.properties file.

6. Bugs Fixed

• Fixed Rows Displayed bug
  • The Rows Displayed was not working correctly with the Show All under certain conditions
  • Can set the median and max values in the extremecomponents.properties. The default values are table.medianRowsDisplayed=50 and table.maxRowsDisplayed=100, respectively

部分使用说明 --by david xu
1、TableTag 的改动
      collection attribute 不再赞成使用,可以使用tableId, items, and var 取而代之

<ec:table 
    items="customerList"
        tableId="customer"
        var="customer"
    title="customerList"
        …………

>
…………
ec:table>

2、ColumnTag 新属性的用法viewAllowed，viewsDenied
      支持view包括:html, pdf, xls, csv以及自定的view

     viewsAllowed="pdf"    //说明：只允许在pdf view 中
      viewsAllowed="html,xls" //也可以用,分隔

3、 Cell interface 的改动
       通过model.getRowHandler().getRow().getRowCount() 返回 rowcount
4、新增RowTag 
    

<ec:row highlightRow="true" onclick="alert('david')" >
   <ec:column/>
   <ec:column/>
   <ec:column/>
   …………
ec:row>

<%
    List customerList = new ArrayList();
    LazyDynaBean temp = new LazyDynaBean();
    temp.set("code", "001");
    temp.set("name", "david xu");
    customerList.add(temp);
    request.setAttribute("customerList", customerList); 
%>

   …………
  …………

<ec:table
        totalTitle="合计"
>      
   <ec:column property="salary" showTotal="true"/>
ec:table>

New and Noteworthy 1.0.1-M3

This build represents a massive refacoring of the handler code and includes a new limit package. I believe the state of the code is the best it has ever been and in general has really gone to a new level. This was initially sparked by a refactoring of the Pagination (now Limit) and Rows Displayed features but then trickled down into the handler code and also resulted in a new Limit and LimitFactory.

Be sure to give yourself time to move to this release as you will need to fix your custom cells and views. I had to move some classes to different packages as things changed internally. The changes will make working with the eXtremeTable much easier and were unavoidable.

 Limit limit = LimitFactory.createInstanceOfLimit(request, tableId);
 LimitFactory.setLimitFilterAndSortAttr(limit);

 //once you know the total rows
 LimitFactory.setLimitPageAndRowAttr(limit, DEFAULT_ROWS_DISPLAYED, totalRows);

<ec:table 
      retrieveRowsCallback="org.extremecomponents.table.callback.LimitCallback"
      filterRowsCallback="org.extremecomponents.table.callback.LimitCallback"
      sortRowsCallback="org.extremecomponents.table.callback.LimitCallback"
      ...
  >

前言... 2

操作界面... 2

第二章 实例操作... 2

成绩单实例... 2

第三章 其它补充... 2

    格式化... 3

    打印... 5

第一章 总体说明

前言

MS设计的office套装每一个都有其专注，每一方面都为用户着想，不能不赞，人家赚钱是为用户想到最好！！

Excel这是一个用于建立与使用电子报表(表格)的实用程序，以表格的形式来储存数据，支持一整套函数操作，方便统计以及打印。
     无论是财务部门制作工资表还是教师职工制作学生成绩表，无需很强的电脑操作能力，都能快速制表.

操作界面

先了解一些概念：
工作簿: Excel中定义一个EXCEL文件就是一个工作簿，工作簿中可以放N张有相关的工作表。
工作表: 若干个工作表组成一个工作簿（EXCEL文件），工作表之间可以使用特定的方法相互引用数据.
             如下图：最下面的Sheet1 Sheet2等就是一个一个工作表，可能通过双击将其改名，以及右键新增加工作表．
表格:  通常一个工作表中至少包含一个表格，表格可由表头，列(Excel中以A、B、C等字母表示)，行(Excel中以1、2、3数字表示)组成.
单元：单元是最小的单位，单元选定的行与列组成．
          例如A列的第一行就是A1单元,B列的第六行就是B6单元

函数: excel中提供一整套函数公式方便用户进行数据统计与运算. 如AVERAGE(D3:D8)　意指统计D3-D8的平均分.

如下图可以直观地了对其有个大概的了解:


第二章 实例操作

成绩单实例

1、制作表头
选择范围,设置单元格属性

对齐全并单元格


在 [对齐]标签中[合并单元格]操作，并在字体中设置加粗，输入＂学生成绩表＂　效果如下:



2、输入行头,以及相关的基础数据
点击单元（cell）分别录入相关的数据，太简单，这里跳过：）



3、函数使用

这里主要学习的是函数的使用，以其中AVERAEG为例说明

A.点选要录入的单元

B.插入函数


C.选择要进行平均分的单元


OK,这样就完成了统计语文平均成绩的工作．
观察一下上面的函数公司为 =AVERAGE(C3,C4,C5,C6,C7,C8)　
其实如果我们熟悉相关的函数，可以在输入框中直接输入 =AVERAGE(C3:C8) 也达到同样的效果.

第三章 其它补充
1.格式化
文字竖着来
有时候我们要将一些文字格式化成竖起来的效果，excel操作也挺简单



2.打印
设置打印顶端标题行
有时候表格太长，打印出来后会分页，然而我们行头是不变，希望它能在每一页的页头都能打出来．
第一页：



第二页:


这种情况我们就要设置顶端标题行:

具体操作:
文件- 页面属性 - 工作表 －顶端标题行－　然后点击选择每二行（在这里第二行是顶端标题行）