📄 reportpicker.aspx

📁 基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI）
💻 ASPX
字号:
<%@ Page language="c#" Codebehind="ReportPicker.aspx.cs" AutoEventWireup="false" Inherits="AWC.Reporter.Web.ReportPicker" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD>
		<title>Report Picker</title>
		<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
		<meta content="C#" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
		<STYLE type="text/css">BODY { BACKGROUND: #fbfbfb; FONT-FAMILY: Verdana }
	A:link { COLOR: blue; TEXT-DECORATION: none }
	A:active { COLOR: red; TEXT-DECORATION: none }
	A:visited { COLOR: blue; TEXT-DECORATION: none }
		</STYLE>
		<script language="javascript">
		var reportServerUrl = null;
		<!--
		function runReport()
		{
			frmRender.action = reportServerUrl + frmReports.drpReports.value;
			frmRender.Format.value = frmReports.drpExport.value;
			// take care of parameters if any
			var parameters = frmReports.txtParameter;
			var paramUrl ="";
			
			// remove any hidden parameter that may exist from the previous run
			var oldParameters = frmRender.Parameter;
			if (oldParameters!=undefined)
			{
				if (oldParameters.length>0)	{
					var count = parameters.length
					for (i=0;i<count;i++) {
						oldParameter = oldParameters[i];
						frmRender.removeChild(oldParameter);
						i--;count--;
					}
				}
				else frmRender.removeChild(oldParameters);
			}
			
			// do we have parameters?
			if (parameters!=null)		
				if (parameters.length>0) {
					// more than one parameter
					//iterate over the parameters.
					for (i=0;i<parameters.length;i++) {
						var newParam = document.createElement("INPUT");
						newParam.type = "hidden";
						newParam.id = "Parameter";
						newParam.name = parameters[i].name;
						newParam.value = parameters[i].value;
						frmRender.appendChild(newParam);
					}
				}
			   else  {
						// only one parameter
						var newParam = document.createElement("INPUT");
						newParam.type = "hidden";
						newParam.id = "Parameter";
						newParam.name = parameters.name;
						newParam.value = parameters.value;
						frmRender.appendChild(newParam);
			   }

			window.open("about:blank", "report", "location=yes,toolbar=no,left=100,top=100,height=600,width=800")

			// render the report by HTTP POST
			frmRender.submit();
		
		}
		//-->
		</script>
	</HEAD>
	<body MS_POSITIONING="FlowLayout" onload="javascript:reportServerUrl = frmRender.action">
		<form id="frmReports" method="post" runat="server">
			<h3 align="center"><FONT face="Verdana" color="#476789">Report Picker</FONT></h3>
			<table id="tblWriteBack" style="BORDER-RIGHT: tan 1px solid; BORDER-TOP: tan 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: tan 1px solid; WIDTH: 300px; BORDER-BOTTOM: tan 1px solid; FONT-FAMILY: Verdana; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: white"
				borderColor="tan" cellSpacing="0" cellPadding="2" width="300" align="center" border="1">
				<tr style="FONT-WEIGHT: bold; COLOR: darkslateblue; BACKGROUND-COLOR: beige">
					<td style="HEIGHT: 12px" colSpan="2">Choose Report</td>
				</tr>
				<tr style="COLOR: darkslateblue; BACKGROUND-COLOR: beige">
					<td style="WIDTH: 80px; HEIGHT: 23px" noWrap>Reports:</td>
					<td style="HEIGHT: 23px" noWrap><asp:dropdownlist id="drpReports" runat="server" AutoPostBack="True"></asp:dropdownlist></td>
				</tr>
				<tr style="COLOR: darkslateblue; BACKGROUND-COLOR: beige">
					<td style="WIDTH: 80px; HEIGHT: 28px" noWrap>Export Format:</td>
					<td noWrap><asp:dropdownlist id="drpExport" runat="server"></asp:dropdownlist></td>
				</tr>
				<tr style="FONT-WEIGHT: bold; COLOR: darkslateblue">
					<td style="HEIGHT: 12px" colSpan="2">Parameters</td>
				</tr>
				<tr style="COLOR: darkslateblue; BACKGROUND-COLOR: beige">
					<td width="300" colSpan="2"><asp:datagrid id="grdParams" runat="server" EnableViewState="False" CellPadding="2" BorderColor="Tan"
							BorderWidth="1px" BackColor="White" AutoGenerateColumns="False" font-names="Verdana" AllowSorting="True" Font-Size="8pt"
							Font-Name="Verdana" NAME="grdOrders" width="300px" BorderStyle="Solid">
							<AlternatingItemStyle BackColor="Beige"></AlternatingItemStyle>
							<ItemStyle ForeColor="DarkSlateBlue"></ItemStyle>
							<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="DarkRed"></HeaderStyle>
							<Columns>
								<asp:BoundColumn DataField="Name" ReadOnly="True" HeaderText="Name">
									<HeaderStyle Width="80px"></HeaderStyle>
									<ItemStyle Wrap="False"></ItemStyle>
								</asp:BoundColumn>
								<asp:TemplateColumn HeaderText="Value">
									<HeaderStyle HorizontalAlign="Center" Width="70px"></HeaderStyle>
									<ItemStyle HorizontalAlign="Center"></ItemStyle>
									<ItemTemplate>
										<input type=text id="txtParameter" name='<%# DataBinder.Eval(Container.DataItem,"Name").ToString()%>' value='<%# DataBinder.Eval(Container.DataItem,"Value").ToString()%>'>
									</ItemTemplate>
								</asp:TemplateColumn>
							</Columns>
							<PagerStyle Mode="NumericPages"></PagerStyle>
						</asp:datagrid></td>
				</tr>
				<tr style="FONT-WEIGHT: bold; COLOR: darkslateblue">
					<td style="HEIGHT: 12px" colSpan="2"><A onclick="runReport();" href="#">Run Report</A></td>
				</tr>
			</table>
		</form>
		<FORM id="frmRender" action="http://192.168.1.204/reportserver?" method="post" target="report">
			<INPUT type="hidden" value="Render" name="rs:Command"> 
			<INPUT type="hidden" value="HTML4.0" name="rs:Format" id="Format">
			<INPUT type="hidden" value="_blank" name="rc:LinkTarget">
			<!--INPUT type="hidden" value="false" name="rc:Toolbar"--> <!--remove comments to suppress the toolbar-->
			
		</FORM>
	</body>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -