报表生成器 1.0 中的报表参数 - 下拉列表未出现
我最近一直在使用 Microsoft Report Builder 1.0，因为我们被要求为我们的一些用户创建一个临时报告模型来创建他们自己的报告。
向报告添加过滤器时，应用程序始终为我选择的每个条件提供可用值的下拉列表，但是，只有在我自己的 PC 上运行报告生成器并通过本地 SQL 上的数据库构建报告时才会出现这种情况服务器。
当我尝试从报表生成器访问远程数据库时，或者从其他人的 PC 访问我自己的数据库时，不会生成下拉列表，这意味着用户必须在参数字段中手动输入文本值。
还有其他人遇到过这个问题或找到解决方法吗？此行为是否是故意的，可能是出于性能或安全原因？这看起来有点奇怪，但更奇怪的事情发生了！
I've been playing with Microsoft Report Builder 1.0 recently as we were asked to create an ad-hoc reporting model for some of our users to create their own reports.
When adding filters to reports the application has always provided drop-down lists of available values for each condition I select, however, this only seems to be the case when running the Report Builder on my own PC building reports over a database on my local SQL Server.
When I try accessing a remote database from my Report Builder, or when I access my own database from someone else's PC, the drop-down lists are not generated, meaning the user has to manually enter text values into the parameter fields.
Has anyone else had this problem or found a way around it? Is this behaviour intentional, maybe for performance or security reasons? It seems a bit odd that this would be the case, but stranger things have happened!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我遇到了这个问题，我看到它发生的原因有两个。
报表模型的数据源未设置为使用 Windows 集成安全性。我发现，如果将其设置为其他任何值，则下拉列表将不起作用。
模型使用的表/视图存在数据库权限问题。我最终重新设计了模型，以使用最终用户有权访问的视图，而不是使用受限表。
我发现 Report Builder 1.0 和 2005 模型变化无常，难以使用和维护，而且功能非常有限。
I've run into this problem, there were 2 reasons I saw it happening.
The datasource to the report model was not set to use Windows Integrated Security. I have found that if it's set to anything else the drop-downs don't work.
There were database permission issues on the tables/views that the Models were using. I ended up reworking the models to use views that our end users had permissions to, instead of using the restricted tables.
I have found Report Builder 1.0 and 2005 Models to be fickle and difficult to use and maintain and very limited in functionality.