当前文件： CrystalReports/CS_Web_CRVObjMod_FilteringData/CS_Web_CRVObjMod_FilteringData/Default.aspx.cs[2K，2009-6-12 11:37:57]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using CrystalDecisions.CrystalReports.Engine;
11using CrystalDecisions.Shared;
12
13public partial class _Default : System.Web.UI.Page 
14...{
15    private void ConfigureCrystalReports()
16    ...{
17        selectOperatorList.DataSource = System.Enum.GetValues(typeof(CeComparisonOperator));
18        selectOperatorList.DataBind();
19
20        selectOperatorList.DataSource = System.Enum.GetValues(typeof(CeComparisonOperator));
21
22        if (!IsPostBack)
23        ...{
24            selectOperatorList.DataSource = System.Enum.GetValues(typeof(CeComparisonOperator));
25
26            string selectFormula = "{Customer.Last Year's Sales} > 11000.00 " + "AND Mid({Customer.Customer Name}, 1, 1) = \"A\"";
27            crystalReportViewer.SelectionFormula = selectFormula;
28            selectOperatorList.DataBind();
29        }
30
31        string reportPath = Server.MapPath("CustomersBySalesName.rpt");
32        crystalReportViewer.ReportSource = reportPath;
33    }
34
35    private void Page_Init(object sender, EventArgs e)
36    ...{
37        ConfigureCrystalReports();
38    }
39    protected void redisplay_Click(object sender, EventArgs e)
40    ...{
41        string selectedOperator = GetSelectedCompareOperator();
42
43        string selectFormula = "{Customer.Last Year's Sales} > " + lastYearsSales.Text
44        + " AND Mid({Customer.Customer Name}, 1, 1) " + selectedOperator + " \"" + customerName.Text + "\""; 
45        crystalReportViewer.SelectionFormula = selectFormula;
46        crystalReportViewer.ReportSource = Server.MapPath("CustomersBySalesName.rpt");
47    }
48
49    private string GetSelectedCompareOperator()
50    ...{
51        switch ((CeComparisonOperator)selectOperatorList.SelectedIndex)
52        ...{
53            case CeComparisonOperator.EqualTo:
54                return "=";
55            case CeComparisonOperator.LessThan:
56                return "<";
57            case CeComparisonOperator.GreaterThan:
58                return ">";
59            case CeComparisonOperator.LessThan_or_EqualTo:
60                return "<=";
61            case CeComparisonOperator.GreaterThan_or_EqualTo:
62                return ">=";
63            case CeComparisonOperator.Not_EqualTo:
64                return "<>";
65            default:
66                return "=";
67        }
68    }
69}