Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Unanswered: Print Subreport header when data is null

    I have a report with seven subreports. When one of the subreports data is null, space is taken up between the reports. I would like to show the report header even if there is no data to show.
    Thanks Vacco

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Try this....In the ControlSource property for your first subreport field:

    Nz(myFieldName,"No Data Available")

    OR

    Nz(myFieldName," ")


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •