问题描述
我需要的是一个工具，允许用户创建自己的工具报表优先从网络界面，用户可以创建图表，图表和表格。
因此，该工具需要能够处理多个用户，并将用户限制到某个数据库。
我看过水晶报表和SSRS，它们似乎都不支持我想要的或者我缺少什么？
所以，你正在寻找一个基于Web的有限版本的Crystal Developer？我不能想象一个用户的受众，他们有足够的技术和积极性来制作他们自己的报告，设置他们的图表的比例，制作自己的交叉表等。在我的经验中，他们要么预先总结，要么在一个Excel文件。这是我的替代方案：
-
自己做几个模板报告，只让用户选择他们想要的。即您制作3个模板，第一个模板以交叉表格式汇总数据，另一个使用饼图格式，另一个使用条形图格式。然后用户只需在crosstab.pdf，piechart.pdf或barchart.pdf之间进行选择。
-
完全放弃水晶，他们在一个Excel文件中。它不漂亮，它可能有比他们想要的更多的选项，但它是通常使用的软件，他们（可能）知道如何使用。
（你也可以把交叉表放在第一个选项卡，饼图第二个，barcharts在第三个选项卡，让用户只是选择他们喜欢的选项卡，这给他们最大的灵活性，因为他们也可以制作自己的图表，以防他们不喜欢你的推测显示。）
I have looked around a bit but I can't find a tool that fit my needs.
What I need is a tool that allows users to create their own reports preferably from a web interface where the user is able to create charts, diagrams and tables.
Therefore the tool needs to be able to handle several users and restrict the users to a certain database.
I have looked at Crystal Reports and SSRS and neither of them seems to support what I want or am I missing something?
So, you're looking for a web-based limited version of Crystal Developer? I can't imagine a user audience that is skilled and motivated enough to make their own reports, set the scales for their graphs, make their own crosstabs, etc. In my experience, they either want it pre-summarized or in an Excel file. Here's my alternatives:
Make several template reports yourself and just let the user pick the one they want. i.e. You make 3 templates, the first template summarizing the data in a crosstab format, another using a pie chart format, and another using a bar chart format. The user then just has to choose between crosstab.pdf, piechart.pdf, or barchart.pdf.
Give up on Crystal entirely and just hand the data to them in an Excel file. It's not pretty, and it probably has more options than they want, but it's commonly used software that they (probably) know how to use.
(You can also put crosstabs in the first tab, pie charts on the 2nd, barcharts on the 3rd tab, and let the user just pick the tab they prefer. This gives them the most flexibility because they can also make their own graphs in case they don't like your presummarized displays.)
这篇关于是否有报表工具允许用户创建自己的报表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！