Asp.net水晶报告setparameter值不工作的visual studio 2012

问题描述

Asp.net水晶报告setparamertvalue功能无法工作的视觉工作室2012.I数据库中有桌面玩家

其中countryCode值为1 ... 10.我想在水晶中显示特定的国家记录报告但水晶报告显示所有记录而不是特定记录国家代码3

Asp.net crystal report setparamertvalue function not working visual studio 2012.I have table Players in database
in which countryCode value is 1...10.I want to show specific country record in crystal report but crystal report show all records instead of specific record countrycode 3

cn.Open();
           SqlCommand cmd = new SqlCommand("empp", cn);
           cmd.CommandType = CommandType.StoredProcedure;
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           DataTable ds = new DataTable();
           da.Fill(ds);
           rdoc.Load(Server.MapPath("CrystalReport1.rpt"));
           rdoc.SetDataSource(ds);
           rdoc.SetParameterValue("conID", 3);
           CrystalReportViewer1.ReportSource = rdoc;
           CrystalReportViewer1.DataBind();
           cn.Close();

<pre lang="SQL">
create PROCEDURE empp
AS
BEGIN
	SELECT * FROM Players
END

{Players.countryCode} = {？conID}



指导我如何解决这个问题

{Players.countryCode}={?conID}

Guide me how to solve this problem

推荐答案

这篇关于Asp.net水晶报告setparameter值不工作的visual studio 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！