This is the fourth in a series of posts on simplifying FRx. Happy New Year! I've been at home cleaning and organizing and straightening while putting away all the holiday decorations. Getting ready for the new year. All this inspired today's post—how to clean and … [Read more...]
Problems Exporting FRx to Excel?
Lately I've seen FRx having a problem exporting to Excel. Ugly "can't locate file" errors and the report won't export. The problem may lie with the latest version, 6.7.9111. I have a workaround for you though: take the spaces out of the filename output in the output options. … [Read more...]
How to Export an FRx Spec Set
Export a group of FRx reports for backup or for import. Spec Sets in FRx contain a particular grouping of rows, columns, trees, and catalogs. There's one for the demo reports that are built into FRx. There's at least one for your company unless of course you have a brand new … [Read more...]
Color Coded Budget Variances Using FRx and Excel
Using conditional formatting in Excel to fool with FRx budget variances Well, here's where we're going to go today: 'stoplights', or red color coding, for unfavorable budget variances. You do know we're going to Excel for this, right? Here's the initial budget variance report … [Read more...]