WEBVTT

00:00:01.400 --> 00:00:07.833
Welcome to this ACE Reports video,
Adding and Modifying Result Objects

00:00:07.833 --> 00:00:10.633
and Display of a Report.

00:00:10.633 --> 00:00:16.366
This video will demonstrate how to Add
and Modify Result Objects and the

00:00:16.366 --> 00:00:19.366
Display of a Report.

00:00:19.366 --> 00:00:26.032
You can view and manipulate the display
of available objects in a report table,

00:00:26.033 --> 00:00:30.166
as well as modify the display of a report.

00:00:30.166 --> 00:00:35.599
Result Objects are the data elements that
display in the report.

00:00:35.600 --> 00:00:42.000
Please note that new objects added to the
Results Objects pane in the Query Panel

00:00:42.000 --> 00:00:48.866
display in the Available Objects list,
but do not automatically display in the

00:00:48.866 --> 00:00:52.032
existing tables of a report.

00:00:54.133 --> 00:00:56.333
Open a saved report.

00:00:57.566 --> 00:00:59.866
Select Design mode.

00:01:03.400 --> 00:01:08.833
In Design mode, in the Query tab,
select the Edit icon.

00:01:12.800 --> 00:01:15.933
The Query Panel displays.

00:01:15.933 --> 00:01:22.133
If necessary, in the universe outline
menu, expand the folder(s) to display

00:01:22.133 --> 00:01:24.099
available object(s).

00:01:27.833 --> 00:01:34.133
Please note that you can also search for
an object by typing text in the Type here

00:01:34.133 --> 00:01:40.233
to filter the tree field and selecting
the magnifying glass button.

00:01:40.233 --> 00:01:46.366
Drag and drop a data object from the
universe outline menu pane to the

00:01:46.366 --> 00:01:48.499
Result Objects pane.

00:01:49.033 --> 00:01:54.999
Please note that placement of data objects
within the Result Objects panel does not

00:01:55.000 --> 00:01:58.466
affect how they display in the report.

00:01:58.466 --> 00:02:02.399
Continue to add data objects as needed.

00:02:02.933 --> 00:02:09.866
If necessary, to reorder the objects,
select the object and the desired arrow

00:02:09.866 --> 00:02:13.532
to move the object left or right.

00:02:13.533 --> 00:02:19.066
Please note that you can also click and
drag objects to reorder them in the

00:02:19.066 --> 00:02:21.199
Result Objects pane.

00:02:21.600 --> 00:02:25.700
If necessary, to remove a Result Object:

00:02:25.700 --> 00:02:29.900
Select the object to display
the remove icon.

00:02:29.900 --> 00:02:33.866
Select the remove icon to
remove the object.

00:02:36.300 --> 00:02:39.100
Select the Apply and Close button.

00:02:40.566 --> 00:02:46.632
It is important to note that if the report
being modified has previously been run

00:02:46.633 --> 00:02:53.566
and has data displaying, when the user
selects Apply and Close it is going to

00:02:53.566 --> 00:02:57.232
clear the existing data from the report.

00:02:57.233 --> 00:03:00.966
This is normal. Refresh the report.

00:03:12.233 --> 00:03:13.766
In the main panel:

00:03:13.766 --> 00:03:18.032
Select the Show document
dictionary button.

00:03:18.033 --> 00:03:23.799
If necessary, expand the Dimensions
and/or Measures folders.

00:03:27.666 --> 00:03:30.399
Select the Show Main Panel button.

00:03:32.000 --> 00:03:35.733
Drag and drop an object into your report.

00:03:41.266 --> 00:03:47.399
Please note that you can select multiple
objects by holding the CTRL button while

00:03:47.400 --> 00:03:49.866
selecting objects.

00:03:49.866 --> 00:03:54.032
The report displays the new data object(s).

00:03:54.033 --> 00:03:55.566
Save the report.

00:03:59.233 --> 00:04:01.366
Refresh the report.

00:04:12.466 --> 00:04:19.032
This concludes our demonstration of how to
Add and Modify Result Objects and the

00:04:19.033 --> 00:04:21.299
Display of a Report.

00:04:21.300 --> 00:04:30.533
If you have any questions,
email acetraining@cbp.dhs.gov.