Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Amy Deisch]

Hello all,

In MR, I have my entire Row definition and entire Column definition formatted as Times New Roman 12pt.  However when I run the report, I get a variety of sizes and fonts.  I have even trying copying the row information into a new Row definition, and it resulted in even more formatting problems.

Currently I fix the formatting in Excel.  This isn’t time consuming, but it drives me crazy!  How do I get MR to print the correct font and size?

Thank you!

——————————
Amy Deisch
Mariner Holdings/Tortoise Capital Advisors
Leawood KS
——————————

[Noah Moseley]

Hi Amy.

Maybe hidden font settings are getting copied from the old definitions to the new definitions. When you copy/paste a Row Definition to a new Row Definition, try using Notepad as a middle copy/paste location. Copy all of columns A through J to Notepad; copy everything in Notepad; paste from Notepad to a new Row Definition.

Do you have this problem with a brand new report with a new row definition and a new column definition?

Let us know if any of this helps.

——————————
Noah Moseley, Senior Consultant at the MSX Group
Noah.Moseley@MSXGroup.com
Email me if you need training or consulting services for Management Reporter, Forecaster or FRx.

Also, see our new Prospero offering for GP – Your new replacement for Management Reporter and Forecaster – Financial Reporting and Budgeting, all in one application.
http://www.msxgroup.com/ProsperoGP

Our Management Reporter User Forum is scheduled for March: http://www.msxgroup.com/user-forums
————————————————————————-

[Amy Deisch]

Hi Noah,

This partially solved the problem, but my column definition will not let me specify the wanted formatting.  When I select Times New Roman, the font size changes to 8 pt.  When I change the size back to 12 pt, the font changes to Tahoma.  Very strange, but the loop continues.  No matter how many times I change one setting, the other reverts.

I’ve also tried the Default font (which is set to Times 12pt), but with no luck.

Any thoughts?

——————————
Amy Deisch
Mariner Holdings/Tortoise Capital Advisors
Leawood KS
————————————————————————-

[Noah Moseley]

Try copying the Column Definition the same way you copied the Row Definition. Copy to Notepad and then copy from Notepad to a new Column Definition.

——————————
Noah Moseley, Senior Consultant at the MSX Group
Noah.Moseley@MSXGroup.com
Email me if you need training or consulting services for Management Reporter, Forecaster or FRx.

Also, see our new Prospero offering for GP – Your new replacement for Management Reporter and Forecaster – Financial Reporting and Budgeting, all in one application.
http://www.msxgroup.com/ProsperoGP
————————————————————————-

[Amy Deisch]

I did copy the column definition the same way, and the new definition is where I am having this problem.

——————————
Amy Deisch
Mariner Holdings/Tortoise Capital Advisors
Leawood KS
————————————————————————-

[Beat Bucher]

Amy,

Somehow you managed to post your question twice in the forum…

See my other reply : https://www.gpug.com/communities/community-home/digestviewer/viewthread?MessageKey=9ae3105a-7287-4d76-803a-d3a5f2ecc44c&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=digestviewer&UserKey=3bc2b4b6-d2a3-484b-aed3-5f360e4de662&sKey=CF43D53401BA4FFEAFB8#bm1

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
————————————————————————-

[Noah Moseley]

I would start a new column and manually add a DESC column and an FD column, run it. see if there are any problems, then go back and add the next column until you have all the columns added.

——————————
Noah Moseley, Senior Consultant at the MSX Group
Noah.Moseley@MSXGroup.com
Email me if you need training or consulting services for Management Reporter, Forecaster or FRx.
Management Reporter User Forum is March 21, 2017.
http://www.msxgroup.com/user-forums

Also, see our new Prospero offering for GP – Your new replacement for Management Reporter and Forecaster – Financial Reporting and Budgeting, all in one application.
http://www.msxgroup.com/ProsperoGP
————————————————————————-

[Rob Klaproth]

I’ve seen this before and it’s a pain to fix.  Creating a new column definition might help but you may not be able to copy and paste as that will reintroduce the problem. 

You may have to update to rollup 14 if you are on SQL 2008/gp2010 or rollup 15 if you are on SQL 2012 or higher  and GP 2013 or higher.  Many of the formatting issues were fixed in rollup 14 and even more in 15.  

Sent from my iPhone

——Original Message——

I would start a new column and manually add a DESC column and an FD column, run it. see if there are any problems, then go back and add the next column until you have all the columns added.

——————————
Noah Moseley, Senior Consultant at the MSX Group
Noah.Moseley@MSXGroup.com
Email me if you need training or consulting services for Management Reporter, Forecaster or FRx.
Management Reporter User Forum is March 21, 2017.
http://www.msxgroup.com/user-forums

Also, see our new Prospero offering for GP – Your new replacement for Management Reporter and Forecaster – Financial Reporting and Budgeting, all in one application.
http://www.msxgroup.com/ProsperoGP
——————————

[Amy Deisch]

Thanks everyone for your suggestions.  I was able to jump back into this today, and I discovered a work around.  I tried a multitude of copy/paste techniques, but each caused more problems than it solved.  Instead, I inserted several lines and then retyped the rows that would not format correctly.  I then deleted the problems rows.  Fortunately this only affected a dozen lines, so this fix wasn’t time consuming.  All looks good now.

Thanks!

——————————
Amy Deisch
Mariner Holdings/Tortoise Capital Advisors
Leawood KS
————————————————————————-