SSRS sub report does not show on main report when sub report has no values

In SSRS if you use sub report within the main report you might have come across situation like sub report does not show on main report. That is because sub report has no data to bring. There is  a trick that you can use to show sub reports on main report all the time despite sub reports are empty or not. What you can do is, in the sub report create another dataset and write an empty query like below.

 

 

 Then create a hidden textbox on the sub report and use the created dataset and call the empty field here.