Body
Issue/Question
- I would like to have a report created in TMA
- Could I get a TMA report
- Report for student life
- Is it possible to give the C&P Project Managers access to the following report in TMA
- Create report of who is assigned to what security groups in TMA
- TMA Report on Projects
- Modify or Add Report to TMA
Environment
Resolution
Note: Need to have had TMA Report Writer Training and have proper access. If no access or training contact the Service Desk
Add New Report:
- Logon to TMA
- Go to Reports > Report Writer
- Click Add on blue bar at top
- On Identity tab
- Type Report Name
- Select Report Form from dropdown
- Leave Access by Repair Center blank
- Click User Access from dropdown
- Click Sub Report if it is a Sub Report​​
- Type Description
- Select Report Category from dropdown
- Leave Window Toolbar blank
Note: Field is used to list the report on the Reports Segment of the Navigation Panel when the designated window is open. (Not currently used)
- Leave Filter By Current Record blank
Note: If you mark this check box, the report generated will display a report for the record that is visible when you click that report on the Navigation Panel. (Not Currently used)
- Identity tab
- Click Add Criteria if needed
- Select the Field, Condition, Value, if it will prompt from a dropdown and if it is required
- Repeat the Add Criteria for all that is needed
- Select the Criteria Grouping if needed
- Click Add Text Field or Add Math Field under Calculated Fields and populate accordingly if needed
- Click Options tab
- Click Add Group under Field Grouping populate approriately
- Click Add Sorting Field under Field Sort populate approriately
- Click Add Summary under Summaries populate approriately
- Click Layout tab
- Click Properties and fill out Page Format, Report Orientation and anything else that is needed
- Select portrait or landscape
- Select type of report Table or List
- Put fields in order wanted on both the Header and Data sub tabs if using a Table
- Click Save
- For more detail information for adding additional fields, formatting, sub-reports etc. go to Report Writer
Update Report:
- Logon to TMA
- Go to Reports > Report Writer
- Make changes to the contents of report if required
Note: Can refer to instructions above in Add New Report
- Click Save
Make Copy of Existing Delivered Report or Custom Report:
- Logon to TMA
- Go to Reports > Report Writer or Reports > Report Manager
- Highlight the report wanted to copy
- Click Copy Report button
Note: Existing report opens in the Report Writer window
- Give report a new name or just add USD to the beginning of the existing name
- Assign report Category
- Make changes to the contents of report if required
Note: Can refer to instructions above in Add New Report
- Go to Layout Tab
- Click Save
- For more detail information for adding additional fields, formatting, sub-reports etc. go to Report Writer
If the report needs scheduled click Requesting to Add or Update a Schedule on a TMA Report