See Sample Data
Once you open the JDE table, the second step is to get some sample data. Data Access Studio is a visual report writing system. Getting sample data helps users visualize the report as they design it. Refer to the following Data Access Studio main tool bars:
Find and Find Progress toolbar:
Quick menu toolbar:
To | Do this |
---|---|
See sample data with no filter | Click the Get Sample Data button. |
See sample data with a filter | Enter filter information in the Filter Boxes underneath each Column Header. Click the Get Sample Data button. |
See sample data with count of total records | Enter filter information in the Filter Boxes underneath each Column Header. Click the Find with Count button. Note that if the administrator restricts this capability, you will not see the Find with Count button. Note that if you do not specify filter information prior to pressing the Find with Count button, Data Access Studio will issue a performance warning. |
Load another page of records | Click the Get More Data button. |
Go to previous page of records in grid | Scroll to the top using the vertical scroll bar. |
Load all records for query | Click the Run Report button. As the report runs, you will see Counting Records, Selecting Records, and then the progress bar loading the records. When the load is done the Progress Indicator will show a full progress bar. |
Go to the first row | Scroll to the top using the vertical scroll bar or click CTRL-Home on your keyboard. |
Cancel a large row load | When you load records, the Cancel button on the toolbar will be enabled. When enabled, you may click the Cancel button to stop the record load. The status bar will indicate that the grid is partially loaded. |