CobbleStone Documentation Wiki Welcome Guest: 5/21/2024 12:49:36 AM
 
View for Version
 
 
Contract Insight Version:
select
Version Released On:
Friday, October 8, 2021
 
   
 
Search
 
 

search text
Search 
 
   
 
Navigation
 
 
 
   
View/Run This Ad-Hoc Report   
Page last modified on Tuesday, November 30, 2021 12:07 PM (by Adam Widmeier) (initially created on Wednesday, July 20, 2011 3:39 PM)
Assigned to: Ad-Hoc Report Wizard: Legacy Reports
  Generate Manual Print View
 
Page Content
 
 

Ad-Hoc Report Wizard: Viewing & Running

To view a list of all Ad-Hoc reports to which you have access, navigate to Reports/Searches > Ad-Hoc Reports/Searches > My Ad-Hoc Reports/Searches.


Notes:

  • Columns shown on the My Ad-Hoc Reports List screen are globally set.
  •  If more information is desired to be shown on the My Ad-Hoc Reports List screen, after creating the report, click Manage/Edit, edit the Report Name, and edit the report to include the desired additional information. Save any changes.

 




Ad-Hoc Reports List

Delete Column: Click this to delete the specified Ad-Hoc Report from Contract Insight. (can only be performed by an admin or the creator of the report)

View Report Column: This option executes the ad-hoc report and display the results in a new page.

Manage Report Column: This option opens the Ad-Hoc Report Wizard for managing the specified Ad-Hoc Report and can only be performed by an admin or the creator of the report.

Report Name Column: Specifies the name of the Ad-Hoc Report.

Emailer Is Active Column: Denotes if the Email Schedule is active and enabled for an Ad-Hoc Report.

Date Created Column: The date the Ad-Hoc Report was created.

Created by Column: The name of the user who created the Ad-Hoc Report.

Report ID Column: The system assigned ID of the Ad-Hoc Report.



In addition to the list of Ad-Hoc Reports, the side menu provides access to:

  • Create a new Ad-Hoc Report.
  • View the Legacy Custom Searches (custom searches from older versions of Contract Insight).

 




Running an Ad-Hoc Report

To run/execute an Ad-Hoc Report, click on View/Run for the Ad-Hoc Report desired. Contract Insight runs the selected Ad-Hoc Report and displays the results on a new page.

 


The results grid can be further sorted and filtered as needed using the header rows for each column/field. In addition, the page size can be customized to any desired number, depending on how many records you want displayed on the page at a time.

Additionally, the side menu provides further management of the executed Ad-Hoc Report.

 

 

The following actions can be taken:

1. Back to Report List: This options opens the list of Ad-Hoc Reports.

2. Edit Report This option opens the Ad-Hoc Report Wizard for managing this executed Ad-Hoc Report and can only be performed by an admin or the creator of the report.

3. Reset: This option refreshes the results of the report.

4. Export the Ad-Hoc Report results: Export Results to an Excel format.


Note: Best Practices recommend exporting Ad-Hoc report to Excel and then saving to a PDF format.


5. Chart Ad-Hoc Report results data: This option opens the chart data page to visually chart the results provided.

6. Chart This Data: Charting the results data will require the results to have at least one text-based field and one numeric based field.

 

 

To generate a visual chart, provide the following parameters:

1. Select field to group on

  • Select one of the text-based fields from the Ad-Hoc Report results.
  • Which field information on which to group the chart.

2. Select currency amount to chart

  • Select one of the number-based fields from the Ad-Hoc Report results.
  • This will decide the second part of the field information on which to group the chart (data plotting).

3. Select Chart Type

  • Specify what type of visual chart to generate.

4. Chart Orientation

  • Decide if the chart should be oriented vertically or horizontally.


One-Off Emailing of the Ad-Hoc Report

One-off emailing of reports generated in the Ad-Hoc Report Manager is most effectively accomplished as follows: 

1. Create desired Ad-Hoc report

2. Test the execution of the report to ensure the results are valid and meaningful and on target.

3. Run/Execute the desired Ad-Hoc Report.

4. Export Ad-Hoc Report results to Excel.

5. Add any desired additional formatting to the Excel extract.

6. Save the Excel file as a .xls or .xlsx file to your computer.

6. Attach saved Excel Report File to the desired email and send the email.

 
   
 
Related Wiki Video Tutorials
 
 
 
   
 
Files & Attachments
 
  
   
 
CobbleStone Software |  Contract Insight Wiki |  version: 17.1.1.171020
CobbleStone Software is developed in the U.S.A.