SQL Server Reporting Services 的问题
朋友们,我有一个 SQL Server Reporting Services 问题..!!!
我有一些报告不显示数据,这些报告位于与包含数据库的服务器不同的服务器上,报告的数据源配置良好。 存储过程在服务器时执行(显示数据) 用户拥有必要的权限。
问题是什么 ..?谢谢
Friends I have a problem with SQL Server Reporting Services ..!!!
I have some reports that show no data, the reports are on a separate server from the server that contains the database, the Data Sources of the reports is well configured.
Stored procedures are executed while the server (display data)
users have the necessary permissions.
What is the problem ..? Thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
另外,请查看报告服务日志。它们都以 .log 结尾,并以 Report 开头。我忘记它们在服务器上的位置,但我很确定它们位于 mssql 的程序文件目录下,就像您会找到 sql server 的日志一样。
Also, look at reporting services logs. they all end in .log, and begin with Report. I forget where they are on the server, but am pretty sure they are under the program files directory for mssql, just as you would find logs for sql server.
听起来好像生产中数据源的定义可能与开发中的不同。您是否尝试过重新部署数据源?
It sounds as though the definition of your data sources in production may be different from that in development. Have you tried redeploying your data sources?
您应该能够访问与报表服务器分开的服务器上的数据库。这一切听起来都不错。当您在 Visual Studio 预览模式下运行报告时...您看到任何数据吗?
You should be able to access the Database on a server separate from the report server. That all sounds good. When you run the Reports in Visual Studio Preview mode....do you see any data?