Feb.

26

2013

Management Reporter—Got Day of the Week in your Title?

by Jan Harrigan CPA

Got the day of the week showing up in your financials? Here’s how to lose it.

Thursday looks strange, doesn’t it

wpid3737-media_1361820157806.png

I’ll show you how to get rid of it.

First I want to look at the header in the report definition

wpid3742-media_1361910142949.png

The @DateLong is the culprit. You might think that changing it to something different might be the way to go. That’s not a horrible guess, but there’s a better way.

The best answer is to change the “Long Date” settings in regional options on the server.

On the server, go fool with the Regional settings

wpid3738-media_1361820288584.png

Open the Control Panel, then go find the Regional settings. (Yours may not look exactly like this.)

wpid3739-media_1361820342984.png

On the Formats tab, take a look at the Long Date. The format (with the day of week) looks exactly like the date in the report header. I’m going to change that by clicking Customize this format.

Choose the Date tab in the Customize dialog

wpid3740-media_1361820401022.png

In the dropdown, switch the Long Date to MMMM dd, yyyy.

Now you should be good to go

wpid3741-media_1361820421029.png
Back in Management Reporter, when you regenerate the report, the date should look lots better.
Cheers—Jan

Be Sociable, Share!

    { 8 comments… read them below or add one }

    Jan Harrigan CPA February 28, 2013 at 11:48 am

    I received an email comment yesterday from Tracie who says “Thanks, Jan — I hate the way the reports show the day!! Can’t wait to fix this!”

    Cindi Todd March 14, 2013 at 1:25 pm

    Thanks, Jan. Microsoft certainly should have an option within MR to handle this, but I appreciate the work around. It looked so ridiculous that I’ve been hardcoding the date in each month (UGH!) since implementing MR in November.

    Jan Harrigan CPA March 14, 2013 at 5:19 pm

    Hardcoding? Oh you’re KILLING me!

    Will discuss with Microsoft next week at Convergence. I’ve received so many emails about this post; seems it struck a chord!

    Ann Love March 26, 2013 at 7:36 am

    We are using a terminal server environment and the regional settings have been changed. When I run the reports as an administrator on the server I see the correct dates but when a non-administrator runs the report they still see the day of the week. Any ideas for what security changes need to be made short of giving everyone administrator privileges?

    Jan Harrigan CPA March 26, 2013 at 7:42 am

    Try getting the other users to make the same change. I see this when I teach this in class…often multiple people have to change this.

    Jan Harrigan CPA March 26, 2013 at 7:43 am

    I did discuss this with Microsoft last week at convergence. Unfortunately, it’s here to stay.

    Katrina Fulton May 15, 2013 at 10:42 am

    Thank you SO much!

    Jan Harrigan CPA May 15, 2013 at 10:44 am

    My pleasure! I’ve had lots of great feedback on this one. Jan

    Leave a Comment

    { 2 trackbacks }

    Previous post:

    Next post: