rdlc报告的设计和分组问题 [英] Problem in designing and grouping rdlc report

问题描述

大家好!!!

我的数据集中有两个表.
表1(月，日期，Vno，VAmt，VDate，AccHead)
表2(AMonth，ARelMonth，AVAmt，AVDate，AVAccHead)

我想显示这样的数据

月||相关月份||优惠券编号||凭单金额|| AccountHead
-------------------------------------------------- --------------------------
四月||三月|| xxx-xxx || 23455 ||头
------三月|| yyy-yyyy || 456546 || AHead
五月||四月|| xxx-xxx || 23455 ||头
------四月|| yyy-yyyy || 456546 || AHead


这里的第一行来自Table1，第二行来自Table2.这将持续到明年的三月.

我不知道该怎么做.我在数据集中有数据.我所需要知道的是如何将两个表中的数据分组以获得这种输出.

HI all !!!

I have two tables in my dataset.
Table1 (Month,Date ,Vno,VAmt,VDate,AccHead)
Table2 (AMonth,ARelMonth,AVAmt,AVDate,AVAccHead )

I want to show data like this

Month || RelatedMonth || VoucherNumber || VoucherAmount || AccountHead
----------------------------------------------------------------------------
April || March || xxx-xxx || 23455 || Head
------ March || yyy-yyyy || 456546 || AHead
May || April || xxx-xxx || 23455 || Head
------ April || yyy-yyyy || 456546 || AHead


here first row is from Table1 and second row is from Table2. This will continue upto March for the next year.

I have no idea how to do this. I have the data in the dataset. All i need to know is how to group the data from the two tables to get this sort of output.

推荐答案

您可以使用Union方法获取表到一个！
您可以使用linq数据源的select事件:

you can use Union method to get to table to one!
you can use selecting event of linq datasource:

protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
        {
            e.Result = dt1.Union(dt2).ToList();
        }

一个列表中有两个表！
现在自定义您的代码！

you have two table in one list!
now customize your code!

这篇关于rdlc报告的设计和分组问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！