Visualizing Long Calculated Expressions in Report Writer

Granted, MVP Mark Polino hates Report Writer (RW), but even he will admit he loves a good RW nugget when he sees one.

Several times I’ve been asked “how do I visualize long Report Writer calculated field expressions?”. At simple glance, it would seem that the horizontal list box control is all we have to visualize the expression, which could be far too complicated to deal with when working with large computations or even when invoking Report Writer functions.

RW horizontal list box expression field

As it turns out, there’s a little known feature in this window that allows you to visualize long expressions. If you click on the “Calculated:” or “Conditional:” prompt – depending on the expression type – next to the horizontal list box, it will display the full calculated or conditional expression in the Calculated Expression window.

Calculated Expression window

It would be nice if we can get the zoom property for the prompt field and the zoom button set to true. This would display the classic blue hyperlink as it is now customary on Microsoft Dynamics GP windows where zoom buttons are prevalent.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.IntelligentPartnerships.com

Read More:
Visualizing Long Calculated Expressions in Report Writer

May 8, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 298

Choosing your calculation priority for totals and … – MSDN Blogs

Blog Home · Share this · RSS for comments · RSS for posts · Atom. Search Form. Search this blog. Search all blogs. Tag Cloud. building blocks · Consolidations · CU6 · currency translation · Dynamics AX · Dynamics GP …

Taken from:
Choosing your calculation priority for totals and … – MSDN Blogs

May 8, 2014 · April Olson · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 230

Message for the Day/Week/Month/Year: Look Up

David Meego - Click for blog homepageI came across this video (via Facebook, yeah feel the irony) by Gary Turk and had to post it.

I love computers and technology, but “social media” is anything but.

‘Look Up’ is a lesson taught to us through a love story, in a world where we continue to find ways to make it easier for us to connect with one another, but always results in us spending more time alone.

 

Look Up (Direct Link)

(Please visit the site to view this video)

 

Time to put away the screen and live life.

David

Excerpt from:
Message for the Day/Week/Month/Year: Look Up

May 5, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 267

Star Ways Day 2014: May the Fourth Be With You

David Meego - Click for blog homepageTo celebrate this special day in the intergalactic calendar, I though we could enjoy the latest from the Mos Eisley Cantina where they are holding auditions to join the band.

 

Star Wars Cantina Band Auditions (Direct Link)

(Please visit the site to view this video)

Featuring in order Chris Daughtry, Ben Folds, Liz Phair, Reggie Watts, Mark McGrath, Jordin Sparks, Rick Springfield, Weird Al, Lisa Loeb, and MC Chris. 

 

Click on the image below to go to the Star Wars Day page on StarWars.com.

 

For more fun check out the May the 4th Be with You Tube playlist.

Enjoy

David

Originally posted here:
Star Ways Day 2014: May the Fourth Be With You

May 4, 2014 · David Musgrave · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 291

How to tell what update of Management Reporter you … – MSDN Blogs

Search all blogs. Tag Cloud. building blocks · Consolidations · CU6 · currency translation · Dynamics AX · Dynamics GP · Dynamics NAV · Dynamics SL · Forecaster · formatting · how to · learning · Management Reporter 2012 …

See the article here:
How to tell what update of Management Reporter you … – MSDN Blogs

May 2, 2014 · Jill Carter · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 269

KB Article 878449 Capture Login script gets a much needed rehaul

We live by it, we die by it. KB article 878449, How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server (KB 878449), is perhaps one of the most visited articles in the Microsoft Dynamics GP world, especially around upgrades. The article contains a script that, under normal circumstances, retrieves all the security principals and encrypted passwords on an existing Microsoft SQL Server. The result is a T-SQL script that allows you to restore those security principals on another Microsoft SQL Server.

Months aback I had seen numerous posts on the partner forum and the Microsoft Dynamics GP community where folks expressed having issues with the Capture Logins script on SQL Server 2012. Now David Musgrave over at the Developing for Dynamics GP blog has a definitive and answer and a solution to the problem and explains in great detail the issue experienced by many in his article Capture Logins Script from KB 878449 generates Invalid object name error.

Don’t miss out on this article.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.IntelligentPartnerships.com

Read the original post:
KB Article 878449 Capture Login script gets a much needed rehaul

May 2, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,041

Wennsoft Compatibility with GP 2013 R2

This is true as of May 1, 2014

WennSoft Signature Non-Compatibility Notice: 

Microsoft Dynamics GP 2013 R2 and Microsoft SQL Server 2014

Microsoft has announced the following new releases:

· Microsoft Dynamics GP 2013 R2 – coming in May 2014

· SQL Server 2014 – available since April 1, 2014

o GP 2013 R2 will be compatible with SQL 2014 at release in May

o GP 2010 will not be made compatible with SQL Server 2014

WennSoft Signature is NOT compatible with GP 2013 R2 or SQL Server 2014 at this time.  Please do not download the above new versions from Microsoft until we announce compatibility with our current release, Signature 2013.  Please note that compatibility with GP 2013 R2 and SQL Server 2014 will not be tested against earlier releases of Signature.  

View article:
Wennsoft Compatibility with GP 2013 R2

May 1, 2014 · Jivtesh Singh · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 383