Labels
Foxfire! can generate standard labels for printing based on the standard layout of label sheets.
Summary Reports
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 ...
Summary Report vs Detail Reports
Often, we hear about clients trying to figure out why Foxfire! creates an SQL statement with GROUP statements and why it doesn’t. The distinction can be subtle when looking at the ...
Organize Your Reports
The Request Manager holds all of your reports in one place, making them easy to find and manage. With security, reports can be run by other users or kept away from ...
Layout Your Report
Foxfire! uses pre-designed templates to lay out reports out for you. Need a corporate report? Use a public-facing template with a logo. Summarizing information? Use a Summary report template. Once selected, ...
Crosstabs
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 ...
What’s New In Foxfire! 8
- Design and preview modes are combined giving constant visual feedback while you work. Drag data items onto the report, change their position, and appearance properties, add totals, and more. You’ll always know what you’ll get when you click Run
- The Workbench (formerly, the Request Editor) can be relocated wherever you want for maximum viewing
- Each item’s appearance can be customized for a single report – column headings, fonts, display widths, automatic summaries, and more
- New custom data items can be created on the fly, as you design the report
- Searching and filtering are simpler, yet more powerful with more options. You have more filter options too, including common names for date ranges like “this quarter”, “last year”, etc. Many were once reserved for geeks only, and now be used by everyone
- Sorting and grouping are easier and take fewer steps, and there are more header and footer options (e.g. appearance options like custom formatting, separator-lines, indentation, etc., and summary options like changing or suppressing automatic totals, etc.)
- Separate-and-send™ report pages by email. When a data group changes, you can send the current pages to a file (PDF, XLS, etc.) and email it to a email address unique to that group
- Total item counts and unique-value counts (“Distinct Count”) are available in Summary Requests
- Auto page formatting adjusts page parameters automatically if the width is exceeded. You may override these adjustments if you wish
- New output formats (PDF, doc, rtf, formatted xls, four kinds of XML, and email).
- Report definitions can be exported and exchanged with others via email or other means
- Batches let you run and schedule multi-step jobs.