Pivot Tables
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 ...
Sending Output to a File
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
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 ...
Data Item Appearance
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 ...
Sending Output to a Web Browser
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 ...
Ask At Runtime Filters
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 ...
Creating a New Data Item
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
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 ...
Summary Requests
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 ...
Cross-Tab Requests
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 ...