Bare Bones Configuration Guide for Dynamics AX Projects

If you are active in the Dynamics AX community, you probably have run into Murray Fife, a self-described “Curator, Author, Pitchman, Microsoft MVP & Mediocre Programmer”. His site, Dynamics AX Companions is chock full of useful information about AX for novices and experts alike. His latest project is a collection of Bare Bones Configuration Guides that walk…

2

Dynamics AX Workflow Processor Demo Shortcut

If you work with Dynamics AX, you are probably familiar with the Tutorial_WorkflowProcessor form. Many processes are driven by the workflow engine within Dynamics AX and in a production system, workflow tasks are executed by the”Workflow messaging processing” batch job. However, the minimum recurrence interval supported by the AX batch job infrastructure is 1 minute. If…

0

Marquee Moon (Field References in Page Headers and Footers)

One of the questions that I get often is about putting database fields in their SSRS report page header and/or footer. Note that putting fields in the page header and footer is not the same as putting a data region in these sections. Because of the impact on layout (what happens when it grows?), we do…

1

At the End of Paths Taken (Modifying Where Clause when All Parameter Values are Selected)

  With the return of “Select All” in Service Pack 2, all multi-value parameters allow the user to pick all of the available values. But what if you want to remove the predicate from your WHERE clause instead of generating a long set of values in the IN predicate? You can accomplish this is via an expression-based query…

1

Wincing the Night Away (Tips for SSRS in SharePoint Mode)

Here is some useful information about using SSRS in SharePoint Integrated mode (included with SP2): Installing the SharePoint Add-In If you plan to upgrade from a previous version of the add-in, you should uninstall the previous add-in then install the new one. After installing the new one, you will need to perform the RS configuration…

26

Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)

Some people have had problems during installation of the new Reporting Services Add-in for Microsoft SharePoint. If the add-in setup fails while to add the Reporting Services feature to the sites, some of your SharePoint sites will no longer work.  You can tell if the custom action failed by looking for a file named RS_SP_#.log in…

14

End of Amnesia (Avoiding Divide By Zero Errors)

People often ask how to avoid divide by zero problems in their Reporting Services reports. Let’s say you have a textbox that calculates profit margin via the expression: =Fields!Price.Value / Fields!Cost.Value This works fine unless a value in the Cost field is zero (and is not an integer or double), in which case you will…

19

Alien Lanes (Logical and Physical Pagination Rules)

One of the things I see people getting confused about in Reporting Services is around page sizing. Not setting the correct properties can result in extra blank pages or improper paper orientation. Here are some general guidelines for setting page sizes. The rules around page sizing depend on whether you are talking about physical pagination (used by the print control…

54

All Mod Cons (Multilingual Reports with AS2005)

Based on feedback from a couple of folks, I’ve decided to make my post titles a bit more descriptive. I’ll still use the name of one of the albums in my music collection as the primary title but will also include a description of the actual content of the post (happy, Jason?). Anyway, one of…

7

Perfect From Now On (Custom Chart Legends)

While the legend built into Reporting Services charts is relatively easy to use, it lacks some of the flexibility that you might like to have. One issue is that it takes up space within the chart boundaries, making the plot area smaller as the number of series grows. So how can you get more control over the…

13