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?

  • 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)