CODEWITHSUNDEEP
reporting-services
Master
Master

Reputation: 2153

How to display two sets of data in a tablix

at the moment I have two tables. I have one table that displays loan summaries. 

Loan    Client     Balance
 11       Bob       100000
 20       Steven    100000
 33       Michael   100000

I need to enhance this table by adding Loan.Notes

Loan    Client     Balance
 11       Bob       50000
 2015-05-06 - Bob came into the office and said we should expect late payments
 20       Steven    100000
 2015-05-06 - Steven came into the office and he will pay this friday
 2015-05-06 - Steven came into the office and said we should expect late payments
 33       Michael   700000

The Notes section has two columns, Date of note and the Note.Subject. May I ask how do I add in the notes section onto the tablix?

Upvotes: 1

Views: 101

Answers (2)

Anup Agrawal
Anup Agrawal

Reputation: 6669

First you need to create the query joining Loan with the 'LoanNotes'.

In your main table group by Loan. In the header of that group show Loan #, client and balance.

enter image description here

In the Detail section based on your requirements merge the column and show the Notes Data. In the following case I merged three columns and created a expression as =Fields!NoteDate.Value & " - " & Fields!Subject.Value

enter image description here

Now when you run the report you will get the data as you want.

enter image description here

Optional: In the case where there is no note you will need to write an expression in visibility tab to hide your detail row

=IIF(CountRows("LoanGroup") = 1, True, False)

OR

=CountRows("LoanGroup") = 1

Upvotes: 1

Oceans
Oceans

Reputation: 3509

The best approach for this is to combine the tables into one datatable joining on a similar key.

You can join the tables in your dbms by using queries to create a new view. or you could use this DataSet JOIN Helper.
You can then group in your Tablix as you see fit.

Another solution would be to add multiple DataSets within the same report.
Using multiple datasets in RDLC

Upvotes: 0

Related Questions