One of the first steps in replacing FRx is understanding what your existing FRx reports are. And it’s really helpful to see them in a list so you don’t have to keep scrolling through the catalog.
Here’s how to create a list in Excel without cracking into the Access database (disappointing, I know, for you IT enthusiasts):
- In any FRx catalog, go to File > Print Catalog.
- In the resulting screen, highlight all reports with the mouse. (Don’t just click Select All.)
- Copy with Ctrl-C (right-click to Copy doesn’t work here).
- Paste into Excel (I use Ctrl-V).
- Format to your liking and save.
Once it’s in Excel, you can sort by company, by catalog ID, or by catalog description.
Now you can try to figure out which ones you use, and which ones you don’t. But I’ll leave ‘cleaning house’ to another day (sort of like I do at home). Cheers—Jan
{ 6 comments }