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...]
Executive Reporting: Using Excel Charts with FRx
I just finished a couple of FRx charting engagements and thought I'd share the technique I used. A quick overview: the FRx report exports to Excel, then a chart in a separate workbook points to the FRx export for its data source. The chart reads the refreshed data when the … [Read more...]
Using Excel During FRx Report Creation
6 Ways to use Excel to create better FRx reports Most of us think about using Excel for either pulling statistics into a report, or for exporting a report for further manipulation. But there's more. Here's what I do to use Excel's powerful capabilities while creating an FRx … [Read more...]
Recreating your Excel Financials in FRx
Lots of things to consider if you're recreating your Excel financials in FRx. Here's what makes the short list. As an aside, a lot of reports are in Excel because they contain statistical information that's not in the GL. Can you book this information to the GL? It will make … [Read more...]
Top 12 FRx Tricks
See 12 of the top FRx tips, trick, techniques and shortcuts I've been consulting with FRx since 1995, and these are a few of the top tips and tricks I've run across over the years. … [Read more...]