Combine multiple reporting areas in an ICRW report

Interactive Custom Report Writer (ICRW) allows you to combine and view multiple reporting areas in a single report. This procedure requires the use of custom SQL. To complete the task successfully requires a solid understanding of the following:

  • Data structures upon which your report will be based
  • Custom report design for ICRW and other custom reports
  • SQL for tables, functions, and calculations

For assistance in any of these areas, reach out to the subject matter expert in your organization or your designated support user to contact Support.

Walk-through example

The Construction application requires a separate subscription and related permissions. Expand the following Requirements table for more information on the Construction subscription and permissions.

The ability to view multiple reporting areas in a single report is useful for data analysis across a variety of businesses. For example, a construction company might want to compare the money it owes (AP Bills) with the money it expects to receive (AR Invoices). A report that uses multiple reporting areas can provide this data for the projects in each geographic location.

For complete instructions, see Create an ICRW report with multiple reporting areas.