我的水晶报表加入下面这句之后,预览正常但是导出PDF或Word文档时就全是空白,应该是和Session["T_No"]有关,但是这个翻页时是要用的。还请大家帮帮忙,谢谢!
<sessionState mode= "StateServer" stateConnectionString= "tcpip=127.0.0.1:42424" sqlConnectionString= "data
source=127.0.0.1;Trusted_Connection=yes" cookieless= "false" timeout= "7200"/>--代码--using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;namespace PWMS.front
{
public partial class print_crystal : System.Web.UI.Page
{
protected void Page_Init(object sender, EventArgs e)
{
if (Session["T_No"] != null)
{
CrystalReportViewer1.ReportSource = (ReportDocument)Session["T_No"];
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Report_bind(); }
}
private void Report_bind()
{
using (OleDbConnection con = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["connStr"]))
{
OleDbDataAdapter da = new OleDbDataAdapter();
da = new OleDbDataAdapter("select Cust_Nm, SN_No, Contract_No, from dbo.Print_Save where T_No = '" + Server.UrlDecode(Request.QueryString["T_No"]) + "'", con);
DataSet dt1 = new DataSet();
da.Fill(dt1, "myTable"); ReportDocument myReport = new ReportDocument();
string reportPath = Server.MapPath(@"pack_list.rpt");
myReport.Load(reportPath);
myReport.SetDataSource(dt1.Tables[0].DefaultView);
CrystalReportViewer1.ReportSource = myReport; Session["T_No"] = myReport; }
}
}
}
<sessionState mode= "StateServer" stateConnectionString= "tcpip=127.0.0.1:42424" sqlConnectionString= "data
source=127.0.0.1;Trusted_Connection=yes" cookieless= "false" timeout= "7200"/>--代码--using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;namespace PWMS.front
{
public partial class print_crystal : System.Web.UI.Page
{
protected void Page_Init(object sender, EventArgs e)
{
if (Session["T_No"] != null)
{
CrystalReportViewer1.ReportSource = (ReportDocument)Session["T_No"];
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Report_bind(); }
}
private void Report_bind()
{
using (OleDbConnection con = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["connStr"]))
{
OleDbDataAdapter da = new OleDbDataAdapter();
da = new OleDbDataAdapter("select Cust_Nm, SN_No, Contract_No, from dbo.Print_Save where T_No = '" + Server.UrlDecode(Request.QueryString["T_No"]) + "'", con);
DataSet dt1 = new DataSet();
da.Fill(dt1, "myTable"); ReportDocument myReport = new ReportDocument();
string reportPath = Server.MapPath(@"pack_list.rpt");
myReport.Load(reportPath);
myReport.SetDataSource(dt1.Tables[0].DefaultView);
CrystalReportViewer1.ReportSource = myReport; Session["T_No"] = myReport; }
}
}
}
解决方案 »
- 修改和删除
- |M| 用孟子E章的单点登录代码 再加上Cookies 来实现单点登录 大家看看可以怎么再改进
- 如何 才能 为aspx 页面动态加载控件 并在cs 获得
- 有谁做过自助建站的?
- 菜鸟问题,匹配数字,和日器的正则表达式怎么写?
- 子父表显示问题。应该大家都有这个例子吧。
- 有没有更好的SQL语句?
- 有关insert语句,插入null问题
- DataGrid的EditCommandColumn的问题
- (高分求助,因为很急!)在利用ie的功能进行打印的时候,如何隐藏那些按钮,和树形组,以及怎么设置页面,比如左右空白的宽度等问题?
- Ajaxpro 2.0.今天第一次使用。遇到麻烦了
- 有一个新手的困惑 关于asp
显示正常?
看看阿泰的 日志吧
http://www.cnblogs.com/babyt/archive/2011/03/28/1998106.html
source=127.0.0.1;Trusted_Connection=yes" cookieless= "false" timeout= "7200"/>只要不加上面这句就行,我觉得和session有关。谢谢了