Home Forums Reporting Services SSRS 2012 Subreport shows headers even when there are no values? RE: Subreport shows headers even when there are no values?
derek-1087442
Newbie
Points: 4
More actions
September 22, 2015 at 5:33 am
#1828335
If you don't want to join the Film table in, you could add an exists clause to the select:
select Countryid, CountryName
from Country
where exists (
select *
from Film
where Film.CountryID = Country.CountryID
and RunTimeInMinutes <= @MaxRunTime)