Admin Site
      Back to home
      1. OmniByte Self-Help
      2. FormsPro
      3. Admin Site

      Preventing an Empty Dynamic Table from Printing on Report

      How to prevent an empty dynamic table from printing on a report

      If you have a form that contains a dynamic table that isn't always populated, you may not want the table to print on the report when the table is empty. This can be helpful when you have a simple form. Typically, you'd probably have a form with conditions and based on answers information prints on a report. However, maybe your form just has one dynamic table that techs can skip over when it's not applicable and you don't want that information to print on the report.

      To prevent an empty dynamic table from printing on a report, complete the following.

      1. In the Form Designer, click (Reports) and select your report to open the Report Designer.
      2. Double-click on the sub-table (in this example, Insurance_Information) to open the Report Designer for the sub-table.
      3. Click on the Group HeaderBand.
      4. Click (Expressions) from the right-hand side of the Report Designer. 
      5. Expand the Before Print section.
      6. Click the three dots in the Visible field to open the Expression Editor.
      7. Enter [DataSource.RowCount] > 0 And [DataSource.CurrentRowIndex] < [DataSource.RowCount] and click Apply.
      8. Click OK.
      9. Now click on the DetailSubBand.
      10. Click (Expressions) from the right-hand side of the Report Designer. 
      11. Expand the Before Print section.
      12. Click the three dots in the Visible field to open the Expression Editor.

      13. Enter [DataSource.RowCount] > 0 And [DataSource.CurrentRowIndex] < [DataSource.RowCount] and click Apply.
      14. Click OK.
      15. Save the changes made to the sub-report.
      16. We recommend that you add the dynamic table's label to the Group Header Band. This hides the label on the report when the dynamic table is hidden too. From the toolbox on the left side of the Report Designer, click (Label) and drag a label field into the Group Header Band above the column headings of the dynamic table. Format the label accordingly. 
      17. Save the changes made and close the sub-report.
      18. Back in the main report, remove the label of the dynamic table from the report.
      19. Save the main report and close the Report Designer.
      20. Click(Save) in the Form Designer to save the changes made.
      21. Now, if you don't populate the table, it will not print on the report when the form is submitted.
        In the following illustration notice no insurance information has been entered in the Insurance Information table on the form:
      22. The form has been submitted and the empty Insurance Information table doesn't print on the report.

      FormsPro Report Designer uses DevExpress tools to create reports. For detailed information about DevExpress, see DevExpress Documentation.