读书人

高分请问关于Reporting Service的有关

发布时间: 2012-01-24 23:11:55 作者: rapoo

高分请教关于Reporting Service的问题
在开发基于Reporting Service的报表时,我是通过用程序来动态生成rdl文件,代码如下:
//用XmlTextWriter创建一个RDL文件
//打开一个新写入RDL文件
FileStream stream;
stream = File.OpenWrite(FileName);
XmlTextWriter writer = new XmlTextWriter(stream, Encoding.UTF8);

// 根据字节点设置缩进
writer.Formatting = Formatting.Indented;

// 报表元素
writer.WriteProcessingInstruction( "xml ", "version=\ "1.0\ " encoding=\ "utf-8\ " ");
writer.WriteStartElement( "Report ");
writer.WriteAttributeString( "xmlns ", null, "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition ");
writer.WriteElementString( "Width ", "6in ");

// 数据源元素
writer.WriteStartElement( "DataSources ");
writer.WriteStartElement( "DataSource ");
writer.WriteAttributeString( "Name ", null, "DataSource1 ");
writer.WriteStartElement( "ConnectionProperties ");
writer.WriteElementString( "DataProvider ", "SQL ");
writer.WriteElementString( "ConnectString ", m_connectString);
writer.WriteElementString( "IntegratedSecurity ", "false ");
//writer.WriteElementString( "UserName ", "sa ");
//writer.WriteElementString( "PassWord ", "1 ");
writer.WriteEndElement(); // ConnectionProperties
writer.WriteEndElement(); // DataSource
writer.WriteEndElement(); // DataSources


...
...
...
但是我每次用ReprotView控件访问这个的时候,会出现登录凭据的对话框,我的报表服务器不在本机所以不能用windows集成认证,请教高手有什么方法可以不会出现登录凭据的对话框,问题一解决,马上结帖。

[解决办法]
在本地上你能用url访问报表服务器上的报表吗?你是怎么调用你的报表的?
[解决办法]
点击...修改报表数据源,然后点击DataSource后面的...,点击常规标签旁边的Gredentials,在里面有各种登陆方式,你把这个设置好,看行不行.
就是每个报表都要设一下,比较麻烦
[解决办法]
加一个everyone的所有控制权限应该可以吧
[解决办法]
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ShowParameterPrompts = false;

ReportViewer1.ServerReport.ReportServerUrl = new Uri(myReport.GetConfigString( "SeverReportServerUrl "));
ReportViewer1.ServerReport.ReportPath = myReport.GetConfigString( "ServerReportPath ");
ReportViewer1.ServerReport.SetParameters(myReport.GetReportParameters());

读书人网 >asp.net

热点推荐