First, a custom data source must be added that allows access to attachments or GIS thumbnails that can be added to reports.

1. Open the Report Designer.
2. Click the Data tab and click Add.
3. Enter the Name of the data source.

The Provider is set to Shared Reference.

4. Select Cityworks Resources as the Reference.
5. Click Test Connection.
6. Click Add.

If you are building a query that brings in attachments based on the work activity ID entered when viewing the report, a parameter must be configured first before the query is built in the data set.

1. In the Parameters section click Add.

2. Select the parameter.

3. Enter a Name for the parameter.
4. Enter the Prompt.
5. Select the applicable Data Type. See Print Parameters to see which data type should be selected.
6. Under Available Values, select From Query.
7. In the Data Set Name drop-down list, select the data set created above.
8. Select the Value and Label Fields.

9. Click the back arrow next to Edit Parameter.

Now a data set can be added.

After a custom data source is added, a data set should be added with a query pointing to where the wanted attachments are.

1. Click Add Data Set next to the CityworksReference data source in the Data Sources section.

2. On the New Data Set panel, confirm it says Based on CityworksReference at the top of the panel. Attachment data sets must be based on this data source.
3. Edit the Name of the data set. Data set names cannot have spaces, but underscores or camel case can be used.
4. Select Command Type. The default is Text.
5. Enter something similar in the Query field to connect to the files wanted:

TIP: Use an asterisk (*) in a query at the end to pull in all attachments in a folder. If all attachments for an activity are configured to be added to a report, even those attachments which have been added and then removed from the work activity appear on the report. If there are many attachments in the folder, it may attempt to pull in thousands of records, if not more, and cause a performance backlog as well as not returning the desired results.

• GIS Thumbnails
• thumbnail:workorder[WorkOrderId].png
• This query fetches all images from the work order ID entered when the report is viewed.
• thumbnail:case[Case_Object_Id].png
• This query fetches all images from the case ID entered when the report is viewed.
• thumbnail:inspection[InspectionID].png
• This query fetches all inspection related map images for the inspection ID entered when the report is viewed.
• thumbnail:request[RequestID].png
• This query fetches all service request related map images for the service request ID entered when the report is viewed.

• Attachments
• attachment:WorkOrder/[WorkOrderID]/*
• This query fetches all attachments related to the work order ID entered when the report is viewed.
• attachment:Inspection/[InspectionId]/*
• This query fetches all attachments related to the inspection ID entered when the report is viewed.
• attachment:Request/[RequestId]/*
• This query fetches all attachments related to the service request ID entered when the report is viewed.
• attachment:Case/[CA_OBJECT_ID]/*
• This query fetches all attachments related to the case ID entered when the report is viewed.
• attachment:reldocs/[CA_OBJECT_ID]/payments/*
• This query fetches all payment attachments related to the case ID entered when the report is viewed.
• attachment:reldocs/[CA_OBJECT_ID]/tasks/*
• This query fetches all task attachments related to the case ID entered when the report is viewed.

IMPORTANT: A parameter must be configured if you are entering the ID of a specific work activity when viewing the report. See Create a Parameter for more information.

TIP: Instead of using a parameter and entering an ID, you could enter the specific ID number in the query to pull all attachments from that specific work activity. Additionally, instead of using the asterisk (*), you could enter the specific image file name wanted.

6. Click Validate.

Either a success message or error message appear. If an error message appears, consult the query syntax and adjust accordingly.

7. If a success message appears, click OK.

If you are setting up a data set that includes a parameter, follow the steps below.

8. In the Settings section, click the plus icon next to the Parameters field.
9. Change the Parameter Name to your parameter name, for example workorderid.
10. Click the Data Binding icon to the right of the Value field.

11. Select Expression.
12. Expand Parameters.
13. Double-click the parameter name you created, for example workorderid.
14. Click Save.

15. In the Query field, add a where statement: Where <field_name> = @<parameter_name>

For example, Where workorderid = @workorderid

The data set should look like the example below.

16. Click Validate.
17. Click OK.

WORKAROUND: When a data set is updated or rebound, the data set is cleared from a banded list and a table. After updating a data set, select the banded list or table in the report to open the properties. Select the correct Data Set Name from the Data section to re-establish the link. If it's not updated, no results are returned when the report is generated.

1. Drag Table in the report from the AR Web Designer toolbar and remove all the tables and columns so it leaves one cell.
2. Expand the cell.

3. Drag Image into the report from the AR Web Designer toolbar and select the image box.
4. On the right-side under the Appearance section, and click Expand to the right of the Image field.

5. Select Database from the Source drop-down list.
6. Enter {Stream} in the Value field.
7. Select image/png from the MIME Type drop-down list.
8. Select Fit from the Image Sizing drop-down list.

9. Drag the image control into the table.

IMPORTANT: If you add an image control and render the stream content in it outside of a table or in a container, only the first image in the series renders. No images render in a banded list.