Issue

When attempting to open a dataview or picklist, all records do not appear in the results window.  This only occurs in ACCPAC Pro Series 7.3 or later with a Microsoft SQL Server (SQL) database.  Please refer to the list below for some of the issues that may occur:

• A dataview or picklist returns only one hundred records; additional records cannot be seen.
• A custom report that is created from a datadrill prints only one hundred records.
• Once a picklist is opened, there appear to be missing records even though the records exist  in the tables. Typing the ID for the record manually will bring up the record correctly.
• A custom dataview is created to view all the records of a table, however once this dataview is  accessed, it does not sort the records correctly.

Solution or Workaround

This issue usually occurs if the row fetch size for the installation or the specific dataview has been set to something other than returning all records. Row fetch size is a new feature that was added to ACCPAC Pro Series 7.3 and is only available for SQL installations. It defines how many records will be returned for a dataview or picklist. There are three options to choose from:

• Return all qualifying records.
• Return top one hundred qualifying records.
• Return top one thousand qualifying records.

The advantage to returning only the top one hundred or thousand records is that those dataviews and picklists will generate faster than those that return all records. This will be especially useful in situations where a particular dataview is querying an extremely large dataset. These parameters may be set up on individual dataviews or on a system-wide basis.

Set up Row Fetch Size System-Wide

1. Open System Manager (SM).
2. Under Maintain menu point-to Setup and click System Installation.
3. Click Edit.
4. Select either “All,” “100” or “1000” from the Datadriller Row Fetch Size drop-down  box.
5. Click Save.

This will ensure that every dataview in this installation will return only the number of records  specified.

Set up Row Fetch Size in a Specific Dataview

1. Open a dataview.
2. Click Advanced.
3. Select either “List All,” “List 100” or “List 1000” from the Row Fetch Size drop-down  box.
4. Name and save this advanced filter.

This dataview will now return only the number of records specified in the advanced filter and will override the row fetch size defined in SM.

© Copyright Sage Software