Pivot Tables

29 Dec, 2018
Lesson Goals:  You are going to create a Request that sends output to a Microsoft Excel pivot table. To create an Excel pivot table: From the Request Manager, create a new ...
Sometimes you may want to direct your output to a file on your disk. You can then use that file to work with your output outside of Foxfire!. Lesson Goals: You are ...

Excel Charts

29 Dec, 2018
You can send Request output directly to Microsoft Excel as a spreadsheet, chart or pivot table. Lesson Goals: You are going to create a Request whose output is an Excel chart. When ...
Your developer or administrator will define your data items when they create the Data Dictionary for Foxfire!. As a designer, you can change the output appearance for an item. When you ...
Lesson Goals: You will learn how to change a Request so that the output can be browsed on a Web Page. Note: This exercise only covers the steps needed to add HTML notations ...
When you run a report, it is common for you to need the report with slight variations in the data selected. This is accomplished through filtering. One time you might need ...
You can get even more out of Foxfire! by creating data items when existing data items don’t retrieve the information you need. For example, suppose you wanted to create a data ...

Top N Values

29 Dec, 2018
There is another filter option you can use when want to report only the highest, first, or top ‘N’ values from each group. This is called Top N and you find ...
You may sometimes want a Request that just outputs summary information, not detail. That is called a Summary Request. There are two types of columns in a Summary Request: group information ...
A Cross-Tab analyzes a relationship between two Data Items and creates a table which displays row and column headings based on the two Data Items selected. The body of the table ...