通用报告撰写人 [英] Generic Report Writer

问题描述

大家好，
有谁知道报告编写器具有一个界面，该界面可以列出数据库中的所有表/列，并根据您选择的内容建立查询并最终生成csv文件或其他内容?

开源还是独立...?

任何想法，将不胜感激.我本人会自己写一些东西，但没有太多时间，如果有人已经做过，也不想重新发明轮子.

在此先感谢

Julian

Hi all,
Does anyone know of a report writer that has an interface that can list all your tables/columns in a database and build up a query based on what you''ve selected and produce a csv file or something at the end?

Either open source or stand alone...?

Any ideas would be appreciated. I''d write something myself, but don''t have much time and didn''t want to reinvent the wheel if someone''s done it already.

Thanks in advance

Julian

推荐答案

看看报表生成器 [ ^ ].

您可以设计模型，然后设计该模型的数据视图以公开所有表.您可以拖放表格中的字段，应用排序，过滤等.一旦准备好报告，就可以打印，导出为各种格式.

示例文章介绍了创建过程的逐步说明:使用报表生成器生成报表 [ ^ ]

Have a look at Report Builder[^].

You can design your model and then a dataview over that model exposing all the tables. You can drag-drop the fields in tables, apply sorting, filtering etc. Once report is ready, you can print, export into various format.

Sample article explaining the creation step-by-step: Using Report Builder to build reports[^]

您好，谢谢Sandeep，我认为Report Builder是特定于SQL Server的，对吗?

我们需要连接到Alpha数据库，所以我想使用一个可以连接到任何数据库的报表编写器.

干杯

J

Hi, thanks Sandeep, I think Report Builder is SQL Server specific, am I right in saying that?

We need to connect to an Alpha DB, so I was after a report writer that could connect to any database.

Cheers

J

这篇关于通用报告撰写人的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！