如何让最终用户在SSRS中自定义报表图表?
我正在研究 sql server 商业智能来生成报告。我做了我希望在报告中出现的所有工作人员,除了最终用户能够自定义报告而无需向服务器发出另一个请求以根据另一个请求生成另一个报告的能力。首先,我通过布尔类型的参数做到了这一点,并在生成报告之前编写了一个表达式来检查参数,但我的项目负责人说我不想每次都提出请求,而是想带上所有可能的数据并让最终用户决定显示什么。
换句话说,我的报告包含三个系列的图表,我希望最终用户能够在客户端+一个请求中显示其中一组或全部。 我怎样才能通过sql server Business Intelligence 2008做到这一点
i am working on sql server business intelligence to generate reports. i did all the staff that i want to be in the report except the ability for the end user to customize the report without making another request to the server to generate another report based on another request. first i did this through a parameter of type Boolean and wrote an expression to check the parameter before generating the report,but my project leader said i don't want to make a request each time instead i want to bring all possible data and let the end user decide what to show.
in other words, my report contains a chart of three series i want the end user have the ability to show a set of them or all of them in client side + one request.
how can i do it through sql server business intelligence 2008
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您的 SSRS 项目基于什么? SQL Server 数据库还是 SQL Server 分析服务?
AFAIK 您可以设计具有多种条件的 SSRS 报告,最终用户可以在其中输入自己的值。
如果它基于 SQL Server DataBase ,则条件看起来像您在 SSRS 中使用的过程参数
如果它基于 SSAS ,则条件看起来像 MDX 代码
What is Your SSRS project based on ? SQL Server DataBase or SQL Server Analysis Service ?
AFAIK you can design the SSRS report with many conditions which the end user can input their own value in .
if It's based on SQL Server DataBase the conditions looks like parameters of procedure that you use in SSRS
if it's based on SSAS , The conditions looks like MDX code