To add data from Admin Tab- - anytime you want data from the Admin tab of any Argus table, use the column feature on the Objects Menu. Columns are data pulling fields, so you will want to use free text fields for name tags for to identify the data in them.

1. Objects Menu
2. Select Column
3. Click on Report where you want it.
4. Create a free text tag field to identify data in report.

When you can't find a field in Column, it's because the person who originally created the report didn't choose all fields. You must select the field you need but can't find.

1. Click the SQL icon in the 2nd row of icons.
2. From the dropdown menu within the box on the left, click the field you want. These are all the available tables.
3. Click SQL again.
4. The field is automatically inserted in the upper right corner, under the header band.

If you click on lots of fields in SQL, they will stack horizontally, so don't lose them.

If you get a message "Cannot connect graphically", shut down PowerBuilder and restart.

Superfields are user defined, so Questor has written code to grab these fields. Users must copy this code to use in their reports.

1. From within your report, Click on Library icon.
2. Open Standard reports library. (reports_standard.pbl).
3. Double click on the nest report that contains the superfield code you need:

   eg..Activity-Nest-Object-Acq-consideration.

4. Right click on the open nest report to select Properties.
5. Within Properties, click on More to see the entire line of code.
6. Whatever is in quotes is the name of the Superfield. Highlight, right click and copy the code..
7. Return to your report.
8. Select Objects.
9. Select Computed field.
10. Click on desired display spot in report.
11. Click in Expressions white space.
12. Click on More, right click and click Paste.
13. To add a key for the Superfield if necessary (each column has its own key and the report must be told which to choose if the key is in the Expression, but not in Columns.). [Note: Every Argus tab has a unique key (ie. PowerBuilder tables have unique keys), but not every superfield.) Keys have names such as activity_key and object_key.]

1. Cancel out of Objects menu.
2. Choose SQL icon (to pull fields that are not already loaded)
3. If changes need to be made between tables, change the Expression (eg. Change object_key to activity_key)
4. Click ok twice.
5. Right click on the box to name the superfield (no spaces, use underscores.)
6. Click Ok. The screen will display this name at the bottom of the screen when displaying the superfield box in a report which is helpful for superfields with small boxes in a report where all of the superfield information does not have to appear in the code.

Note: The standard report superfield-nest-for_all_tables will install all superfields into a report. However, a superfield cannot be deleted from this nest, so it may not always be a desirable choice.

To insert data from Argus tabs other than Admin and Description you will need to insert a nest with that data. A nest is a mini report inserted in the larger report.

1. Click on Library icon.
2. Select Standard reports library (reports_standard.pbl).
3. Click on the nest report that contains the code for the data you need.

   e.g. Object-nest-location_history (to get a location report)
   or better still,
   e.g. Object-nest_location_current(to get a location report)

4. Close nest after confirming that it contains the data you want.

Tip: For more complete discussion and instruction, see also Nests

Tip: When you're modifying reports, go to SQL to make sure all the tables for data fields listed there still pertain to the report you are modifying. If you leave the location table up in there, for example, SQL continues to look for a data field found in the location table.