Hiding sub reports when no data

• cpinky01

  Ten Centuries

  Points: 1144

  More actions

  May 4, 2011 at 7:16 pm

  #235821

  I have 8 sub report sin the main report.I need to hide when there is no data in the sub report.

  i have done this by finding the count of the data that is comming into the subreport. and in the visibility section when the count is zero i made it invisible other wise visible.

  but,

  this way i need to have all the datasets in the main reports too which decreses the performance.

  so is there any other way.

  thank you in advance

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  May 9, 2011 at 9:36 am

  #1321788

  I am not sure if I understood correctly dear friend. But this may help.

  In the visibility section of child report, use

  ISNOTHING(Fields!Field_Name)

  If there are any values for the fields, ISNOTHING would return FALSE and Visibility condition wouldn't be true.

  Is this what you are loking for??