Dec.
1
2006
This tip is a different from the usual report design tips and tricks.
It’s all about avoiding problems.
The SysData directory contains the reports and components. Back it up. While this won’t exactly prevent corruption, it does prevent disaster. Don’t forget offsite storage. [click to continue…]
{ 1 comment }
Dec.
1
2006
FRx does not natively support QTD reporting, so these reports can be a bit difficult if you don’t already know how. The trick is to create at least four column layouts for one report, then use effective dates in the catalog to force FRx to automatically choose the correct column based on the report date.
There are many ways to create quarter to date reports. This is just one. Here’s the example: [click to continue…]
{ 0 comments }
Dec.
1
2006
FRx doesn’t really support creating PDFs other than through their WebPort product (purchased through your GL vendor).
However, here are a couple of ways you can generate a PDF file from a drilldown viewer file. You’ll need a PDF printer driver installed. [click to continue…]
{ 3 comments }
Dec.
1
2006
Here’s a short example:
Here’s an overview of how you achieve this look: your column will contain two Fill columns with widths of 1. Your row will reference these columns with Box Begin and Box Complete format codes. Here’s how.
{ 5 comments }
Dec.
1
2006
They wanted to see a hyphen instead of a zero, sort of like the Accounting format in Excel. Here’s how. Go to the Company menu, International Formats, and pull up your currency, in this case USD for US Dollars. This is what it probably looks like: [click to continue…]
{ 7 comments }
This is the syntax for specifying a specific worksheet (tab) name in an Excel workbook:
c:\frxtrain\io_data\[tutorial.xls]corp
But note that you’ll probably use universal pathing in which the server name is specified:
\\servernameyadayada in place of the local c drive!
{ 0 comments }
Dec.
1
2006
RevPAR (revenue per available room), Occupancy Rates, Census, Revenue per Employee, RPU (revenue per user), Utilization, Realization Rate, Per Client Profitability…these are just a few of the many performance metrics that can be measured using FRx. Every industry has its own measures of performance, and all are handled using FRx calculations.
The calculations depend on whether the statistical data lives in the GL or in Excel. For the purposes of this explanation, we’ll assume it is maintained in Excel. (For what it’s worth, I much prefer to see it in the GL, but that’s another story.)
So here’s how to pull that statistic in from Excel. There are two different ways to use Excel with FRx, and we’ll focus on the one that’s most commonly used with a single statistic, the Combined Method. [click to continue…]
{ 14 comments }
