asp.net 水晶报表拉模式

最新推荐文章于 2019-07-24 23:35:43 发布

C979170768

最新推荐文章于 2019-07-24 23:35:43 发布

阅读量1.3k

点赞数

分类专栏：水晶报表文章标签： asp.net 报表 button textbox dataset server

本文链接：https://blog.csdn.net/C979170768/article/details/7826078

版权

水晶报表专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1创建DataSet数据集

前台代码:

前台要引信CryStalReportViewer 这个控件，如果没有，就没能显示报表，后台的C#代码就会出错了也要用此后台C#代码就一定要引入这个控件

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CrystalRepot.aspx.cs" Inherits="CrystalRepot" %>

<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            font-size: small;
        }
    </style>
    <script src="../Scripts/jquery-1.7.2.js" type="text/javascript"></script>
    <script src="../Scripts/blue.js" type="text/javascript"></script>
    <script type="text/ecmascript">
        $(function () {
            $("#start").click(function () {
                setday(this);
            })
            $("#end").click(function () {
                setday(this);
            })

        });
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div style="height: 30px">
    
        <span class="style1">开始时间:</span><asp:TextBox ID="start" runat="server"></asp:TextBox>
        <span class="style1">结束时间:</span><asp:TextBox ID="end" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="显示" />
 <asp:Button ID="Button2" runat="server" οnclick="Button2_Click" Text="显示全部" />
        <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
        AutoDataBind="true" />
    </div>

    </form>
</body>
</html>

C#后台代码:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
using System.Data;

public partial class CrystalRepot : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["username"] == null)
        {
            Server.Transfer("Clear_Session.aspx");
        }
        //if (!IsPostBack)
        //{
        if (!IsPostBack)
        {
            ViewState["sqlcmd"] = "select a.*,b.CompanyName from T_PlayFee a inner join T_Member b on a.MemberId=b.id where a.MEMBERID=" + Request["id"].ToString();
        } Find();
       // }
    }

    private void Find()
    {
        using (SqlConnection con = new SqlConnection(Method.cnnstring))
        {
            using (SqlCommand cmd = new SqlCommand(ViewState["sqlcmd"].ToString(), con))
            {
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataSet1 ds = new DataSet1();
                sda.Fill(ds, "DataTable1");
                ReportDocument rd = new ReportDocument();
                rd.Load(Server.MapPath("CrystalReport.rpt"));
                rd.SetDataSource(ds.Tables["DataTable1"]);
                CrystalReportViewer1.ReportSource = rd;


            }
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        ViewState["sqlcmd"] = "select a.*,b.CompanyName from T_PlayFee a inner join T_Member b on a.MemberId=b.id where a.MEMBERID=" + Request["id"].ToString() + " and StartDateTime>'" + start.Text.Trim() + "' and EndDateTime<='" + end.Text.Trim() + "'";

        Find();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        ViewState["sqlcmd"] = "select a.*,b.CompanyName from T_PlayFee a inner join T_Member b on a.MemberId=b.id where a.MEMBERID=" + Request["id"].ToString();

        Find();
    }
}

效果图如下:

C979170768

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
asp.net 水晶报表拉模式

1创建DataSet数据集前台代码:前台要引信CryStalReportViewer 这个控件，如果没有，就没能显示报表，后台的C#代码就会出错了也要用此后台C#代码就一定要引入这个控件 .style1 { font-size: small; }
复制链接

扫一扫

专栏目录