Search code examples
c#reporting-servicesssrs-2008rdlc

rdlc Report table in c# does not display all rows from dataset if group by columns are added

I have followed the link given below to group the data and display related records in each table . And the table should repeat for group by criteria defined.

How to show group by columns on top of the table header instead of on the left in rdlc

I have made all the changes required in the rdlc design and when I ran it , not all the rows are displayed. only first row is displayed and only one table is displayed with only one group by criteria.

Any idea how to fix this ?

I tried removing the group by columns to fix this and now it displays all the records but only under one table ,one group by criteria instead of all the records by group criteria.

Either way I am not able to see the data group by header and table .

Solution

  • As discussed in the comments, you were able to get the detail data to be grouped properly.

    As for the headers, if they are the same, make sure of the following:

    1. The tablix cell containing the group header must be inside the group in which you're grouping on the three variables.

    2. Make sure you're not referencing the field using an aggregate like "First" or "Last". So long as you're within the scope that contains within it row-level data, then you do not need to use aggregates.

    How Aggregates Look

    =First(Fields!FieldX.Value)

    OR

    =First(Fields!FieldX.Value,"DataSet1")

    How it should look

    =Fields!FieldX.Value

    Try that and see if it helps.