Issue: Report Unexpectedly Missing Data

Issue: Report Unexpectedly Missing Data

Some Users tell us that infrequently a report may be displayed that is missing data when previewed. There are various possible reasons for this issue, but one cause may be a defective report dataset definition.

This article explains a pre-test to apply to your report to determine if this may be the issue, and then the procedure for fixing the issue if the test is positive.

Symptom : Missing data on a rendered report.

Pre-Test : Open the report in the Report Designer and use the View Data command to verify that data exists in each dataset table.

Resolution : Redefine the dataset definitions of the tables that are blank.

See the tutorials below for the steps to perform in the Pre-Test and the Resolution above.

Pre-Test Tutorial

  1. Open Toolbox and click: “Toolbox Setup > Design Reports > Design Manufacturing Report (or the report type needed).”
  2. Click “Open Report,” select the report that is unexpectedly missing data, select the work order and batch if applicable, and click “Designer” to open the report in the report designer.
  3. Click the “Dictionary” tab in the lower right corner of the designer, expand “Data Sources > NewDataSet.”
  4. Right-click on each table to confirm that the resulting grid contains data. If the resulting data grid looks like Figure 1, it is OK. If it is blank and looks like Figure 2, the dataset definition needs to be repaired.

  5. Fig. 1



    Fig. 2


  6. If the data grid is blank like Figure 2, proceed with the “Resolution Tutorial” below. Otherwise, look elsewhere for a solution to the missing data.

Resolution Tutorial

  1. If you have the report open in the report designer, close it and open it again in the Report Viewer, so you see the rendered report.
  2. Click the button: “Edit Data Source” and click the database type for the offending table found in the pre-test above.

  3. Fig. 3 


  4. Uncheck the checkbox for the offending table, and click OK.
  5. Open the again in the Report Viewer, so you see the rendered report.
  6. Click the button: “Edit Data Source” again and click the database type for the same offending table.
  7. Check the checkbox ON for the table, and click OK.
  8. Repeat the Pre-Test above to verify the issue has been fixed.

This procedure redefines the dataset as defined in the factory database.

This issue happens infrequently, so if you can duplicate the broken dataset, send us the procedure you used to break the report. We would love to hear from you in the comments section below.

Watch the attached video to see a demonstration of the tutorials in this article.


    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 24.0322

      Additions Added the Master Angled Ends Cabinet. Added a Global prompt, "Hinge Plate Offset From Front" for easier control. Added “Double Division” option to Horizontal Designer Cabinets, 3 Door Cabinets, and other similar products. Added a new ...
    • Common Floating License Connectivity Issues

      This document lists common issues reported by users regarding the topic of Microvellum’s Floating License Activation (FLA) and the connectivity required for FLA to function. Firewall Blocking Activation of Floating License Some users have had an ...
    • Toolbox Release Notes | Build 24.1.0318.641

      The following release notes apply to Toolbox build 24.1.0318.641 Shadowline Fix Figure 1: Shadowline shaping issue (left) and fixed (right). There were reports of users experiencing issues with products having incorrectly shaped shadow lines when the ...
    • Toolbox Release Notes | Build 24.1.0312.641

      The following release notes apply to Toolbox build 24.1.0312.641 Processing Station IDs Processing stations will have IDs added to them as an option within the Toolbox UI, to better distinguish between different processing stations. Perfect Graining ...
    • Toolbox Release Notes | Build 24.1.0306.641

      The following release notes apply to Toolbox build 24.1.0306.641 Destroy Offal Fix Figure 1: Destroy Offal arc part issue. There was an issue reported by users utilizing nesting with the “Destroy Offal” setting applied during processing. ...