Open Forum

Expand all | Collapse all

Formatting Fill Columns

  • 1.  Formatting Fill Columns

    Posted 15 days ago
    Hello All,

    I am fairly new to Management Reporter so please forgive anything I am missing in this post, but I am trying to create a set of financials.  Each financial report will compare 3 locations and multiple entities per location side by side.  I formatted the reports replicating the format we typically use in Excel, but I am having trouble with the fill columns.  I would like to have a blank fill column between each location, but I the formatting I have also formats the fill columns.  Is there a way to have the formatting skip over a fill column?

    In this example, you can see the fill column between location 1 & location 2 has " - " because I have the description columns underlined, and then the blue formatting extends through the fill column as well.



    Ideally I would like to eliminate the " - " and have the blue formatting stop at the location 1 total column and restart with entity 1 of location 2.  The same goes for the box around the blue lines.  I have manually edited the formatting in the example below:


    ------------------------------
    Evan Ross
    CCI
    Chicago IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Formatting Fill Columns

    GPUG ALL STAR
    Posted 15 days ago
    Edited by Beat Bucher 14 days ago
    Hi Evan,
    I'm no expert in building reports in MR2012, but if not mistaken, there is a formula called "NP" for No Print when a cell contains zero value.. 
    Please check the documentation about MR.. that should be described in there.

    Edit: sorry, completely missunderstood the question :-(
    ignore my answer :-)

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Formatting Fill Columns

    GOLD CONTRIBUTOR
    Posted 15 days ago
    Evan,

    There is a "Fill" type you can use in the Column Formats and this should work.  You can take the default and in the column width you can set the amount of spaces for this column.
    Another option would be to set the amount of spaces to leave blank before printing the first column for Entity 1/Location 2 and that would also give you that spacing.
    The issue with the line formatting is a bit tricky as the format in the row extends across all columns.  You will probably need to do a couple of line rows and reference both to the total row so it shows in the logical location and then use the column restriction to limit what columns that line should print in.

    ------------------------------
    David Callery
    Consultant
    Coe & Company, LLC
    Jefferson LA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Formatting Fill Columns

    TOP CONTRIBUTOR
    Posted 14 days ago
    There is the "Extra Spaces Before Column" you may use (instead of the FILL column type.  The Report Definition default is 2 spaces between each column and then in the Column Definition is where you may add extra spaces.  See screen shots below.

    Hope to see everyone at Summit conference virtually where MSX Group will be presenting several tips and tricks sessions on Management Reporter and teaching pre-conference Academy classes.  Happy reporting and budgeting and have a nice day/weekend ALL!!!




    ------------------------------
    Derek Krebs
    Sr Consultant, MSX Group
    PROSPERO by MSX Group, www.msxgroup.com
    Derek.Krebs@msxgroup.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Formatting Fill Columns

    Posted 13 days ago
    Hi Derek,

    That seems to work when viewing the report with the Management Reporter Viewer, but then once I export to Excel, the extra spaces before columns does not carry over.  Is it possible to include the extra spaces before column in an export into Excel?

    Evan

    ------------------------------
    Evan Ross
    CCI
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Formatting Fill Columns

    Posted 13 days ago
    Hi David,

    I already have a fill column, but the formatting extends through the fill column.  Is there a setting you have to check to have the format stop before the fill column and start again after it?

    Evan

    ------------------------------
    Evan Ross
    CCI
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role