topic Re: Creating Reports in Pro in ArcGIS Pro Questions

Creating Reports in Pro

AlyciaRajendran_esri — Fri, 02 Jun 2017 20:10:31 GMT

The 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!

Re: Creating Reports in Pro

MichaelWallace3 — Fri, 02 Feb 2018 21:07:18 GMT

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

Re: Creating Reports in Pro

AlyciaRajendran_esri — Fri, 16 Feb 2018 22:15:04 GMT

Hi Michael!

Can I reach out to you via email? I would love to continue this conversation!

Thanks,

Alycia

Re: Creating Reports in Pro

BranislavBlagojevic — Mon, 19 Feb 2018 11:14:07 GMT

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.

Re: Creating Reports in Pro

AlyciaRajendran_esri — Tue, 20 Feb 2018 16:28:01 GMT

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

Re: Creating Reports in Pro

BranislavBlagojevic — Tue, 20 Feb 2018 16:56:03 GMT

Alycia,

My e-mail address: branislav@bem.co.rs <mailto:branislav@bem.co.rs>

Regards!

Re: Creating Reports in Pro

PeterErbs-Maibing2 — Wed, 14 Mar 2018 06:25:41 GMT

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

Re: Creating Reports in Pro

BranislavBlagojevic — Tue, 27 Mar 2018 09:24:21 GMT

I agree Peter! It is really important for any Report type!

Re: Creating Reports in Pro

RichardRahe — Mon, 16 Apr 2018 16:59:03 GMT

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

Re: Creating Reports in Pro

KennethCompton — Mon, 30 Apr 2018 13:59:27 GMT

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!!!

Re: Creating Reports in Pro

JamiDennis — Wed, 30 May 2018 22:32:48 GMT

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.

Re: Creating Reports in Pro

KoryKramer — Thu, 31 May 2018 18:13:04 GMT

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

Re: Creating Reports in Pro

KellyDodd — Mon, 11 Jun 2018 12:08:08 GMT

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?

Re: Creating Reports in Pro

RogerAlabach — Fri, 21 Sep 2018 19:09:03 GMT

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

Re: Creating Reports in Pro

AlyciaRajendran_esri — Wed, 26 Sep 2018 01:57:13 GMT

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

Re: Creating Reports in Pro

NicholasNilsson — Tue, 20 Nov 2018 07:37:02 GMT

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

Re: Creating Reports in Pro

KoryKramer — Tue, 20 Nov 2018 13:53:37 GMT

The first phase of Reports will be released in ArcGIS Pro 2.3 in early 2019 (coming soon!) as shown in https://community.esri.com/docs/DOC-12346-arcgis-pro-roadmap-september-2018

Re: Creating Reports in Pro

AlyciaRajendran_esri — Wed, 21 Nov 2018 17:04:54 GMT

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!

Re: Creating Reports in Pro

MichaelHoneyman — Thu, 10 Jan 2019 16:21:32 GMT

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.

Re: Creating Reports in Pro

AlyciaRajendran_esri — Thu, 28 Feb 2019 15:11:59 GMT

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