-->
Sign in

ShoWorks Help Articles

Print This

One or more entries (or other records) do not show up in custom reports

ArticleID: 113023
Category: Reporting
Date Added: 8/12/2003
Date Last Updated: 12/23/2011

SYMPTOM

One or more entries (or other records) do not show up in custom reports.

CAUSE

This could be caused by the following four possibilities:

  1. The report was filtered by criteria that the records in question do not have.
  2. The user did not choose a field to display in the custom report that is unique to the records in question.
  3. The records were not successfully saved.
  4. The user is viewing a report based on a data file that other than the one where the records in question.

RESOLUTION

  1. The report was filtered by criteria that the records in question do not have.

    Example: A report was created to display entries and filtered where the Division equals "Photography" however the records in question have a different Division such as "Photographics".

    Example: A report was created to display entries and filtered where the Division equals "Photographics" and where Entry Number is between 500 and 600 however some of the records in question have a "Photographics" but their Entry Number is 650, 651, and 652.

    Resolve this by removing one or more filter criteria in the report.
     
  2. The user did not choose a field to display in the custom report that is unique to the records in question.

    Example: "John Doe" has 7 entries recorded.  4 of these are "Photographics" and 3 are "Market Beef" divisions.  If the user creates a report and chooses only the Exhibitor Name and Division field, only two records will be returned because there are only distinct values "Exhibitor Name" and "Division".

    Resolve this by going to the Report Wizard step 3 (Grouping step), uncheck the box that reads "Hide repeated rows".
     
  3. The records were not successfully saved.

    Ensure that records are saved upon creation by either pressing the F9 key to save or clicking the "Next", "Back" or "New" buttons in the menu.
     
  4. The user is viewing a report based on a data file that other than the one where the records in question.

    Example:  The user creates entries and afterwards opens a different data file.


Question not answered in this article?
Click to Contact GladStone support for more information.

Login here with your
Service Plan Number

Need help in locating your Service Plan Number?