Welcome to create a simple report. In this video, you will learn how to create a simple report using an existing filter, view and grouping. Reports are the windows into your data. With customer reports you’ll be able to answer questions like, how are my projects progressing? Which tasks are completed? Which tasks are in trouble? And are we staying within budget? Start by taking a look at this project list report on the project’s page. The filter is set to my projects. It’s using the standard view and it’s grouped by completion date by month. You can easily change this report by changing the filter, view or grouping. You can even move the columns around or sort on a particular column. But these changes are temporary and selecting the filter, view and grouping you want every time you need to see the information just isn’t practical. That’s an advantage of creating a custom report. Just select the report to see the information you want. Get started with custom report building by creating a project report that uses existing filters, views, and groupings. Namely the My Projects Filter, the standard view and the completion date by month grouping. Start by clicking the main menu icon and choosing reports. The reports page is where you can access all sorts of customer reports. We’ll get into those later but right now you just want to create a simple custom report. Click new report. Notice that you have many report choices. These are Workfront object types. The five most common object types are listed above the line. Under the line is an alphabetized list of all other project types for which you can create reports. You need to choose the object type that corresponds with the type of report you want to create. So for example, if the report is meant to look at project information, you want to pick a project report. If you pick a user report you won’t be able to see the project information you want. You want to pick a project report so choose project. Workfront recommends starting out by naming the report. This will help you focus on what you’re building. To give the report a name, click on report settings and put the name in report title. The filter and the grouping usually do a good job of suggesting a report title. You’re creating a simple project report using the My Projects Filter and the completion date by month grouping. So this report is My Projects by Due Date. Use the description to provide more details about the report. You can explain that my projects means current projects where the logged in user is on the project team and due date means it’s grouping by planned completion date by month. That’s all you need to do in the report settings for now so click done. The columns or view tab looks very much like the customized view screen when you’re making a new view. In the Report Builder window, you have the option to apply an existing view which is what you want to do for this report. The list of views contains all your project views including the ones you’ve created. Now that you’ve selected the standard view, you can make a few other changes if you want. Move the columns around with a drag and drop.
You can sort on a particular column. You can sort on up to three columns, so indicate the order of the sorts. Don’t forget to select if the sort should be ascending or descending. Next, go to groupings tab. Again, you can select an existing grouping completion date by month. Nothing more is needed here, so finally go to filters.
Select my projects from apply an existing filter. Now you’re done, click save and close. Every time you open a report, you’ll see the same filter, view and grouping. They’re listed here as report defaults. Anyone viewing the report can change them but this is temporary. The next time you choose the report, it will run the way that it was written. Reports live in the reports area. The reports you create are in my reports. When someone shares a report with you, it’s in the Shared With Me section. And to see all reports in the system including built-in reports, click here. If there’s a specific report that you’re using a lot, you might want to pin it, or make it a favorite. Now you know how to create a simple customer report from existing filters, views, and groupings. This will save you the trouble of having to change these elements whenever you want to view your projects this way. Pinning it will make it only a click away. Now pause the video and do the activity that you see here. Step by step instructions are next. -
You want to track all of your active tasks in a single report. Create a Task report named “My Current Tasks” using the following:
