Getting Started #
The @TopRows parameter allows you to download a specific number of records and can be useful when working with larger datasets. The smaller download is faster and allows you to review the layout before making additional adjustments.
It can be added to Tables or Reports depending on your needs.
Add Top Rows Parameter #
The example below downloads the Job Cost Detail (JCCD) table since that usually contains 100,000+ records.
Click the Add Report button on the left side of the ribbon.
Search for the Table containing the records. The Vista form name usually works.
Either double-click on the Table or select it and click the Save Changes button.
The base SQL Statement will download all records and all columns.
Click the Select button to add the @TopRows parameter.
Add @TopRows to the Top # of Rows field.
Click the Save Changes button.
That will add the @TopRows parameter to the SQL Statement field.
Click the Download Changes button.
You will see a TopRows parameter. Enter the number of records you want to download.
Click the Download button.
The saved Parameter and SQL Statement values show the number of records downloaded.
Download All Records #
When you remove the value from the @TopRows parameter then all records will be downloaded.
Download Blank Table #
When you enter a value of 0 (zero) in the @TopRows parameter then a blank template is downloaded for you to add new records and/or rearrange the columns.
Remove Parameter #
To remove the @TopRows parameter, click the Edit Query button on the ribbon.
Go to the Select option on the left side.
Remove the value from the Top # of Rows field.
Click the Save Changes button.
That removes the parameter from the SQL Statement field.
Click the Download Changes button to download the data again.
