CODEWITHSUNDEEP
reporting-servicesrdlcssrs-2008-r2ssrs-tablixssrs-grouping
Abin T Abraham
Abin T Abraham

Reputation: 3

Grouping In RDLC/SSRS reports

I am new to SSRS/RDLC reports and I have to create a report . I have two data sets and in the two sets i have an year field I have to group it by year . First dataset 1 should come based on year after that dataset2 should come according to year.

Thanks in advance

Upvotes: 0

Views: 615

Answers (1)

KidCode
KidCode

Reputation: 4221

It appears that you have two options:

A)Use the Lookup Function to link your two datasets together.

B)Use a subreport(Easier):

Create a three row tablix.

Row 1: Column Headers
Row 2: DataSet 1 Data
Row 3: A Subreport.

Create a second report for your second dataset. You can then add it into the report by following the steps below. 

1.Go to insert > Subreport and click on the third row. This will insert the subreport into the tablix.
2.Highlight all the cells in row 3 and press merge.
3.Right click the Sub Report > Properties.
4.In the text box entitle 'Use this report as the subreport' enter the URL from the second report.

Upvotes: 2

Related Questions