FRxBuzz

Learn Management Reporter Faster

  • Home
  • Management Reporter
  • FRx
  • Courses
  • About
  • Contact
You are here: Home / FRx / How to Deal with the Lack of Column Breaks in FRx

How to Deal with the Lack of Column Breaks in FRx

February 23, 2011 By Jan Lenoir Harrigan CPA Leave a Comment

One of FRx’s inherent limitations is that when you have too many columns to fit on a page, FRx truncates and just doesn’t print the overflow. There are no column breaks!

What to do? Well, here are two options:

  • Use 2 (or more) report catalogs. The first is for page 1, the second is for page 2, etc. You can chain them, but better make sure they run for the same date. And you better build in even more accuracy checks than usual.
  • Excel. Either from the catalog or from the drilldown viewer, export to formatted excel. You’ll get all your columns and then you can manage printing from inside excel.

Personally? I like option 2 Excel. Simple, practical, easy, fast. What’s not to love?

By the way, you do have some control over what comes over to Excel. Worksheet options in the catalog and drilldown viewer allow you to uncheck things like ‘print headings’ and ‘print underscore rows’. Those underscores always look awful in Excel. Turn ’em off if you want, and put Excel’s format painter to good use. 

FWIW, there are column breaks built into Management Reporter.

Filed Under: FRx

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