Lots of ways to create QTD reports. Here's one. 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 … [Read more...]
Creating PDFs from FRx Reports
FRx to PDF—a couple of ways 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 … [Read more...]
How to Create Vertical Lines in FRx
Vertical lines offer improved legibility; in short, they just make reports look better. 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 … [Read more...]
How to use Hyphens in Place of Zeros in FRx
This is a cool tip that I picked up from one of my nonprofit FRx clients. 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 … [Read more...]
Specify a Worksheet Name when Linking FRx to Excel
Some syntax for pulling data from Excel into FRx 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 … [Read more...]