VS2005 水晶報表您请求的报表需要更多信息.

gy184759547 2010-05-25 12:01:24

各位,小弟刚刚接触水晶报表.现在做一个列子.遇到一点问题
希望各位能帮帮小弟,
页面后台:
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 CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Web;
using CrystalDecisions.Shared;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
string conStr = "server=.;database=Test;uid=sa;pwd=sa.";
SqlConnection conn = new SqlConnection(conStr);
//conn.Open();
//SqlCommand comm = conn.CreateCommand();

sda = new SqlDataAdapter("select ID,AdminPage from Scan_AdminLogin", conn);

sda.Fill(ds, "Scan_AdminLogin");

ReportDocument rd = new ReportDocument();

string MyPath = Server.MapPath(@"App_Code/CrystalReport.rpt");
rd.Load(MyPath);

rd.SetDataSource(ds.Tables["Scan_AdminLogin"]);

CrystalReportViewer1.ReportSource = rd;
//CrystalReportViewer1.DataBind();
//conn.Close();
}
}

页面前台:

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

<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.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>
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<cr:crystalreportviewer id="CrystalReportViewer1" runat="server" autodatabind="true"></cr:crystalreportviewer>

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

我是用DATASET数据集做的.
CrystalReport.rpt 中我用数据专家连接项目数据 ADO.NET数据集选择了我刚刚建的那个DataSet1数据集,我在这个数据集中建了四张表.
分别是:
表:Scan_AdminLogin 列:ID,AdminPage
表:UserInfo 列:ID,Name,Address,Phone
表:TypeName 列:ID,TypeName
表:GoodsInfo 列:ID,UID,Number,Name,Title,TID
在CrystalReport.rpt 中我只用了Scan_AdminLogin表的ID,它就说

您请求的报表需要更多信息.

--------------------------------------------------------------------------------
DataSet1
服务器名：
数据库名：
用户名：
密码：
使用集成安全性

...全文