Report Writer Tricks #1: Copy Formatting from an Existing Report for a New Company | WebSan Solutions Blog

WebSan Solutions offers Report Writer Tricks #1: Copy Formatting from an Existing Report for a New Company |

Easily mass assign “missing” reports back to the Microsoft Dynamics® GP report. | Dynamics University

Julie Jensen explains how to Easily mass assign “missing” reports back to the Microsoft Dynamics® GP report.

Report Writer Series: The End! - Blog - Kuntz Consulting

Kuntz Consulting wraps ups their Report Writer Series: The End!. Check out the post to make sure that you didn't miss anything.

Report Writer Series: Keys, Restrictions, Sorting, Grids - Blog - Kuntz Consulting

Kuntz consulting continues their Report Writer Series: Keys, Restrictions, Sorting, Grids

Report Writer Series: Custom Reports - Blog - Kuntz Consulting

Kuntz Consulting continues their Report Writer Series with Custom Reports. I suspect that it's a really small subset of consultants that has created a Report Writer report completely from scratch, not modifying an existing report.

Report Writing Series: Sections - Blog - Kuntz Consulting

Kuntz Consulting continues their Report Writing series with a look at Report Writing Series: Sections

Report Writer Series: Drawing Options Tips - Blog - Kuntz Consulting

From Kuntz Consulting comes a post on Report Writer: Drawing Options Tips

Getting data from ISV tables onto reports without needing to create alternate reports - Developing for Dynamics GP

David Musgrave explores Getting data from ISV tables onto reports without needing to create alternate reports

Weekly Dynamic: Extender and Report Writer

A client was recently using KB 935385 and KB 898983  to attached an Extender field to Report Writer. The KB’s are fine but the examples are unclear in a few places so I thought I would provide some screenshots for clarity.

In this case the user was  trying to add a short note field from the customer address to a SOP order. The key in this case was Customer Number and Address Code ID, so those items needed to be concatenated into a single key to link back to the Extender field.

The basic steps are:

1. Create and test the Extender field.
2. Create a calculated to combine the Extender key fields into a key.
3. Create a second calculated field to pass the key and return the extender data.
4. Add the second calculated field to the SOP order.

This is what steps 2 and 3 look like so you can see an example:

Calculated Field 1: Build the Key

Left Side

Right Side

Calculated Field 2: Use the Key to return data.

Keep in mind that if you put the calculated field in a hidden area of a SOP document, this field will be hidden too. So if you put this in the comments area but there aren’t any comments, this won’t show. If there is a comment, it will show.

“…you’ve got to ask yourself one question: Do I feel lucky? Well, do ya, punk?”

Steve Chapman goes all Dirty Harry on Report Writer with “…you’ve got to ask yourself one question: Do I feel lucky? Well, do ya, punk?”

It’s not that I don’t like Report Writer, I’m certified in it, I’ve written reports from scratch in it (not just modified existing reports) and modified more reports than I care to count. I just prefer newer options.

In high school I owned a ‘73 Mustang. The big one with a hood as long as your house. It was a lot like Report Writer. It ran fine and was very fast…in a straight line. Sure you could turn it if you like sliding but it wasn’t recommended. It also had this annoying habit of dripping ice cold AC condensation on the legs of the passenger when you turned corners. (Another reason not to turn.)

I figured if I ever wanted a second date I needed to upgrade my ride. Report Writer is a lot like that. It runs fine. It isn’t as nimble as newer options and it occasionally pours cold water on people. If all you know how to use is Report Writer, it’s time to upgrade your ride.

Creating an account mask for social security numbers

Doug Pitcher examines Creating an account mask for social security numbers

Error When Switching Back To Microsoft Dynamics GP From Report Writer | azurecurve

Ian Grieve tackles an Error When Switching Back To Microsoft Dynamics GP From Report Writer

Dynamics GP Land: Little Tricks With Report Writer Package Files

Christina Phillips has a great post up on Little Tricks With Report Writer Package Files

Indicator to specify single page or multi page customer statements | Interesting Findings & Knowledge Sharing

Sivakumar shows us how to create an Indicator to specify single page or multi page customer statements

Dynamics GP Land: Reporting Puzzle (2 of 2)- Report Options and Report Groups

In reporting puzzle 2, Christina Phillips finds inconsistencies in Report Options and Report Groups.

This is  just obscure enough to make me sit up and take notice. We found some unrelated obscure things recently. Maybe it’s something in the air.

Kuntz Consulting is back with a bug

Kuntz Consulting ran into some GP R2 Report Writer issues recently and they cover it in I’m back with a bug!

Accessing Internet Information from Report Writer - Developing for Dynamics GP

David Musgrave looks at Accessing Internet Information from Report Writer.
I’ve run into this before and it’s interesting because the Internet Information windows actually access Company level tables so it often requires a little extra work to get to them.

 

Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement - Developing for Dynamics GP

Marian Verzosa looks at a support case dealing with Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement.
She delivers a workaround with lots of specifics.

Report Writer Series: Toolbox Tips - Kuntz Consulting

Kuntz Consulting looks at Toolbox Tips for Report Writer.

Working with Vertical Lines in Report Writer - Developing for Dynamics GP

David Musgrave is back with a nice look at Working with Vertical Lines in Report Writer . There is a lot of practical advice in this post on a topic which can be maddening so pay attention.