... about the "No Records" message for an Empty Subreport. By default, Crystal Reports simply processes each subreport it encounters. If the subreport contains data, the various subreport sections are formatted and the subreport appears within the main report. If the subreport doesn't contain data (linked subreports, for example, may not return any records for a particular occurrence of a linked field), then empty subreport sections, such as a subreport report header containing field titles, will appear on the main report.

You may wish to display a message indicating "No Records" (or something similar) in place of subreports that contain no data. In order to display a "No Records" message, you must actually create logic in the subreport to determine if there are no records. Having determined this, you can display this message in a subreport, hiding any other subreport sections.

1. Open an existing report containing a subreport, or add a new subreport to an existing report.
2. Select the subreport Design tab. If you don't see the subreport Design tab, return to the main report Design tab and double-click the desired subreport object. The subreport Design tab will appear.
3. In an empty report header or footer, add a text object that contains a "No Records" message. There should be no other objects in this report section. Insert an extra report header or footer section, if necessary, for this text object.
4. Conditionally suppress the section containing the "No Records" Message - it should not appear of there are records on the report. A way to test for the existence of records is to test for a non-null value for an always-expected report field. You may, for example, conditionally suppress the report section with a formula that looks like this:
   Not IsNull((Orders.Order ID))
   Note: You may experiment with other ways of determining record counts. However, be aware that checking the value in the RecordNumber built-in formula function, using a Count function, or other similar methods, may actually result in a null value rather than a numeric result, if there are no records on the report.
5. Conditionally suppress all remaining report sections with an "opposite" formula that suppresses the sections if there are not records on the report. You might use a formula that looks like this:
   IsNull((Orders.Order ID))
   Note: If you wish to conditionally suppress multiple report sections (such as Report Header a and Report Header b), you may simply suppress the overall report header area. You to not have to conditionally suppress each report header section.
6. Redisplay the main report Preview tab. Notice that subreports that contain data will show sections that actually show data, while subreports that don't contain data will show only the report section containing the "No Records" text object.
   Note: Ensure that the "Suppress Printing of No Records" option from File | Report options is not selected. If you choose this option, the "No Records" message won't appear with an empty subreport.