0

I have design report in such a way that rows should display only filtered data based on where "RECORDTYPE=ALL" and another row where "RECORDTYPE=GD" and corresponding columns also filter and fill data by RECORDTYPE.

For design purpose,I created Table with first row as below condition

enter image description here

I tried to use option,"InsertRow-->OutsideGroup- Below",but not able to retrieve data based on Record Type. So,I created another row group based RECORDTYPE as shown below enter image description here

enter image description here

After setting this condition,when I preview the report,I see gaps between rows and I am not sure why the gaps are coming.Please let me know how can we remove gap between rows.

enter image description here

AMDI
  • 895
  • 2
  • 17
  • 40
  • 1
    The expression for the date will display a blank if the `RECORD_TYPE <> 'ALL' `. Should you filter these out instead? – Hannover Fist Mar 10 '20 at 20:26
  • @HannoverFist - I tried something on RowGroup like Expression "RECORD_TYPE" <> "ALL" for first group.But still space is showing – AMDI Mar 11 '20 at 17:54
  • I tried with another option By adding "Parent group" and groupy by Record_Type and hide the Group textboxes and the result is showing as expected. – AMDI Mar 11 '20 at 18:31

1 Answers1

0

To expand on @Hannover Fist's comment, the empty rows are probably showing up because there are rows with empty or NULL data (of the columns used in the tablix) coming back in the data set.

If you filter out empty records from the Tablix (Tablix Properties >> Filters) or from the Row Group (Group Properties >> Filters), those rows won't show.

molleyc
  • 349
  • 2
  • 14