# Reports **URL:** https://community.alloyapp.io/c/reports/12.md [Latest](https://community.alloyapp.io/latest.md) · [Categories](https://community.alloyapp.io/categories.md) · [Tags](https://community.alloyapp.io/tags.md) --- ## [About the Reports category](https://community.alloyapp.io/t/about-the-reports-category/337)
**Author:** [@cmcnicholas](https://community.alloyapp.io/u/cmcnicholas)\ **Replies:** 0
Use this category to discuss custom reports, e.g. data sources, document layouts, Report Builder. --- ## [Reporting Audit Logs/Item Status History](https://community.alloyapp.io/t/reporting-audit-logs-item-status-history/765)
**Author:** [@RichardF](https://community.alloyapp.io/u/RichardF)\ **Replies:** 1\ **Last updated:** [29 December 2025 10:19 UTC](https://community.alloyapp.io/t/reporting-audit-logs-item-status-history/765 "2025-12-29T10:19:01Z")
Hello, I’m interested in the functionality to extract individual status update logs/audit logs for items within alloy when reporting. For example, the ability to show a time/date history showing each individual log date/… --- ## [Using set colours as attribute](https://community.alloyapp.io/t/using-set-colours-as-attribute/750)
**Author:** [@Becca](https://community.alloyapp.io/u/Becca)\ **Replies:** 4\ **Last updated:** [9 December 2024 08:03 UTC](https://community.alloyapp.io/t/using-set-colours-as-attribute/750 "2024-12-09T08:03:18Z")
I am building a report to show what work teams have and haven’t managed to complete. At the moment I am using two maps, showing jobs ‘issued’ and jobs ‘completed’. However, both of those statuses have a colour set that … --- ## [Unable to negate "Contains Word"](https://community.alloyapp.io/t/unable-to-negate-contains-word/739)
**Author:** [@CHallam](https://community.alloyapp.io/u/CHallam)\ **Replies:** 1\ **Last updated:** [6 December 2024 11:45 UTC](https://community.alloyapp.io/t/unable-to-negate-contains-word/739 "2024-12-06T11:45:16Z")
Whenever I try to do a “does not contain word” in the AQS - the checkbox to negate is unclickable. --- ## [Repeater as parameter in other AQS query](https://community.alloyapp.io/t/repeater-as-parameter-in-other-aqs-query/743)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 1\ **Last updated:** [6 December 2024 11:43 UTC](https://community.alloyapp.io/t/repeater-as-parameter-in-other-aqs-query/743 "2024-12-06T11:43:37Z")
I have a blank AQS query which returns all my electoral boundaries in Warwickshire. I then have in my Flow output, a repeater based on outputting for each electoral boundary. I have another AQS which returns me flood re… --- ## ['Key' displaying code when exporting AQS Statistic](https://community.alloyapp.io/t/key-displaying-code-when-exporting-aqs-statistic/699)
**Author:** [@Jamie](https://community.alloyapp.io/u/Jamie)\ **Replies:** 2\ **Last updated:** [6 December 2024 10:22 UTC](https://community.alloyapp.io/t/key-displaying-code-when-exporting-aqs-statistic/699 "2024-12-06T10:22:11Z")
Hi, When using an AQS statistic data source, the key value is displaying the inner code when exported and not the ‘specific defect’ value. Is there a way to change this for ease of viewing? --- ## [Querying across Collections](https://community.alloyapp.io/t/querying-across-collections/711)
**Author:** [@CHallam](https://community.alloyapp.io/u/CHallam)\ **Replies:** 3\ **Last updated:** [12 August 2024 13:47 UTC](https://community.alloyapp.io/t/querying-across-collections/711 "2024-08-12T13:47:53Z")
Hi, I have a set of Assets in the “Live” collection, with a large number of inspections in both the “Live” and “Archive” collections. Is there a way to query only the live Assets, but the live and archive inspections. i… --- ## [Identify assets with more than one parent](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692)
**Author:** [@CHallam](https://community.alloyapp.io/u/CHallam)\ **Replies:** 2\ **Last updated:** [10 January 2024 14:52 UTC](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692 "2024-01-10T14:52:21Z")
We have an issue where our staff have accidentally added the same asset to multiple parents. Is there an AQS report which can show me for instance “All lamps with more than one lantern as parent”. --- ## [Add internal alloy ID to a tabular report output](https://community.alloyapp.io/t/add-internal-alloy-id-to-a-tabular-report-output/680)
**Author:** [@CHallam](https://community.alloyapp.io/u/CHallam)\ **Replies:** 1\ **Last updated:** [3 November 2023 12:00 UTC](https://community.alloyapp.io/t/add-internal-alloy-id-to-a-tabular-report-output/680 "2023-11-03T12:00:48Z")
I have a list of jobs, and would like to create a report that outputs the unique alloy ID of the street that it’s attached to via a custom report. The item ID on the report only seems to tally to the job, and there does… --- ## [Report Join to Attachments Error](https://community.alloyapp.io/t/report-join-to-attachments-error/640)
**Author:** [@HowardRanyard](https://community.alloyapp.io/u/HowardRanyard)\ **Replies:** 1\ **Last updated:** [24 July 2023 06:24 UTC](https://community.alloyapp.io/t/report-join-to-attachments-error/640 "2023-07-24T06:24:28Z")
Hi, continuing on from the great solution given to Parent Repeater from within stack That solution works great for items that have attachments, but fails to show items that don’t have attachments, I’ve tried to use othe… --- ## [Parent Repeater from within stack](https://community.alloyapp.io/t/parent-repeater-from-within-stack/638)
**Author:** [@HowardRanyard](https://community.alloyapp.io/u/HowardRanyard)\ **Replies:** 1\ **Last updated:** [19 July 2023 13:20 UTC](https://community.alloyapp.io/t/parent-repeater-from-within-stack/638 "2023-07-19T13:20:45Z")
Hi, I’d like to be able to use a parent repeater context from with a stack. E.g. Repeater: {Horizonal stack: { Table - with data source of the parent repeater, image - from repeater source} } } For more information, … --- ## [Hyperlink in report](https://community.alloyapp.io/t/hyperlink-in-report/636)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 1\ **Last updated:** [14 July 2023 08:16 UTC](https://community.alloyapp.io/t/hyperlink-in-report/636 "2023-07-14T08:16:22Z")
Is it possible to insert hyperlinks into Flow PDF reports? eg provide a link to the item within the report? --- ## [Buffer geometry "on the fly" in a report AQS data source](https://community.alloyapp.io/t/buffer-geometry-on-the-fly-in-a-report-aqs-data-source/635)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 1\ **Last updated:** [12 July 2023 16:09 UTC](https://community.alloyapp.io/t/buffer-geometry-on-the-fly-in-a-report-aqs-data-source/635 "2023-07-12T16:09:32Z")
I can use a workflow computation to update an Item, taking it’s point geometry then buffering this into a circle based on a radius and editing the Item to insert this large circle into another attribute. This attribute t… --- ## [Customer Queries/Defects](https://community.alloyapp.io/t/customer-queries-defects/609)
**Author:** [@simon.scullion](https://community.alloyapp.io/u/simon.scullion)\ **Replies:** 1\ **Last updated:** [13 April 2023 09:52 UTC](https://community.alloyapp.io/t/customer-queries-defects/609 "2023-04-13T09:52:55Z")
Please may ask how to find my defects on alloy desktop? --- ## [Datetime as report title?](https://community.alloyapp.io/t/datetime-as-report-title/616)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 1\ **Last updated:** [3 May 2023 09:41 UTC](https://community.alloyapp.io/t/datetime-as-report-title/616 "2023-05-03T09:41:49Z")
Is it possible to create a report, via a workflow, and set the title of the report as the date & time it was run/raised? I’m aware I can create a data source within the report and feed that onto the actual PDF page but I… --- ## [Multiple items when exporting into excel](https://community.alloyapp.io/t/multiple-items-when-exporting-into-excel/585)
**Author:** [@Jamie](https://community.alloyapp.io/u/Jamie)\ **Replies:** 3\ **Last updated:** [14 March 2023 09:31 UTC](https://community.alloyapp.io/t/multiple-items-when-exporting-into-excel/585 "2023-03-14T09:31:08Z")
Hi, I am currently reporting on defective gully’s after inspection. I have an AQS data source set up to show me every gully that has been inspected and has an outcome of ‘not running’ ‘rodding eye missing’ etc. However … --- ## [Send Report Documents Via Workflow Email](https://community.alloyapp.io/t/send-report-documents-via-workflow-email/588)
**Author:** [@HowardRanyard](https://community.alloyapp.io/u/HowardRanyard)\ **Replies:** 4\ **Last updated:** [15 February 2023 17:38 UTC](https://community.alloyapp.io/t/send-report-documents-via-workflow-email/588 "2023-02-15T17:38:24Z")
Hi, I have a custom report that runs on creation of an item. I have managed to make the the Report Documents a linked items but would prefer them to be attachments, but I get an error while trying to save (not upon clic… --- ## [Html Street map geometry](https://community.alloyapp.io/t/html-street-map-geometry/579)
**Author:** [@phillgeorgiou](https://community.alloyapp.io/u/phillgeorgiou)\ **Replies:** 1\ **Last updated:** [31 January 2023 10:51 UTC](https://community.alloyapp.io/t/html-street-map-geometry/579 "2023-01-31T10:51:39Z")
hi i have custom report which I’ve added in a map which takes the geometry and displays this on the street view map. i find it appears on the PDF but for the HTML view it does not appear? --- ## [Joining child item to parent in Report Data Sources](https://community.alloyapp.io/t/joining-child-item-to-parent-in-report-data-sources/559)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 2\ **Last updated:** [29 November 2022 08:09 UTC](https://community.alloyapp.io/t/joining-child-item-to-parent-in-report-data-sources/559 "2022-11-29T08:09:47Z")
I am trying to create a CSV report for a single inspection item which provides the data for the inspection and it’s parent. I can set up the single item data source in the report builder but I have tied myself in knots … --- ## [Full page map window](https://community.alloyapp.io/t/full-page-map-window/536)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 3\ **Last updated:** [20 October 2022 07:47 UTC](https://community.alloyapp.io/t/full-page-map-window/536 "2022-10-20T07:47:50Z")
Is it possible to make the map window control on a page any taller? I have set the width to 100% but it shows up on my page as a letterbox and is not very useful. --- ## [File image on the custom reports](https://community.alloyapp.io/t/file-image-on-the-custom-reports/531)
**Author:** [@phillgeorgiou](https://community.alloyapp.io/u/phillgeorgiou)\ **Replies:** 4\ **Last updated:** [3 October 2022 10:16 UTC](https://community.alloyapp.io/t/file-image-on-the-custom-reports/531 "2022-10-03T10:16:33Z")
hi i have made a report which takes the item of a fly tipping inspection. in my inspection our teams takes two images a before and after so the photo are different i have added the file image item onto the report howe… --- ## [Linked Attribute - Flow Field Control - Multiple Values](https://community.alloyapp.io/t/linked-attribute-flow-field-control-multiple-values/524)
**Author:** [@chrisbram](https://community.alloyapp.io/u/chrisbram)\ **Replies:** 5\ **Last updated:** [6 September 2022 16:06 UTC](https://community.alloyapp.io/t/linked-attribute-flow-field-control-multiple-values/524 "2022-09-06T16:06:59Z")
I am trying to create a custom report based on our custom Flood Incident inspection design for a single item. One of the fields within this is a linked attribute of which multiple values can be selected. When multiple … --- ## [How to set a custom relative width](https://community.alloyapp.io/t/how-to-set-a-custom-relative-width/507)
**Author:** [@knedas](https://community.alloyapp.io/u/knedas)\ **Replies:** 1\ **Last updated:** [22 June 2022 23:11 UTC](https://community.alloyapp.io/t/how-to-set-a-custom-relative-width/507 "2022-06-22T23:11:21Z")
Is it possible to set a relative width on a control other than the Constant values that increase by an increment of 10%? For example 7% or 15%? I tried getting a Dynamic value from a Number data source using 7 or 0.07 a… --- ## [What audit information can be extracted in relation to login attempts?](https://community.alloyapp.io/t/what-audit-information-can-be-extracted-in-relation-to-login-attempts/205)
**Author:** [@system](https://community.alloyapp.io/u/system)\ **Replies:** 1\ **Last updated:** [30 July 2021 09:54 UTC](https://community.alloyapp.io/t/what-audit-information-can-be-extracted-in-relation-to-login-attempts/205 "2021-07-30T09:54:22Z")
What audit information can be extracted in relation to:login attempts, method of login (local or MS), IP addresses attempts made by email addresses not meeting the @fife.gov.uk domain, both back office and mobile. --- ## [Can a report of current users be generated?](https://community.alloyapp.io/t/can-a-report-of-current-users-be-generated/319)
**Author:** [@system](https://community.alloyapp.io/u/system)\ **Replies:** 1\ **Last updated:** [30 July 2021 09:58 UTC](https://community.alloyapp.io/t/can-a-report-of-current-users-be-generated/319 "2021-07-30T09:58:29Z")
Can WCC obtain a report of current users to review and is there any additional authority required to request the removal of existing accounts?