SQL Server Report Service rdlc报表

最新推荐文章于 2024-07-25 20:28:55 发布

xzr2004

最新推荐文章于 2024-07-25 20:28:55 发布

阅读量917

点赞数

CC 4.0 BY-SA版权

文章标签： sql server report service 报表 dataset div

本文链接：https://blog.csdn.net/xzr2004/article/details/7257089

本文介绍了一个使用ASP.NET和Microsoft Report Viewer组件显示自定义报告的示例应用。该应用通过从数据库获取数据并填充到RDLC报告中，实现了物料检验通知单的打印功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、新建一个数据集

2、新建一个rdlc文件

3、

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

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!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 id="Head1" runat="server">
<title>打印来料检验通知单</title>
<script language="javascript" type="text/javascript">
function popupDiv(div_id)
{
var div_obj = $("#" + div_id);
var windowWidth = document.body.clientWidth;
var windowHeight = document.body.clientHeight;
var popupHeight = div_obj.height();
var popupWidth = div_obj.width();
div_obj.css({ "position": "absolute" })
.animate({ left: 400,
top: 100, opacity: "show"
}, "slow");
}
function hideDiv(div_id)
{
$("#" + div_id).animate({ left: 0, top: 0, opacity: "hide" }, "slow");
}
</script>
<style type="text/css">
body{TEXT-ALIGN: center; margin:0;overflow-y:hidden;}
#center{ MARGIN-RIGHT: auto;
MARGIN-LEFT: auto;
height:550px;
width:850px;
vertical-align:middle;
}
html{ overflow-y:hidden; }

</style>
</head>
<body onresize="resizeLayout();">
<form id="form1" runat="server">
<div id="center">
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="600px" Width="850px" ShowExportControls="False" ShowRefreshButton="False">
<LocalReport ReportPath="focustar\report\ChkNoteDtl.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet2_V_CRM_CONF_MaterialCheck_D" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData"
TypeName="DataSet2TableAdapters.V_CRM_CONF_MaterialCheck_DTableAdapter"></asp:ObjectDataSource>

</div>
</form>
<script language="javascript" type="text/javascript">
resizeLayout();
function resizeLayout()
{

var divContainer = document.getElementById("ReportViewer1");
if(divContainer == null)
return ;
var clientWidth = document.body.clientWidth;
var clientHeight = document.body.clientHeight;

var width = clientWidth;
var height = clientHeight - 58;
divContainer.style.width = width;
divContainer.style.height = height;
}
</script>
</body>
</html>

4、

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;
using CX.DBA;
using CX.Core;

public partial class focustar_Print_PrintChkNoteDtl : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string guid = Request["Guid"];
PrintRecord(guid);
}
}

/// <summary>
/// 记录GUID
/// </summary>
/// <param name="guid"></param>
protected void PrintRecord(string guid)
{
CX.DBGetResult dbgr = new CX.DBGetResult(CX.AppInfo.DBMS, CX.AppInfo.ConStr);

string sql = "select * from V_CRM_BUSI_ChkNoteDtl where guid='" + guid + "'";
SqlDataReader dr = null;
dr = dbgr.GetDataReader(sql) as SqlDataReader;
if (dr.Read())
{
ReportParameter printDate = new ReportParameter("PrintDate", DateTime.Now.ToString());
ReportParameter code = new ReportParameter("Code", dr["Code"].ToString());
ReportParameter TotalCount = new ReportParameter("TotalCount", dr["TotalCount"].ToString());
ReportParameter EmergencyDegree = new ReportParameter("EmergencyDegree", dr["EmergencyDegreeName"].ToString());
ReportParameter CreateDep = new ReportParameter("CreateDep", dr["CreateDep"].ToString());
ReportParameter CheckSender = new ReportParameter("CheckSender", dr["CheckSender"].ToString());
ReportParameter CheckSendDate = new ReportParameter("CheckSendDate", dr["CheckSendDate"].ToString());
ReportParameter Creator = new ReportParameter("Creator", dr["Creator"].ToString());
ReportParameter CreateDate = new ReportParameter("CreateDate", dr["CreateDate"].ToString());
ReportParameter Receiver = new ReportParameter("Receiver", dr["Receiver"].ToString());
ReportParameter ReceiveDate = new ReportParameter("ReceiveDate", dr["ReceiveDate"].ToString());
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { printDate, code, TotalCount, EmergencyDegree, CreateDep,
CheckSender,CheckSendDate,Creator,CreateDate,Receiver,ReceiveDate });
}
this.ReportViewer1.LocalReport.DisplayName = "abc123";
this.ReportViewer1.LocalReport.Refresh();
dbgr.DBA.ObjCmd.Connection.Close();
}
}