FRxBuzz

Learn Management Reporter Faster

  • Home
  • Management Reporter
  • FRx
  • Courses
  • About
  • Contact
You are here: Home / FRx / Life’s Too Short to do Balance Sheets in Crystal

Life’s Too Short to do Balance Sheets in Crystal

June 16, 2007 By Jan Lenoir Harrigan CPA Leave a Comment

Thanks to my good friend George McMann for the title!

That just about sums it up. Lots of people, when they’re implementing a new GL, are confused about why there are TWO reportwriters, often Crystal Reports and FRx. Why two?

FRx is a specialized tool used for financial reporting. Crystal is a reportwriter used for Agings and Vendor Lists and the like. Crystal requires knowledge of the underlying accounting database: the tables, field names, and how they’re used (posted or not, released or not, etc.). FRx does not: it’s already done all the table linking for you.

Look at it this way: there’s a nail in the wall and you want to get it out. You could use a screwdriver and it would eventually work. But the best tool is really the claw on the back of the hammer.

Same with FRx: it’s the claw. It’s a much better tool for financial reporting than Crystal. Alternatively, you wouldn’t want to try an Aging with FRx (actually it can’t be done). So there you have it. You could probably do a balance sheet in Crystal, but life’s too short!

Filed Under: FRx Tagged With: Crystal Reports, Report Design

Leave a Reply

Your email address will not be published. Required fields are marked *

"I'll teach you the simplest & fastest way to use M-R and still wind up with accurate reports."

Search—try this 1st!

View Cart

View Cart

About

Hey! I'm a CPA and I specialize in Management Reporter and FRx. [Sometimes with a side of snark.] I've been doing this for 22 years (yikes). But when I'm not working I can be found reveling in live music & pizza trailers at home in Austin Texas! —Jan Lenoir Harrigan More

Learn Management Reporter

Why fight with Microsoft's manual? Life is too short as it is.

My first manual—4 foundation reports:
covers-i-2d
My second manual—12 more reports:
covers-ii-2d
My third (and hopefully last) manual—cashflow:
covers-iii-2d

Connect

  • Facebook
  • LinkedIn
  • RSS
  • Twitter

Subscribe by Email

Don't miss a trick—subscribe.

All Hat, No Cattle?

Watch out—a few unscrupulous consultants are lifting copyrighted original content from several sites, this one included, and passing it off as their own. I'm hacked off and I don't mind naming names. Bottom line—be very careful about whom you hire!

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
—Red Adair

Who I Work With

I work with zillions of companies who run Dynamics GP, AX and SL.

And lots of other consultants.

So I work with accountants who need accurate financials to help close the books. Not to mention present to the Board.

I don't sell or install MR. [How smart am I?]

FRx is Toast

FRx is toast—and I hope you're getting rid of it soon—but just in case someone still needs to learn it:

  • FRx in 8 Hours—Introduction 
  • FRx in 8 Hours—Intermediate

BTW, if you're on Dynamics, you can migrate to MR, but you should know there are other options. Choose what's best for you.

New to MR?

Here are 3 essentials to know before you start.

Background—back in the day, FRx was a famous midmarket report writer from a small agile company in Colorado. Then it got acquired. [Sigh]

Now it's owned by Microsoft. They rewrote it and rebranded it Management Reporter.

The two are very much alike and much of the FRx content here also applies to MR.

Copyright © 2025 Jan Lenoir Harrigan CPA · Protected by Copyscape Plagiarism Checker · Do Not Copy