首先,在群組視窗裡右下角有個倒三角形,點選後選擇「進階模式」。
接著,點選資料列群組的「(靜態)」,並在屬性視窗中將 RepeatOnNewPage 設成 True。
完成以上兩個動作後,你的報表每一頁就可以重複出現表頭了。也許你會納悶,為何這麼簡單的事情要弄的這麼複雜?我也深有同感,或許,下個版本的 Reporting Service 會更人性些吧。
參考:Tablix headers not repeating in SSRS 2008
<table id="cb"> <tr> <td><input id="cb_0" type="checkbox" name="cb$0" value="1" /> <label for="cb_0">paladin</label></td> </tr><tr> <td><input id="cb_1" type="checkbox" name="cb$1" value="2" /> <label for="cb_1">ltt</label></td> </tr><tr> <td><input id="cb_2" type="checkbox" name="cb$2" value="3" /> <label for="cb_2">lee</label></td> </tr> </table>
protected void cb_PreRender(object sender, EventArgs e)
{
foreach (ListItem li in cb.Items)
{
li.Attributes["text"] = li.Text;
}
}
<table id="cb"> <tr> <td><span text="paladin"><input id="cb_0" type="checkbox" name="cb$0" value="1" /><label for="cb_0">paladin</label></span></td> </tr><tr> <td><span text="ltt"><input id="cb_1" type="checkbox" name="cb$1" value="2" /><label for="cb_1">ltt</label></span></td> </tr><tr> <td><span text="lee"><input id="cb_2" type="checkbox" name="cb$2" value="3" /><label for="cb_2">lee</label></span></td> </tr> </table>
<script>
function ShowData() {
var str = "";
$("input[type=checkbox]:checked").each(function (i) {
str = str + $(this).parent().attr("text") + ",";
});
alert(str);
}
</script>
ShowData( ) 主要目的,就是取得目前頁面上所有被勾選的 checkbox ,並將他們父親的 text 屬性內容存到 str 變數中,最後並將結果顯示出來。<script>
$(function () {
$("input[type=checkbox]").click(function () { ShowData(); });
});
</script>
<html>
<head>
<script src="http://code.jquery.com/jquery-1.4.4.js"></script>
<script>
$(function(){
$(".upper").keyup(function(evt){
var vOri=$(this).val();
var vNew=vOri.toUpperCase();
$(this).val(vNew);
});
$(".lower").keyup(function(evt){
var vOri=$(this).val();
var vNew=vOri.toLowerCase();
$(this).val(vNew);
});
});
</script>
</head>
<body>
ToUpper(JQuery):<input type="text" id="tbxTest1" class="upper" ><br>
ToLower(JQuery):<input type="text" id="tbxTest2" class="lower" ><br>
ToUpper(Style):<input type="text" id="tbxTest3" style="text-transform: uppercase" ><br>
ToLower(Style):<input type="text" id="tbxTest4" style="text-transform: lowercase" ><br>
</body>
</html>
create table #tmp1 (t_Name varchar(30))
create table #tmp2 (t_Name varchar(30))
insert into #tmp1(t_Name) values ('paladin')
insert into #tmp1(t_Name) values ('hugo')
insert into #tmp1(t_Name) values ('ken')
insert into #tmp1(t_Name) values ('lillian')
insert into #tmp1(t_Name) values ('panda')
insert into #tmp2(t_Name) values ('polly')
insert into #tmp2(t_Name) values ('keen')
insert into #tmp2(t_Name) values ('hana')
insert into #tmp2(t_Name) values ('gemma')
select t_Name from #tmp1 union select t_Name from #tmp2 select t_Name from #tmp1 union all select t_Name from #tmp2
declare @i_count int
set @i_count=0
while (@i_count<100000) -- 分別用 1000,10000,100000
begin
insert into #tmp1(t_Name) values ('paladin@@')
insert into #tmp2(t_Name) values ('panda@@')
set @i_count=@i_count+1
end
var oldOnload = window.onload || function () {};
window.onload = function ()
{
oldOnload();
// Do Something...
}
private void btnPrintSignNew_Click(object sender, System.EventArgs e)
{
string scriptString=string.Empty;
scriptString = string.Format(@"
<script language=JavaScript>
<!-- begin
$(function(){{
window.open('xxx');
}});
//end -->
</script>
"));
this.RegisterStartupScript("MsgDownLoad",scriptString);
}
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Configuration;
namespace WebApplication1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button btnPDF;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
}
private void btnPDF_Click(object sender, System.EventArgs e)
{
MakePDF();
}
private void MakePDF()
{
//PDF 暫存檔路徑(必須已經存在的檔案路徑)
string filepath = "D:\\upload\\engage_upd\\PDF\\";
string filename = filepath+"Quote.PDF";
//取得 WebService 服務(SQL 2008R2 的 webservice 要使用 ReportExecution2005.asmx )
string strRSTmp="http://Repsdev/ReportServer/ReportExecution2005.asmx";
repsdev.ReportExecutionService rs=new WebApplication1.repsdev.ReportExecutionService();
//設定 windows 帳號認證(正式使用時,採用此行)
//rs.Credentials=System.Net.CredentialCache.DefaultCredentials;
//測試資料【連接Reporting Server】(測試時,採用此行,固定測試帳號)
rs.Credentials=new System.Net.NetworkCredential("52xxxx","passwd","network");
//重新指派 WebService 服務位址
rs.Url=strRSTmp;
Byte [] result=null;
//參數收集(呼叫報表時必須傳入的參數,目前範例要傳入 seqsn,ver,isdraft 三個參數)
repsdev.ParameterValue [] parameter=new WebApplication1.repsdev.ParameterValue[3] ;
parameter[0]=new WebApplication1.repsdev.ParameterValue();
parameter[0].Name="seqsn";
parameter[0].Value="545";
parameter[1]=new WebApplication1.repsdev.ParameterValue();
parameter[1].Name="ver";
parameter[1].Value="";
parameter[2] = new WebApplication1.repsdev.ParameterValue();
parameter[2].Name="isdraft";
parameter[2].Value="1";
repsdev.ExecutionInfo execInfo=new WebApplication1.repsdev.ExecutionInfo();
repsdev.ExecutionHeader execHeader=new WebApplication1.repsdev.ExecutionHeader();
//報表位置
string reportPath = "/EPath/rptTest";
string historyID = null;
rs.ExecutionHeaderValue = execHeader;
execInfo = rs.LoadReport(reportPath, historyID);
rs.SetExecutionParameters(parameter, "en-us");
string mimeType;
repsdev.Warning [] warnings=null;
string [] streamIDs=null;
string devInfo=@"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
string extension;
string encoding;
try
{
result=rs.Render("PDF",devInfo,out extension,out mimeType,out encoding,out warnings,out streamIDs);
}
catch(Exception e)
{
if(e.Message.IndexOf("401")>-1)
{
//HTTP 401:沒通過授權
String scriptString = @"
<script language=JavaScript>
<!-- begin
alert('您必須登入網域,才能有權限讀取本報表!') ;
//end -->
</script>
";
this.RegisterStartupScript("AccessDeny",scriptString);
return;
}
else
return;
}
FileStream fs=new FileStream(filename,FileMode.Create);
fs.Write(result,0,result.Length);
fs.Close();
rs.Dispose();
}
}
}