Overview
In this video, you will learn how to create reports within the Analysis application in TDNext.
Transcript
In this video, you will learn how to create a project report in the Analysis application. The Analysis application houses all report sources in the system and is only available to those with an Enterprise user license. When reporting on Projects, users can create project reports in both the Analysis and Project applications. However, the results that are returned in these reports vary depending on the user who is running the report and the access that user has. Within the Projects application, the only projects that will be displayed are those to which they're assigned as a resource. If the report is created in Analysis, then it will return all projects that belong to their account department. Go to the Navigation icon in the upper left and choose Analysis or go to the Analysis tab. At the top of the page, click plus New, Report. The page will display the report sources you have access to. Report sources identify the primary subject matter in that report. We are going to create a project report. As you're going through this process, feel free to pause the video to follow along and create your own report. In our example, we'll create a report to show us projects by type, but you can feel free to create your own report and not use our specific examples. First, we'll provide a name for our report. The name of the report is what will appear in the list of existing reports, and will also display if the report is added to a desktop. It's best to use a report name that is descriptive enough to suggest what the report is about. For our report, we'll call it Software Projects Summary. Optionally, provide a description of the report. Anyone with access to the report can see the description in the report details, so adding a description with context and other notes will be helpful to those running the report. We'll add our description, summary of software projects. The report includes default columns. We can remove the columns we're not interested in using the Remove button. And drag the three horizontal lines next to a field to change the order the columns appear in. We can also click on a dropdown menu for one of the columns to change the displayed value, or click Add to add additional columns. For our report, we'll include name, manager, percent complete, start, end, and status name. If you have any questions about what a specific column means, you can use the Help button at the top of the the page to get a definition of each of the fields. In the filters, we will set which projects will return when the report is run. We're interested in active projects sorted by type so we'll add filters to capture that information. Like the column section, we can reorder and change the filters available. First, we'll select Status Name. When a filter is selected, notice the operator will determine how it responds in relationship to the value. For our status value, we'll set the operator to is one of since we are looking for projects that match the value we will enter. We could also select is not one of to explicitly exclude values. Here, we'll select projects that are in the status of new or in process. To select multiple options, hold down the Control or Command key on your keyboard. We'll also add a filter for the type. For our type, we'll choose Software Project. It may be helpful to sort the projects based on when they were created so the more recent ones are at the top. To do this, we'll choose order by start and set the order to descending. We can change the number of rows that are returned in our report. The default is 500, which will be enough for this report. We'll leave this value alone. When creating your own report, if you anticipate the report returning a lot of values, you can set this to a higher number. Here, we can define a specific folder to put the report in. We happen to already have a folder called My Custom Reports so we'll choose that folder to add the report to. If you don't have a custom folder, you can click the plus icon to create one to add the report to. If this is a report you feel would be beneficial to share with others, you can do that here. Note that they cannot edit a report they do not own so there is no risk of yours being changed. However, if they would like to copy this report, they can do that and edit their own version of it. We'll set the visibility to everyone with this application. In this report, there's not any real value in incorporating a chart. If we wanted to add a chart, we could choose the chart type and choose what to display here. Since there is not a chart in this report, all uses of this report on a desktop will be formatted to show as a grid. If your report has a chart, you can choose Chart to have the chart, not the individual records, show on a desktop. Now that our report is set up, we can click Save and Run to see it in action. If we don't like the results and need to make any changes, we can just click Actions, Edit to return to the report builder. This report returns six results. The same report in the Project's application only returned three results because those are the projects that the user running the report is a resource on. Now you know how to create and edit a report in the Analysis application. You may find it helpful to explore and create more reports that will be helpful for you or your team.