Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The Quick Query Grid to Excel process produces extra records with pagination on

The Quick Query Grid to Excel process produces extra records with pagination on

View products that this article applies to.

Symptoms

You enter the following in the Solomon.ini file:

[QuickQuery]
Paging=Yes
MaxSQLRows=N

Where N is a number less than the total number of records

When you create a new quick query and export it to Microsoft Excel, additional records are created in the Excel spreadsheet.

↑ Back to the top

Resolution

Paging only works if there is a sort column.  Sort the query results before exporting to Microsoft Excel.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3047623
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 381