Today’s #TipTuesday post is one for those who modify reports in Report Writer (mostly) or anyone who has an alternate Dynamics.set file they wish to launch in their Dynamics GP environment.
A quick review of the terms here: the Dynamics.set file is a launch file that displays the # of products/dictionaries installed on a given workstation, the list of products (product # followed by product name) and then the pathnames to the Code, Forms and Reports respectively for each of those dictionaries, in that order. Back in 2010, I wrote a series about Report Writer and the first post was some detail around the Dynamics.set, how to read it, etc.
Continue reading “Launching GP with alternate Dynamics.set file”
Well, it’s been fun but it’s time to focus on more interesting areas of Microsoft Dynamics GP. This is the last official article in the Report Writer series of posts I’ve written, although I’m sure there may be the odd article pop up that has some Report Writer content.
Continue reading “Report Writer Series: The End!”
Here, at long last, is my next-to-last blog post in the Report Writer series. It’s not that I’ve covered everything you could possibly know about Report Writer, not by a long shot, but what I’ve found is some of the basic information I’ve shared thus far wasn’t as easy to find as the more advanced stuff was. Do you want to know about using VBA with Report Writer? Editing package files? Adding Extender fields to a Report Writer report? There are many things like these that are already covered by the Dynamics GP community. In my last article I will summarize my series and include a few links to other Report Writer resources if you haven’t found them already!
Now onto this article… This one is a bit of a hodge-podge of things, there is no particular reason why these are all lumped together in one! The items here probably deserve more in-depth discussion but for the purposes of this blog I just wanted to highlight a few key things about them rather than dig deep into their usefulness.
Continue reading “Report Writer Series: Keys, Restrictions, Sorting, Grids”
The next in my series of blog posts about Report Writer is a brief article on Custom reports.
Why would you create a custom report in Report Writer? (really… why?) I’ve done it a handful of times, and don’t particularly recommend it (with all due respect to David Musgrave 🙂 ) but there are a couple simple reasons why it makes sense sometimes. The types of reports you would create with it would need to be extremely simple due to the fact there is no end user option for sorting or filtering results and no parameter input.
Continue reading “Report Writer Series: Custom Reports”
I’m continuing the Report Writer series with a brief article on Sections in Report Writer. Every once in a while I see a question on a forum “my field didn’t print and I don’t know why!”. Hopefully this will help answer that kind of question!
Continue reading “Report Writing Series: Sections”
Way back in February 2011 (yikes!), I wrote about some Report Writer toolbox items, and focused on the Arrange tab of tools. Today, at long last, I am concluding that article with some notes and tips on the drawing options (most font options), hopefully clearing up some mysteries.
Continue reading “Report Writer Series: Drawing Options Tips”
I am working on an upgrade right now with a client and have a quick tip to share, that may save a little bit of time in your testing, depending on how many company databases you have.
Continue reading “Quick Comparison Report Testing Tip”
I’m a bit behind in my blogging lately, time to catch up a little bit! Today I’m digging into some of the lesser-used items on the toolbox, and finishing this topic up next week. How can I tell these tools are not used much? The answer is simple: I’ve seen a lot of ugly reports – fields formatted poorly or not lined up with the header fields they match up to, etc.
I do cringe when I see simple things like a block of address fields (for instance) not aligned, when there are tools there for you to eliminate this issue forever.
Continue reading “Report Writer Series: Toolbox Tips”
Picking up from Part 1, now we are getting into tips and tricks for modifying reports. I am walking through a specific example of taking a report that was in text format (General Posting Edit List), converting it to a graphical report, then modifying it to make it better looking!
Continue reading “Report Writer Series: Don’t settle for ugly reports! Part 2”
Now that most of the payroll year-end tax update season is behind us, it’s back to the Report Writer series of articles.
You’re not the only one who is sick of looking at ugly plain-text edit lists and searching for the information you want to review. Have no fear, more useful and attractive reports are a few mouse clicks away!
Lots of users have gone to other reporting tools to get better looking reports and I don’t blame them. Crystal and SQL Reporting Services give us a lot of great tools to improve reporting in terms of look and feel as well as flexibility of layout and many other benefits. As much as some of us would like Report Writer to die a slow death, the reality is for posting journals and edit lists and anything with temp tables, Report Writer is “it”.
Continue reading “Report Writer Series: Don’t settle for ugly reports! Part 1”