Problem in designing and grouping rdlc report

Question

0.00/5 (No votes)

See more:

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.

Posted 3-Jun-12 22:09pm

ujjwal uniyal

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

taha bahraminezhad Jooneghani · Answer 1 · 2012-06-03T22:19:00

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

C#

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!

Problem in designing and grouping rdlc report

1 solution

Solution 1

Add your solution here

Preview 0

Problem in designing and grouping rdlc report

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us