Allowing users to generate their own reports would be wonderful, but for anything beyond a simple report, this quickly require basic database skills. I've never seen a user-accessible report designer that users could actually design reports of any complexity with.
You're better off providing two things:
The most obvious reports with some filtering/sorting options. Common ways to do this are with Crystal for a desktop app or SQL Server Reporting Services for a web app.
The ability to export raw data to Excel. Office skills are far more common in most user groups than database skills. Your users will have a better chance of creating a report with an Excel chart than they will have of working through any report designer I've ever seen.
发布评论
评论（1）
允许用户生成自己的报告固然很棒，但对于简单报告之外的任何内容，这很快就需要基本的数据库技能。我从未见过用户可访问的报表设计器，用户实际上可以使用它来设计任何复杂的报表。
您最好提供两件事：
Allowing users to generate their own reports would be wonderful, but for anything beyond a simple report, this quickly require basic database skills. I've never seen a user-accessible report designer that users could actually design reports of any complexity with.
You're better off providing two things: