Boost Productivity Instantly

The Report Execution Log is a relatively new report added with the 4.8.03 release. This report can be helpful to know who is running what reports, which reports are being used, how often the reports are run, and other useful information for administrators. To access the report, locate the Administration menu from any application. Under the Administration menu, locate the Information Submenu and then the Report Execution Log. Don't forget that if you can't find the report, either you do not have access to it, or the location of the report may have been moved. Once you locate the report, select your filters and review the results. NOTE: If you do not see the Administration Menu or the Report Execution log, you may not have been granted access to this report.

Have you ever wanted to move a column on a grid but didn't know how to? This Tuesday Training Tip is meant for you! To temporarily move a column, use your mouse to click and hold a column. This will grab the column and allow you to move it around on your report. You should see a blue arrow move right above the column heading as you move your mouse. This shows you where the column will drop when you release the mouse click. Note that this will only reorder the column for your existing session in FAST. If you want to make the change permanent, you will need to pin the report. If you would rather a more permanent solution that applies to all users, and you have the correct access permissions, you can change the order of columns from the grid Administration page.

Welcome to this edition of Tuesday Tips! Occasionally, you may find yourself needing to revisit the most recent report you executed or even one from 20 minutes ago. Instead of re-executing the report, there are two efficient ways to navigate back quickly. If you wish to view the most recent report, click the left arrow (←) located in the FAST information bar (not your browser's back button). Hovering over the icon will reveal the last report you ran, and by clicking the ←, FAST will promptly direct you to that specific report. For those moments when you want to return to a report from an earlier part of your session, simply hover over the clock symbol (🕐) in the FAST information bar. This action will display a list of reports you've run during your session. Choose the desired report, select it, and you'll be taken directly back to that report.

Welcome to this Tuesday's Training Tip. Did you know that anytime you want to execute a report from either the Filter or Advanced Options tab, you can quickly execute the report by pressing ctrl-enter? No more scrolling to find the green execute button on a report with a lot of filters. It is the fastest way to execute a report without having to touch your mouse! Are you using a Mac to access FAST? Either control-enter or command-enter will work to execute your report.

In this week's Tuesday Training Tip, discover a quick method for refining your report post-execution. Simply right-click on any field within your report to reveal a pop-up box. From there, you can effortlessly apply a custom filter tailored to the value within that particular field. Check out the brief video tutorial for a step-by-step demonstration!

A cross tab allows you to display a report using a column value in a grid as the column header. This allows you to analyze the relationship of that value with one or more other columns in the report. For example, you want to see a count of the number of courses offered in an academic year within a specific group of departments. You may even want to know what instructors are assigned to those courses and how many courses each instructor is assigned to. You can create a cross tab to analyze this data. Although this example utilizes Student reporting, cross tabs can be used throughout all of the FAST applications. First, run your report using your selected filters. Open the Advanced Options tab. Expand the Cross Tab section. Select the value in the report that you want to become your column headings. The column headings in my example will be the course subject. Next, determine what you are going to populate the rows with and how you want to calculate that row. I have selected to populate the column heading (Department) with the CRN (Course Number). Next, I'll decide how I want to calculate the field. I am going to count the courses within that subject. When I execute the report, the new report will display how many courses exist within the given subject. I can add additional rows to the report by selecting additional rows to be displayed within the Grid Options section. Once you are satisfied with your cross tab, make sure you pin the result so that you can use it again without recreating the crosstab.

In this Tuesday Training Tip, learn how to change the header text on a column. If you have administrative access, you can change the column heading on a report. Access the Administration tab of the reporting page. Locate and expand the Data Grid Columns section. Navigate to the column row and select the header text. From here you can change the name of the column. Once you save your changes, all users will now see the new column header text.

Are there any columns on a report that are not currently visible? In this Tuesday Training Tip, you'll discover how to add and hide these columns from a report. After running any report, click on 'select report columns' in the grid toolbar. A list of all available columns will appear. By selecting the checkbox next to the column name, you can include it in the report. Conversely, unchecking the box will remove the column from the report. Keep in mind that only columns marked as 'on' or 'de-selected' within the Administration settings can be toggled on and off. These are not permanent changes. Use the administration page to make permanent changes to the column settings.

When you're training new employees on a report in FAST, you can save a lot of time by adding tooltips to a column. A tooltip allows you to add text that appears as a pop-up when users hover their cursor over the column title when running the report, which can help with additional explanation beyond the column title. To add a tooltip, access the Administration tab of a report. Expand the Data Grid Columns section. Navigate to the column row and scroll to the right to find the tooltip. Enter the text you would like to display when a user hovers over the column. Save the report and execute it to confirm the changes. Be aware you are limited to 500 characters and only those with appropriate security access can add tooltips.

In this Tuesday Training Trip, you'll learn that not all filters may be displayed on a report. There could be inactive filters that you can add to a report! If you have the appropriate access, navigate to the Administration Tab of a report. Scroll down to the Filter Options section. Expand that section. You'll see all the filters that are currently active. If you click on the Add New Filter Option button, you will open a pop-up box and select additional fields that can be added as a filter. Note that only one can be selected at a time. Choose your filter from one of the available fields. Complete the filter options to build your filter. After you save, make sure that you reload the report so that the new filter option is activated.