如何在客户报告中使用一些数据表?
我有一份包含这些规格的客户报告 (RDLC)。我正在使用 VS 2008 来实现这个
我有一个 DataSet
有 4 个不同的每个部分的DataTable
。请注意,所有报告都位于 List
中,以便通过一个请求打印一大组数据。
描述
- 位于列表中的所有报告 // 通过一个请求打印一些不同的数据
- 在顶部(在列表中)我们有一个矩形,其中包含一些文本框来表示常见信息
- 在中间我有 2不同的列表,其中包括一些文本框来表示教授和经理的列表(它还必须显示他们的图片、姓名等)
- 然后我有另一个列表来表示组织信息。 (它使用列表内的一些文本框来表示所有组织信息)
- 作为客户报告使用一个数据集。我为不同的报告部分提供了四个
DataTable
。 - 每个
DataTable
都有一个ID
用于分组
- 通用DataTable ID用于对另一个对象的整个列表进行分组(这里大学)
我如何实现这样的报告,虽然我不能使用不同的DataTable
进行分组,因为如果我这样做,我只能显示第一个字段<组的 /code>
如有任何帮助,
请提前致谢
I have a client report (RDLC) with these specifications. and I am using VS 2008 to implement this
I have a DataSet
with 4 Different DataTable
for each section. and note that all of the report located in a List
in order to print a large group of Data with one request.
Description
- all of the report located in a List // to print some different data with one request
- At top (in the list) we have a rectangle which include some Textbox to represent common Information
- At Middle I have 2 different List which include some TextBox To represent List of Professor and Managers ( it also has to show their Picture, with Name and etc)
- Then I have another List to represent The Organizations Information. ( it use some TextBox inside of a List to represent All of the Organizations Information)
- As Client Report work with One Dataset. I provide four
DataTable
for my different Report Sections. - Each
DataTable
Has anID
forGrouping
- The Common DataTable ID use to group the entire of the list for another Object (Here University)
How Can I implement Such a report, While I can't use Different DataTable
for grouping because If I do such a Thing I can Display only the First Field
of the groups
Any Help is Appriciated
Thank you in advance
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
最简单的方法是通过连接四个数据表来创建非标准化数据视图,然后将报告绑定到它。您有 ID 组(这是所有数据表所共有的)。
另一种选择是使用子报告,但在我看来,使用它们而不是上述选项更复杂/效率更低。
The simplest way will be to create an unnormalized data-view by joining your four data tables and then bind your report to it. You have group on ID (that is common to all data tables).
Yet another option would be to use sub-reports but IMO, its more complicated/inefficient to use them instead of above option.