XReport - Build Report from DB or XML

• Download source files - 1826Kb
• Download XReport - 1147 Kb

Introduction

XReport is an New Report tool ,it can read data from DB or XML Document . use this report tool , people can develop mostly report without programming code . so It 's finally aim is , Do it best to reduce go on errands for report development.

Background (optional)

Use old report tools , peopel have to write many code for report , it bring on long time go on errands , spend many time to write and test code . append code to existent software system , increase project cost . It is time to change this complexion.

Using the code

XRepot write in 100% C# , use DOTNET framework 1.1 , It include Report Designer and Report engine . Report engine can used in ASP.NET or WinForm Application .

In ASP.NET application ,you can use report engine like this :

//
// Use XReport engine in ASP.NET
//
private void Page_Load(object sender, System.EventArgs e)
{
    XDesigner.Report.ReportBuilder myBuilder = this.Session["builder"] as XDesigner.Report.ReportBuilder ;
    if( myBuilder == null )
    {
        myBuilder = new XDesigner.Report.ReportBuilder();
        using( System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection())
        {
            conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\我的程序\Designer\out\demomdb.mdb";
            conn.Open();
            myBuilder.DBConnection = conn ;
            // 加载模板
            myBuilder.Load( @"D:\我的程序\Designer\out\订单明细.xrp");
            // 刷新报表
            myBuilder.Refresh();
        }
        this.Session["builder"] = myBuilder ;
    }

    XDesigner.Report.ReportHtmlBuilder rb = myBuilder.CreateHtmlBuilder();
    rb.Indent = true;

    string strUrl = this.Request.Url.AbsoluteUri ;
    int index = strUrl.IndexOf('?');
    if( index > 0 )
        strUrl = strUrl.Substring( 0 , index );
    rb.ImgSrcFormatString = strUrl + "?imageindex={0}"; 
    rb.Refresh();
    if( this.Request.QueryString["imageindex"] != null )
    {
        rb.SaveReportImage( 
            Convert.ToInt32( this.Request.QueryString["imageindex"]) ,
            this.Response.OutputStream ,
            System.Drawing.Imaging.ImageFormat.Png );
        return ;
    }

    if( this.Request.QueryString["out"] == "doc")
    {
        // 输出为Word文档
        rb.SaveWordDocument( this.Response.OutputStream );
        this.Response.AppendHeader("Content-Disposition","attachment;filename=" + System.Web.HttpUtility.UrlEncode( myBuilder.ReportTitle ) + ".doc");
    }
    else if( this.Request.QueryString["out"] == "xls")
    {
        // 输出为 Excel 文档
        rb.SaveExcelDocument( this.Response.OutputStream );
        this.Response.AppendHeader("Content-Disposition","attachment;filename=" + System.Web.HttpUtility.UrlEncode( myBuilder.ReportTitle ) + ".xls");
    }
    else
        rb.Save( this.Response.Output );
}

In console application , you can use report engine like this.

/// <summary>
/// &#24212;&#29992;&#31243;&#24207;&#30340;&#21629;&#20196;&#21442;&#25968;
/// </summary>
public static System.Collections.Specialized.NameValueCollection myArgs = 
            new System.Collections.Specialized.NameValueCollection();

/// <summary>
/// &#31243;&#24207;&#20837;&#21475;&#28857;
/// </summary>
[STAThread]
static void Main() 
{
    try
    {
        // &#20174;&#21629;&#20196;&#34892;&#20013;&#21152;&#36733;&#21442;&#25968;
        AnalyseArgs( System.Environment.GetCommandLineArgs());
        // &#20174;&#21442;&#25968;&#25991;&#20214;&#20013;&#21152;&#36733;&#21442;&#25968;
        string strFileName = myArgs["commandfile"];
        if( strFileName != null && System.IO.File.Exists( strFileName ))
        {
            System.Collections.ArrayList myList = new System.Collections.ArrayList();
            using( System.IO.StreamReader myReader = new System.IO.StreamReader(
                    strFileName , 
                    System.Text.Encoding.GetEncoding( 936 )))
            {
                string strLine = myReader.ReadLine();
                while( strLine != null )
                {
                    myList.Add( strLine );
                    strLine = myReader.ReadLine();
                }
                myReader.Close();
            }
            AnalyseArgs( myList );
        }

        bool bolPrompt = ! ( myArgs["prompt"] == "0");
        System.Data.IDbConnection myConn = null;
        string strConn = myArgs["connection"] ;
        if( strConn != null && strConn.Length > 0 )
        {
            myConn = new System.Data.OleDb.OleDbConnection( strConn );
            myConn.Open();
        }
        XDesigner.Report.ReportBuilder builder = new XDesigner.Report.ReportBuilder();
        builder.DBConnection = myConn;
        foreach( string strKey in myArgs.Keys )
        {
            if( strKey.StartsWith("var:"))
                builder.SetVariable( strKey.Substring( 4 ) , myArgs[ strKey ] );
        }
        strFileName = myArgs["filename"] ;
        if( strFileName != null && System.IO.File.Exists( strFileName ))
        {
            builder.Load( strFileName );
            builder.Refresh();
        }
        if( myConn != null)
            myConn.Close();

        if( myArgs["print"] == "1")
        {
            string strPageIndex = myArgs["pageindex"];
            if( strPageIndex != null && strPageIndex.Length > 0 )
                builder.PrintSpecialPage( bolPrompt , Convert.ToInt32( strPageIndex ));
            else
                builder.PrintDocument( bolPrompt );
        }
    }
    catch( Exception ext)
    {
        System.Windows.Forms.MessageBox.Show( null , "&#31995;&#32479;&#38169;&#35823;:" + ext.Message , "&#31995;&#32479;&#38169;&#35823;" , 
                System.Windows.Forms.MessageBoxButtons.OK , 
                System.Windows.Forms.MessageBoxIcon.Exclamation );
    }
}//static void Main() 

private static void AnalyseArgs( System.Collections.IEnumerable args )
{
    if( args == null )
        return ;
    foreach( string strArg in args )
    {
        if( strArg != null && strArg.Length > 0 )
        {
            int index = strArg.IndexOf('=');
            if( index > 0 )
            {
                string strName = strArg.Substring( 0 , index );
                string strValue = strArg.Substring( index + 1 );
                myArgs[ strName.Trim() ] = strValue.Trim();
            }
        }
    }
}

Points of Interest

Learn more information about XReport , please visit http://www.xdesigner.cn/xreport/default-eng.htm or Email yyf9989@hotmail.com .

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here