0

How can I suppress empty space of subreport in SSRS. I am passing Main tablix data to subreport as a parameter.

Current Result:

enter image description here

Expected Result: So it there is empty subreport, then it should not show and the subreport 3 should merge with subreport 1 border.

enter image description here

Pedram
  • 6,256
  • 10
  • 65
  • 87
  • Did you put any expression on the visibility property of subreport? – Aldrin Oct 27 '16 at 11:55
  • yes I have put. but not working for me! – Pedram Oct 27 '16 at 11:55
  • You can use an alternative solution: setting a minimum height for your subreport which can automatically grows if necessary. – tezzo Oct 27 '16 at 14:55
  • You can try to set NoRowsMessage to empty string, although I'm not sure if this will help. NoRowsMessage should output in textbox instead of empty subreport and I hope it can shrink to zero height if there is empty text. – grafgenerator Oct 27 '16 at 15:45
  • @tezzo - but then also it'll show blank space as per it's width. I have already tried that, but I want to merge subreport 3 with subreport 1 as I have shown in expected result – Pedram Oct 28 '16 at 03:51

1 Answers1

1

You can try inserting another tablix (with 3 header rows for 3 subreports) inside the main tablix detail row. Then, set the visibility property of inner tablix rows with your conditions.

enter image description here

p2k
  • 2,126
  • 4
  • 23
  • 39