基于任意数据源的报告(列的数量和名称可能会改变)
我需要从给定数据库中导出任意表的所有列的数据(包括外键 GUID 之类的技术)。 我想按照建议使用 LocalReport 类此处,但我不知道如何为任意数据源设置报告(甚至列的数量和名称可能会改变)。
任何帮助,将不胜感激。
I need to export data of all columns (including technical like GUIDs for foreign keys) of an arbitrary table from a given database. I wanted to use LocalReport class as suggested here, but I can't think of how to set up the report for an arbitrary data source (even quantity and names of columns may change).
Any help would be appreciated.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
像报告生成器(sql adhoc 报告)这样的东西会满足您的需求吗?
似乎您需要一份报告才能处理任何数据库中的任何表。 这些东西在 sql 报告中似乎是“硬编码”的。
如果你想让这个工作,我希望它会通过使用代码来生成报告定义,我不知道如何做。
Would something like report builder (sql adhoc reporting) suit your needs instead?
Seems like you need a report to work on any table in any database. These things seem 'hardcoded' in sql reports.
If you were to get this to work, I expect it would be by using code to generate a report definition, which I haven't a clue how to do.