I have figured it on my own. The solution you suggested was almost right.
To hide the Report Header section when the datasource returns data, a Binding
with Property Path - Parent.Visible and Expression
- =Count(1) = 0 should be added to the TextBox
of the Header Section rather than adding it to the Header Section itself.
And,to hide the Detail section when there are no records found, I have just followed your solution which is to add a Binding to the Detail Section with Property Path - Parent.Visible and Expression set to =Count(1) > 0 and it is working perfect!!.
Thanks for your help, Steve. Really appreciate it!!!!!