ShoWorks Help Articles

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

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:
   • ShoWorks 2009 users: In the Report Wizard step 3 (Grouping step), uncheck the box that reads "Hide repeated rows".
   • ShoWorks 2006 users: Add a unique field to the report such as "Entry Number".  Therefore all 7 records will be returned since each record has a unique Entry Number.
      
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.