SQL Server Performance

Reporting Services - Sub Report

Discussion in 'SQL Server Reporting Services' started by joshikiran, Nov 16, 2004.

  1. joshikiran New Member

    Hi,

    I have a main report which passes parameters to two subreports to display the corresponding data. Both the SubReports have its Header and Details section. Now the problem is that if one of the Sub report doesnt have any data the entire subreport isnt displayed. Even though the data isn't there i want atleast the Header to be displayed.

    I tried some options but it didnt worked out. if anyone has a solution for this pls let me know asap.

    Thanks...
  2. harsh_sr New Member

    Why don't you create a Textbox(saying "No data Exists") on your Subreport; visibility of which is toggled by count of data on your subreport (you can make a separate dataset just to find count)?

    HTH

    Harsh

Share This Page