How to Format Your Reports in Geocortex Reporting

How to Format Your Reports [Geocortex Tech Tip]

Ryan Cooney
Ryan Cooney
Product Owner
October 11, 2019

How to Format Your Reports [Geocortex Tech Tip]

How to Format Your Reports in Geocortex Reporting

When it comes to integrating different sources of information in your mapping applications, it can be a challenge to retrieve and present the data in a meaningful way. Combining this with the growing need to meet more complex reporting requirements, it’s clear that there needs to be an easier approach.

Fortunately, formatting reports in Geocortex Reporting has never been easier. Whether it’s broad information or a very specific set of data sources, this technology has all the tools you need to deliver key information to the right people with configurable reports.

In today’s Tech Tip, we explore some of the keys to formatting reports in Geocortex Reporting, making it more meaningful and understandable for your end users.

Watch on YouTube.

Video Transcript

“Hi my name is Ryan. Today I’d like to show you how you can format your reports, so that you can present the right information to your users rather than raw data. Let’s see how it’s done!

Here’s a report I set up ahead of time. I’m using an ArcGIS Server feature layer containing ambulance data and you can see we’ve got some fields here that are text, dates, numbers, etc.

If we preview this to get a look at what the date is. I’m going to supply a few feature IDs here, so that you can see some of the data, you can see that I’ve got my text fields, here’s my date, I’ve got some numbers. These numbers here, for status and typos are actually domain values. It isn’t the most nicely formatted data that we have available, so let’s see if we can do better on that.

I’m going to take a look at the date column here, so the ‘lastreport’ value. If I want to change the formatting of this, we can see previously it was the full date. Let’s say this vehicle report is for a given day and we are not actually interested in the date portion, we’re just after the time. What we could do is on the last report entry, we can see that it’s expression is pulling the value from the last report column. We can set this text format string and if it’s a ‘DateTime field,’ there are all sorts of date time formatters available, basically anything you like.

If I want to pick one that trims off, we’re only interested in the time of day, something like that that would probably work well. If I hit preview and run that again, we should be able to see that we just have the time.

I’ve just noticed that this particular one doesn’t have a value for the day, it must be that the data and the date in the databases is null. There’s a way where we can deal with that. On the same entry here, if you use the search up here to search for properties that start with null, there’s this property under the data section called ‘Null Value Text.’ We can just enter a value and if the value of the data is null, it’ll supply this value.

Maybe I’m going to put something like ‘Unknown’ in rather than empty. If we preview that we, should see something a little friendlier.

There we go. So, we have an unknown date and we can put in whatever you like and that’s going to work for all sorts of different types not just dates.

Let’s go to this next one. So, speed, we’re just pulling in the value of the speed, it’s a number (I don’t actually know if this is integers or decimal places), but if I wanted to fix it to decimal places, I can use that same text format string, and select number. There are a few variations on this, but if I just select this one, that’s going to show a number with two decimal places, I can trim it off to one. Now when I preview, we should see our speed. Funny enough, all these vehicles are going exact same speed.

Next columns here, the domain value columns for status type. These are really important to deal with because nobody’s going to know what the codes mean. If I select this status, our expression is just pulling the status column, but we have a way to deal with domain values. If you go into the ‘Functions’ in the Expression Editor and select “GIS”, there’s a function called ‘GetDomainDescription,’ and what it’s doing is it’s going to take the value of the ‘@feature’ column, which is something that sort of built into the system. Then, it’s going to extract the domain for a given field name. I just need to plug in our ‘status’ field name right there, and then that should work.

That’s much nicer. This is an active one instead of a just a number. We can do the exact same thing for the type one. We go back to our functions ‘GIS,’ ‘GetDomainDescription,’ and then we just have to update the field name. The field name we are after is ‘type’ here. There we go!

The last thing I’d like to show you here is how we can add page numbers to this. This might be a report on hundreds of vehicles, it could be many pages so we might want to say this is page 105, something like that. There is this page info control and we can drag in, often you’ll put it in the footer. It has various bits of page information that we can supply, but one of them is the display out of the current page out of the total number of pages.

We can see that running. We can see one of one. A couple things we might want to do here, often these things are going to be aligned a little differently. We could say our alignment should be right aligned. There we go.

Also, you might not want to just see one of one, we might want something a little fancier like page one of one, and you can actually modify a text format string here.

Basically, there are placeholders for the current page value and the total page values. If we run that, we should get something that looks pretty good.

There we go, page one of one. Of course, that’ll update when you have more pages,

Hopefully I was able to show you a few things that make your reports have a little fancier formatting so you can get the right users out to your end users.

Thanks for watching!”

If you enjoyed learning the art of formatting reports in Geocortex Reporting and want to learn more, click the button below to dive deeper into the product or to schedule a personal demonstration.

Discover Geocortex Reporting


Categories:
Archive
Open: 2019
2019
November 1, 2019

How to reference symbology from web maps [Geocortex Tech Tip]

October 25, 2019

How Geocortex Mobile can integrate with other apps [Geocortex Tech Tip]

October 18, 2019

Implementing Arcade Expressions in Geocortex Essentials [Geocortex Tech Tip]

October 17, 2019

Customer Spotlight: Geocortex Mobile

October 11, 2019

How to Format Your Reports [Geocortex Tech Tip]

October 4, 2019

Showing an image in a form after a file picker [Geocortex Tech Tip]

October 2, 2019

Richard Wiegmann Joins VertiGIS as President and CEO

September 27, 2019

Understanding the toolbar in Geocortex Web [Geocortex Tech Tip]

September 20, 2019

Refining Results in Geocortex Web [Geocortex Tech Tip]

September 19, 2019

Charting data using Geocortex Reporting: Honing your charting skills

September 13, 2019

Utilizing the flexibility of layout in Geocortex Web [Geocortex Tech Tip]

September 6, 2019

Creating Geocortex Web applications that move seamlessly between 2D and 3D [Geocortex Tech Tip]

August 28, 2019

Geocortex adds support for Arcade scripting and ArcGIS Online smart mapping

August 23, 2019

How to create sections and groups for your reports [Geocortex Tech Tip]

August 16, 2019

Displaying SQL Server Data in Geocortex Workflow [Geocortex Tech Tip]

August 14, 2019

Customer Spotlight: Geocortex Essentials

August 8, 2019

City of Austin: Spreading floodplain awareness with Geocortex

August 1, 2019

Geocortex Essentials 4.12: Improved integration with ArcGIS® Online

July 25, 2019

Introduction to Geocortex Printing: Learn to build stunning print templates

July 17, 2019

Updates to the Geocortex Product Life Cycle

July 8, 2019

Extending Web AppBuilder for ArcGIS® with Geocortex Essentials [Webinar]

July 4, 2019

City of Bellingham: Using Geocortex to take the stress out of water shut-off

June 27, 2019

Geocortex at the 2019 Esri User Conference

June 14, 2019

Customer Spotlight: Geocortex Workflow

May 17, 2019

Important Notice - Outage Issues & New Support Cases

May 17, 2019

How to build a summary report with aggregations of feature data [Geocortex Tech Tip]

May 16, 2019

Technology Q&A: Geocortex Mobile

May 10, 2019

How to create print templates for Web AppBuilder for ArcGIS®[Geocortex Tech Tip]

May 8, 2019

Dive into Geocortex Printing [Webinar]

May 3, 2019

Using Geocortex Workflow and Geocortex Reporting to produce a multi-layer report [Geocortex Tech Tip]

May 1, 2019

Market-Leading GIS Software and Services Companies Join to Form VertiGIS

May 1, 2019

Introducing VertiGIS

April 18, 2019

Integrating Workflows into Geocortex Mobile [Geocortex Tech Tip]

April 17, 2019

Customer Spotlight: Geocortex Reporting

April 12, 2019

Using Geocortex Go to preview app configurations [Geocortex Tech Tip]

April 10, 2019

How to Address Complex Form Navigation Using Geocortex Workflow

April 5, 2019

Building native, offline IOS, Android and Windows apps with Geocortex Mobile Viewer [Geocortex Tech Tip]

April 3, 2019

Streamlining mobile operations with Geocortex Mobile Viewer [Webinar]

March 29, 2019

A better way to run geoprocessing tasks in Web AppBuilder for ArcGIS [Geocortex Tech Tip]

March 28, 2019

Extend the reach and capabilities of your applications with integrations [eBook]

March 22, 2019

Displaying data from SQL Database when you select features [Geocortex Tech Tip]

March 20, 2019

How Geocortex users are enriching the communities they serve

March 15, 2019

How to Configure a Geocortex Essentials layer report with Geocortex Reporting 5 [Geocortex Tech Tip]

March 14, 2019

Region of Waterloo: How GIS & Geocortex technology helped meet local Source Protection Plan requirements

March 6, 2019

Integrating Business Intelligence and Data Sources with Geocortex Essentials [Webinar]

March 1, 2019

How to quickly add attachments to new features when editing [Geocortex Tech Tip]

February 22, 2019

Generating a report with sub reports from external data sources [Geocortex Tech Tip]

February 20, 2019

Geocortex Essentials 4.11: Saving Time & Increasing Efficiency

February 15, 2019

Accessing Samples and Building your First Workflow [Geocortex Tech Tip]

February 12, 2019

Open Beta of Geocortex Printing 5 Has Begun

February 8, 2019

Different Ways of Creating Selections of Features in Geocortex Viewer for HTML 5 [Geocortex Tech Tip]

February 6, 2019

4 Best Practices to Follow When Using Geocortex Workflow 5

February 1, 2019

Creating a Report that Displays a Screenshot of the Map [Geocortex Tech Tip]

January 28, 2019

Diving Into Geocortex Reporting 5 [Geocortex Tech Tip]

January 24, 2019

How Geocortex is Advancing Water Management Solutions

January 16, 2019

Creating Custom User Experiences with Geocortex Workflow 5 [Webinar]

January 11, 2019

Showing the search results using the item picker in Geocortex Workflow 5 [Geocortex Tech Tip]

January 9, 2019

City of Troy: Using GIS and asset management technologies to manage legislative requirements

January 4, 2019

Using scripting to put attachments in reports in Geocortex Reporting 5 [Geocortex Tech Tip]

Open: 2018
2018
December 21, 2018

Integrating Pictometry, Bing and other 3rd party maps within your Geocortex applications

December 19, 2018

Recapping the Texas Geocortex Regional User Group

December 14, 2018

How to use Geocortex Workflow 5 to populate the Attribute Table in Web AppBuilder for ArcGIS [Geocortex Tech Tip]

December 12, 2018

Finding yourself: Using geolocation in mobile and web applications [Webinar]

December 7, 2018

Enabling real-time user-to-user map collaboration within Geocortex Essentials

December 5, 2018

Reflecting on 2018

November 30, 2018

Creating mailing labels with reports with Geocortex Reporting 5 [Geocortex Tech Tip]

November 29, 2018

Alberta Energy Regulator: Supporting safe and responsible energy resource operations

November 26, 2018

Important update for ArcGIS and Transport Layer Security (TLS) Protocol Support!

November 23, 2018

Using fine-grained security to control access to layers, features, attributes and application functionality [Geocortex Tech Tip]

November 21, 2018

Enhancing Web AppBuilder for ArcGIS® with Geocortex Reporting [Webinar]

November 16, 2018

Using Geocortex Workflow 5 to automatically display a form for editing layer attributes [Geocortex Tech Tip]

November 15, 2018

Geocortex Achieves Esri’s “Release Ready Specialty” Designation

November 14, 2018

Celebrating GIS Day with York Regional Police: How GIS Data Has Mitigated Risk & Increased Efficiency in Crime Prevention

November 9, 2018

How to access a SQL database from a workflow using Geocortex Workflow 5 [Geocortex Tech Tip]

November 2, 2018

How to send an email from a workflow using Geocortex Workflow 5 [Geocortex Tech Tip]

October 26, 2018

How to add and configure charts inside reports with Geocortex Reporting 5 [Geocortex Tech Tip]

October 24, 2018

Geocortex Water Webinar Series

October 19, 2018

Integrating Geocortex Essentials with ArcGIS Online and ArcGIS Enterprise portal [Geocortex Tech Tip]

October 17, 2018

Cross-Platform Development with Xamarin [Webinar]

October 12, 2018

City of Fort Collins: Dynamic flood maps for public awareness, and flood insurance rate saving

October 2, 2018

Technology Q&A: Geocortex Workflow 5 “Behind the Firewall”

June 27, 2018

Geocortex Essentials 4.10 is here!

June 12, 2018

Geocortex and the GDPR

June 6, 2018

Geocortex at the 2018 Esri User Conference

May 15, 2018

Technology Q&A: The evolution of Geocortex and Web AppBuilder for ArcGIS

April 25, 2018

How to manage data collected from Geocortex Workflow 5 forms [Geocortex Tech Tip]

April 18, 2018

Delivering accessible mapping applications for everyone [Geocortex Tech Tip]

April 11, 2018

How to search for data in a non-spatial database [Geocortex Tech Tip]

April 5, 2018

Configuring Geocortex Analytics to monitor a new Portal for ArcGIS instance [Geocortex Tech Tip]

March 27, 2018

Getting started with forms in Geocortex Workflow 5 [Geocortex Tech Tip]

March 21, 2018

Using Geocortex Workflow with Web AppBuilder for ArcGIS [Geocortex Tech Tip]

March 15, 2018

Understanding tool usage in your GIS applications [Geocortex Tech Tip]

March 7, 2018

Running Geocortex Essentials workflows from an identify operation [Geocortex Tech Tip]

March 2, 2018

GIS Health Assessment: A new way to think about your system

February 28, 2018

Using the in-app help system in Geocortex Workflow 5 [Geocortex Tech Tip]

February 21, 2018

How to configure a personalized dashboard in Geocortex Analytics [Geocortex Tech Tip]

January 25, 2018

GIS is shifting to SaaS, and it’s a win for everyone


Categories

Popular Tags
Accessibility Active Operating Picture ArcGIS ArcGIS Online customer spotlight Customer Story Data Models Energy Esri Geocortex Geocortex 5-Series Geocortex Analytics Geocortex Essentials geocortex integrations geocortex mobile Geocortex Mobile Viewer geocortex printing Geocortex Printing 5 Geocortex Reporting Geocortex Reporting 5 geocortex tech tip Geocortex Tech Tips geocortex training Geocortex Viewer for HTML5 geocortex web Geocortex Web Viewer Geocortex Workflow Geocortex Workflow 5 GIS GIS Day GIS Health gis integrations Integrations Oil & Gas Pipelines Portal for ArcGIS SaaS Tech Tip Tech Tips Transportation vertigis Water Industry Web AppBuilder Web GIS Xamarin

Contributors