COBBLESTONE SOFTWARE
Contract Insight — User Guide
Online Report Designer
03. Admin User Manual › Searching & Reporting › Online Report Designer
Note: Each procedure in this guide begins at the Contract Insight homepage, so any section can be followed on its own. Custom fields are configurable, so the exact field list on a contract category record may vary between environments.
1. Overview
The Online Report Designer is the single-page editor used to build and maintain reports in Contract Insight. Reports are managed from Reports and Insights → Reports, which has two tabs: Ad-Hoc reports (“Every report you can run, grouped by folder”) and Graphical reports (“Print-ready reports laid out page by page”). Ad-Hoc reports open in a section-based designer — Details, Tables, Fields, Filter, Sort, Sharing, Schedule and SQL — with a live preview, and changes save as you go rather than requiring a separate publish step. Graphical reports open in a drag-and-drop page designer.
2. Key Elements
- Ad-Hoc tab: lists every ad-hoc report you can run, grouped by folder, with row actions to Run, Design report (settings icon), Copy this report, Move to folder, and favorite. Reports in the Legacy searches folder can be run or converted with Convert into an Ad-Hoc report, but are not edited in the designer.
- Graphical tab: lists print-ready reports with Open, Open the designer (pencil icon), and delete actions, plus each report's scope (System or Personal), author, shares, and size.
- The Ad-Hoc designer header reads “The report's tables, fields, filter, sort, sharing and schedule. Changes save as you go,” and offers Copy, Delete, preview, and Run buttons.
- A Live preview panel beneath each designer section shows the first 200 rows of the report as you edit it.
- The SQL section shows the report's generated query. It is read-only and regenerates whenever the report's tables, fields, or sort change.
- The designer is also listed as a licensed System Feature on Initial Setup: “Online Report Designer.”
3. Navigating to Reports
- From the Contract Insight homepage, click the Reports and Insights icon in the left navigation bar.
- Select Reports.

The Reports page opens on the Ad-Hoc tab. Click the Graphical tab to switch to print-ready reports.
4. Adding a Report
4a. Adding an Ad-Hoc Report
- Navigate to Reports and Insights → Reports (see Section 3) and confirm the Ad-Hoc tab is selected.
- Click + Add Ad-Hoc Report.

- In the New Ad-Hoc Report window, enter a Report name.
- Select Who it's for: Internal, Vendor Gateway, or Public. Internal reports can be built on any table you're allowed to search. This choice is fixed once the report is created.
- Click Create report. The Online Report Designer opens so you can configure the report (see Section 6).

4b. Adding a Graphical Report
- Navigate to Reports and Insights → Reports and click the Graphical tab.
- Click + Add graphical report.

- The graphical designer opens on a new, blank report. Drag elements onto the canvas, configure data sources from the Dictionary panel, and click Save on the Home ribbon when finished.

Note: Clicking + Add graphical report adds a new Personal report named “New report” to the Graphical list right away. Rename or remove it if you don't continue building it.
5. Managing an Existing Report
5a. Managing an Ad-Hoc Report
- On the Ad-Hoc tab, locate the report (use the Search box or the folder groups).
- Click the Design report (settings/gear) icon on the report's row.

- The Online Report Designer opens on the report's Details section. Use the Sections menu on the left to move between areas of the report and configure as needed (see Section 6).

5b. Managing a Graphical Report
- On the Graphical tab, click the Open the designer (pencil) icon on the report's row. To view the report without editing it, click Open instead.
- The graphical designer opens with the report's existing layout. Make changes and click Save.

6. Configuring an Ad-Hoc Report in the Designer
Each section is listed in the Sections menu with a badge showing how many items it holds (for example, the number of joined tables, chosen fields, or filter conditions). Changes save as you go.
6a. Details
Set the Report name and Description, and choose whether to Send this report on its email schedule, Ask for filter values when the report is run, and Let people open a row's record for editing from the results. Editing from results follows the same field permissions as the record itself. Who it's for is shown here but can't be changed. Click Save details to apply.
6b. Tables
The Primary table determines what each report row represents. Use Add a joined table and Add table to bring in related fields from other tables. The primary table can't be changed while the report has joined tables; remove them first.

6c. Fields
Check fields in the Available fields list (search or filter by table) to add them to Report fields. Drag report fields to reorder the output, and use the per-field toggles for Show on report, Allow editing, and Reference field. Date and lookup fields offer extra Date options and Lookup fields.

6d. Filter
Choose whether rows must match ALL or ANY of the conditions, then click + Condition to pick a field, operator, and value. Click + Group to nest groups that mix ALL and ANY. Click Apply filter to save, or Clear filter to remove it. The resulting Saved WHERE clause is shown below. Add fields first — a report filters on the columns it outputs.

6e. Sort
Select a field from Add a sort field and click Add sort. Set each sort to ascending (A → Z) or descending, and drag rows to change sort priority. With no sort, rows return in the database's natural order.

6f. Sharing
Choose who else can see and run the report, and who receives it on its schedule. Use the Employees, Roles, and Security Groups tabs to + Add recipients; manage or remove them in the Shared with list.

6g. Schedule
Check Email this report on a schedule to auto-run and email the report, configure the schedule, and click Save schedule. Turning the schedule off doesn't hide the report — anyone it's shared with can still run it.

6h. SQL
The Generated SQL section shows the query built from the report's tables, fields, filter, and sort. It is read-only and regenerates automatically as the report changes.

6i. Previewing and Running the Report
Review the Live preview panel (first 200 rows) below any section, using its refresh icon to update it. Click Run in the header to run the full report. Use Copy to duplicate the report or Delete to remove it.
7. Quick Reference Summary
| Task | How to Complete It |
|---|---|
| Open the Reports list | Reports and Insights → Reports. |
| Add an Ad-Hoc report | Ad-Hoc tab → + Add Ad-Hoc Report → enter a name, choose Who it's for → Create report. |
| Add a Graphical report | Graphical tab → + Add graphical report → build the layout → Save. |
| Edit an Ad-Hoc report | Ad-Hoc tab → Design report (gear) icon on the report's row. |
| Edit a Graphical report | Graphical tab → Open the designer (pencil) icon on the report's row. |
| Add fields, filters, or sorting | Designer → Fields, Filter, or Sort section. |
| Share or schedule a report | Designer → Sharing or Schedule section. |
| View the report's SQL | Designer → SQL section (read-only). |