on Jun 2, 2017The Pro team is excited to begin work on Reports for a future release. We would love to get some input as to what our users' needs are in regards to functionality and appearance. If you frequently make reports and would like to send us a sanitized (no sensitive data) report, please email arajendran@esri.com.
I look forward to hearing from you all!
Hi Michael!
Can I reach out to you via email? I would love to continue this conversation!
Thanks,
Alycia
It would be really great to allow users to create reports using "full" SQL queries, including related table data inside the file and enterprise geodatabase and with many more design options for reporting/templates than in an existing from ArcMap.
I'm also ready to help and test this, for me and my company (Nevsun), very important ArcGIS Pro capability.
Hi! Please send me an email (address in the original post). I'd love to learn more about what your company needs from us!
- Alycia
It would be super cool to be able to add Geodatabase attachments like photos taken with collector app a part of a report. Do you have an idea when It might be possible?
Best regards
-Peter
I agree Peter! It is really important for any Report type!
Glad to see movement on Pro with reporting. The comments above reflect much of what I am hoping to see in the future. I'm currently working with the collector application to gather information on our storm-water outfalls. Along with some general observations being documented several pictures are being attached. Based on a review of Arc Map and Pro I will not be able to easily generate a report with the attached images included. I think as many organizations move to use collector or survey123 as part of their work process being able to generate a report that allows for customization and inclusion of photographs would be very helpful.
Thanks
Hey Alycia,
This will be such a great addition. I would say the biggest improvement you can have would be the design element. ArcMap Report Creation was a very difficult way to design reports. Obviously, the common standard is something like Microsoft Word. Since ArcPro has the same ribbon design perhaps you can have a similar Report Design option where it opens a blank word document and you can easily link to multiple geodatabases through a Pane.
I also agree with Richard Rahe (Above) about the attachments. Applying the attachments from a Survey123 project or Collector for ArcGIS project would be amazing.
I look froward to this addition. I would love to be able to take a project from Feature Class Creation, to Collector, to Report. It would really complete the entire process.
Exciting News!!!
Are you still looking for input on this? I would love to send you some examples of reports I create and would absolute love to see added into the ArcGIS pro functionality. I'm currently trying to hack a report together in the ArcMap Desktop and it's working okay for this basic need, but I have big ideas for other things I do with printed infographics and such.
Hi Jami. I'll speak for Alycia. Yes! Please send examples of what you'd like to see in Pro.
Cheers,
Kory
Customer Advocacy Lead - Desktop
I'm very interested in the development of reports in ArcGIS pro too. I work in Local Government in the UK and am in the process of trying to move more of our databases away from Access and into ArcGIS, but we currently do all of our reporting in Access 2013 because it is quick and easy to do compared to ArcMap, I can embed photos and .jpg of maps, and the final output can be quite slick looking (depending how much time I have!) If the reporting component of AGP could produce as good results as Access 2013 for our needs then it would help the case for using AGP full-time.
The things I'm looking for in reporting is:
1. Embed data driven snap shots of sites in the report (I currently do this manually using .jpg exports)
2. Embed site photos using attachment links
3. Stylish templates for quick reports
4. Ability to easily create own report designs and templates
5. Attractive and professional looking outputs
6. Display the output of select by location queries on the fly, e.g. is a site in an Area of Outstanding Natural Beauty?
So I use MS Access to link into the attribute tables of a personal geodatabase. With Access as the so called front end I can write any query and report any way I need. Unfortunately Access is unable to link to the attributes in a shapefile or file geodatabase or an online layer or feature service. So what I would like to see is a simple query tool where I can drag and drop fields or even create a calculated field based on existing fields. Then be able to export that table into MS Excel.
So I am wondering if that tool already exists or if there is a work around.
Roger
Hi Roger!
Could you send me an email so I could get a little more information? We may already have a workflow for this in Pro 2.2; I just need to clarify a few things. My email is arajendran@esri.com or feel free to send me a message through GeoNet!
Thanks,
Alycia
Hi,
I agree with the others, attachments were a bit tricky to add in ArcMap, an improved workflow for that would be nice. An easier way not to show "Null"-values would be great. In ArcMap you could use an expression to get rid of them, but it was a little bit tricky as well. If it would be possible to get a button that says "don´t show Null values" that would be great!
When will reports be available in Pro? We´re waiting!
Nicholas
The first phase of Reports will be released in ArcGIS Pro 2.3 in early 2019 (coming soon!) as shown in ArcGIS Pro Roadmap - September 2018
Hi Nicholas! If you would like, you can send me an email so we can talk about your reporting needs specifically! arajendran@esri.com
Thanks!
I would like to see more flexibility with the reporting tool for page footers and report footers. Currently a page footer goes on the bottom of every page. It would be nice if the first page or last page could be skipped. Also, the report footer location goes at the end of the report and it would be beneficial to have the option to put it at the end of the report but at the bottom of the page.
Hi Michael,
Sorry for the delay. If you select your page footer section in the Contents pane, you will see a new contextual tab. From there, the option to exclude your page footer from pages is available:
If your report is 24 pages, you would type "1, 24" in that box, similar to Microsoft Office software. You may run into the issue of not knowing how many pages are in your report, but you can export only the last page to get the total page number:
Although we do not support report footers at the bottom of the last page yet, I will bring this back to my team so we can discuss it further. I agree, it is very beneficial.
Thanks for your feedback!
- Alycia
We also would be interested in helping. We currently do a lot of reports generated out of SQL and in some instances manually. This would be very helpful in pro especially for our environmental staff. Anything that you can do to include attachments and a map would be awesome for environmental assessments, Construction Inspections, and photo logs. We would be more than happy to send you a few examples and help test.
Thanks,
Matt
Hi Matt!
We'd love for you to help! The first release of reports was Pro 2.3. We don't have attachment or map support (yet). It would be great to talk more about your workflows and requirements and get some of those examples. Could you send me an email? arajendran@esri.com
Thanks!
- Alycia
Hey Alycia - who’s Matt?
Mike Honeyman
General Manager
Honeyman Morris Inc.
250-908-0105 | www.hm-inc.ca<http://www.hm-inc.ca>
Kimberley, BC Canada
Hey Mike!
Matt is the person I was responding to Please see the comment above mine.
- Alycia
Gotcha!!!! Thanks I see now.
Have an awesome day!
Mike Honeyman
General Manager
Honeyman Morris Inc.
250-908-0105 | www.hm-inc.ca<http://www.hm-inc.ca>
Kimberley, BC Canada
I have also been playing with the new Report tool in ArcGIS Pro 2.3 and am not seeing a way to display data linked through a relationship table, is this functionality possible? I have a Parcel feature class which is linked to about three tables through a common ID such as permits. The person doing the report printing has limited GIS knowledge but this function looks great if the relationship data can be read. this would also be a great feature for an ArcGIS Online Web App Widget!
Cassandra
I would like to second the option to display data linked through a relationship table! I need to link ownership data to inspection forms using sidwell's as the primary key. There are workarounds, but they aren't ideal. Thanks!
(another) Cassandra
Is there a way, or can there be a way to have the report tool default to the GDB alias name for a field rather than the actual field name to appear in the template?
I don't see that as an option. It looks like by default the field aliases show up in the header while the actual field names are in the details.
What is the use case for showing the alias vs. the field name? How would you picture this working/where would you expect to find and change this setting?
Particularly on the footer, it would be helpful for aggregated fields to be labeled based upon their alias rather than the field name. For example: "Total Population (mean): 123,456" instead of "tpop (mean): 123,456"
As far as the UI I would think a checkbox asking whether labels or alias' are preferred, appearing on maybe the first or second screen of the report wizard.
Hi Elio,
This is a fantastic idea and my team agrees. We have added an issue for it internally. Thank you for the UI suggestion as well!
Alycia
Thanks!
I've been playing around with the new Report functionality in Pro. I'm used to building reports in SQL Server Reporting Services so maybe I am just expecting too much in Pro, but it seems like there are very minimal options for being able to customize the report.
Maybe I am missing something, but is there no way to have the report details (attributes) boxes grow or shrink based on the amount of text? For example, my report links to a feature class that has a narrative field. Sometimes the narrative is a lengthy description of an incident (a few paragraphs), sometimes not (single line description). How can I ensure that the report text boxes grow/shrink appropriately? If I make the text box in the Details section really big, then I can assume most of the lengthy narratives will all be shown. However, I can't guarantee a really really long description would display. Doing this also makes the report have a ton of unnecessary white space for the records that have minimal text and makes the report look really silly. I guess I'm looking for something more "responsive" that can grow/shrink based on the data.
Another question/comment is: when I was creating the report, I checked the boxes for the majority of fields in my data set to be shown on the report (17 fields). The report generated with only 6 fields displaying, and some extra space where more could have been added. Is 6 the max? It looks like I can copy/paste new fields into the report, but this is also pretty clunky to do.
Lastly - is there a way to add a Map to the report? It would be nice if a map in my Pro Project displayed on the Report Cover page underneath the title. This way someone could look at the map (I'm envisioning having point locations labeled 1-N on the map) and then see the details for each location in the report.
My background is using SSRS as well-you are definitely expecting too much for the first release of reports in Pro :). Here are some responses to your questions.
Growing/shrinking rows in the Details section: this is definitely something we want to include in the future. I've added this as an item to our backlog.
The amount of fields generated on creation: six is the default for the first release, with the ability to add additional fields by copying and pasting from the Contents pane or view (as you have already identified). Another way to add fields is using the Insert tab > Data group > Field button. You must have a section activated or else this button is disabled. We did this to "autofit" in a default way. In the near-term, we will be giving our users more control over what and how report elements are added during the initial creation process.
Maps: We all agree, maps have to be in reports. We are working on a way to make this process as simple and clear as possible--it's coming!
Please never hesitate to reach out! My email address is in the original post.
Thanks,
Alycia
Hi Alycia,
Did you see my post ArcGIS Pro Report with Related Data, we had to stay with ArcMap for the functionality but would love to be fully functional in ArcGIS Pro.
Thanks,
Cassandra
Thanks for showing me! I'll be sure to comment there, but using related data and relationship classes in a Pro report is in our near-term product plan.
- Alycia
Hi Alycia, can you advance us when we expect this release that will include related data and relationship classes?
Thanks!
Gerardo
Hi Gerardo!
Sorry for the delay. "Near-term" means in the next 1-3 releases. I can confirm that they will not be available in Pro 2.5.
- Alycia
Keeping fingers crossed for this as well! I would like to add feature photo attachments as well as information found in a related table (1:1) and also (1:M)
Hi Caitlyn!
Attachments are available in the new 2.5 release! Related reports are in active development right now. Please let me know if you have any other questions!
Thanks,
- Alycia
Where to start. Current Report is very limited. We could use:
-Page layout more like Crystal reports
-Filter by expression doesn't seem to be working well in 2.4
-Possibility to hide a field if it's empy and not show the tag
-Select multiple objects by drawing a square in the screen
-Auto-grow a field based on content
-Field expression in design time
-Add Maps (and auto zoom to selected) in report page
to name a few. Just mimic Crystal report and it would be great ! Tks
Thank you for the feedback! Just to address a few of your concerns:
1. We built the report framework ourselves. Crystal Reports is being depreciated and building our own framework eliminates the limitations of third party software.
2. Filter by expression isn't working well? Could you email me more details as to what is not working? (arajendran@esri.com)
3. Again, not sure what you mean by hiding a field/not showing a tag, please elaborate in an email.
4. This is a good idea and I've taken it back to our team.
5. This is in the product plan and there is a support enhancement request that your organization can follow to get development updates: ENH-000126018
6 & 7. These are in the product plan as well.
I am very sorry you don't like the UI experience. Please don't hesitate to email me for follow up to some of these issues.
Thanks again,
- Alycia
Generating a report with an embedded map image would be very helpful. Definitely could use the ability to connect to sql data and perform a sql query to accompany the image.
Hi Tiffany,
You should be able to connect to a SQL database and use data within it in a report. On creation, you can define an expression in SQL mode (which I know isn't a full query). Could you give me a generic example of a query you would perform?
Thanks,
- Alycia
I'm excited to see the ability to add attachments to reports in v2.5, but I can't get it to work. All I get are blank squares on the PDF export. Am I missing something?
Hi Andrew,
There are a few things that could be happening. A few questions:
1. What is the data source? Is it in your project or external data?
2. Are attachments enabled for the data source?
3. Can you see attachments in the Attribute pane? (Select a record you believe has an attachment and then on the Map tab > Selection group > "Attributes" will open the pane). If there are attachments, you will see three tabs of options: Attributes, Geometry, and Attachments.
Please let me know what you find!
Thanks,
- Alycia
I, along with co-workers, have tried this on multiple computers at different locations with many feature classes. It never works. So clearly we're all making the same mistake or it doesn't work.
Thanks for the quick response, Andrew. It sounds like you may have found a bug in the software. Could you please contact support so we can look into it further?
- Alycia
I can verify that I also have this issue. It seems to be just blank squares for me as well.
Thanks, Isaiah. Please contact our technical support so they can look into the issue. Thanks!
Same issue. Blank squares..no photos. Yes attachments enabled and yes can see in the pop-up. I tried a hosted feature layer and from a local fgdb with the same result. Maybe it has something to do with also having other relationships?
Andrew Milanes Maggie Cloos David Alford Isaiah Aguilera Travis Smith
Thank you all for your feedback. This will be fixed in Pro 2.6. In the future, the best way to communicate bugs with our team is through support.
Thanks!
Hi. I am working with the Report tools in ArcGIS Pro 2.5. The data source is the attribute data from a Workforce assignments feature service. I cannot figure out how to add a Pro map, the dispatcher web map or similar to the report showing the assignment locations for example. This blog suggests that maps can be added to Pro reports (Print reports from ArcGIS Enterprise web apps). What am I missing or doing wrong? I have a small amount of experience with Crystal Reports and SSRS. Many thanks.
This is good news. I work for Freeport-McMoRan an Enterprise user of ESRI products. I would really like the Wizard for the reporting tool to have better default templates than ArcMap. It seemed like ArcMap forced me into making a table of the data instead of giving me the latitude to design my own format. I found out later that I could edit the XML but the intial interface was clunky.
I did like the Group By feature in ArcMap Report feature because it allowed me to order the report based on the priority of the data. At Freeport we are very interested in testing this feature and helping to develop it. I know of several GIS analysts that will want to upgrade or need a reporting solution.
Sincerely,
Michael Wallace