Tuesday, 29 July 2014

RDL vs. RDLC versions and Dynamics NAV

Since the NAV team has been real busy is it time for an updated chart which explains when each version of RDL and RDLC was released. It also clear in this chart that the SSRS team in the SQL team, responsible for RDL is planning something big in the next version since nothing has happen since SQL Server 2008 R2, or they have stopped improvements to RDL.



NAV RTC - Introduction to Web Services.

Hi all,

This post is a introduction post about web services in Navision.

Agenda for this post -

1) Types of Web Services.
2) Differences between types of web services.
3) How to publish a web service.
4) How to see the published web service in Internet Explorer.
5) How to check all Published Web services.

Part 1 - Types of web Services?

NAV 2009, 2009 SP1 and 2009 R2 -

In these versions of Navision we had only one type of web service i.e SOAP Web services. It is an XML based protocol for accessing Web Services.

NAV 2013, NAV 2013 R2 -

With NAV 2013 Microsoft have come up with two types of web services i.e SOAP web services and ODATA web services.

Part 2 - How these Two Services Differ in Navision?

With SOAP Web Services you can publish either Microsoft Dynamics NAV pages or codeunits as SOAP services.

With ODATA web Services you can publish either pages or queries as OData services.

Part 3 - How to publish a web service?

*Following Screenshot are from NAV 2013 R2.

1. Open Role Tailored Client.

2. Navigate to - Departments/Administration/IT Administration/General/Web Services.

3. Click New.

4. Select the Object Type, Object No and Provide a Name to the Web Service.

5. Click on Published.

As i have created a Page web service i have both the URL i.e SOAP and ODATA.

But if i select a codeunit as shown below, i will get only SOAP URL and ODATA will be Not applicable. In the same way If i select a query i will only get URL for ODATA not for SOAP.

Till NAV 2009 R2 we don't get the URL for the web service published.

Part 4 - How to see the published web service in Internet Explorer?

You can copy the URL Generated in web Services Page and run that URL in Internet Explorer.

SOAP Web Service

ODATA Web Service

The Screen Shot Above shows the exposed Page Customer in Internet Explorer.

Part 5 - How to check all Published Web services?

If you would like to see what all objects have been published in a web services you can follow below steps -


FOR SOAP Web Services you can use below format as URL in Internet Explorer -
http://ServerName:PortNo/Instance Name/WS/Services

In my case i am using below URL


For ODATA Web Services you can use below format as URL in Internet Explorer -
http://ServerName:PortNo/Instance Name/OData/

In my case i am using below URL

I hope you would have get some basic Ideas about web services.


Monday, 28 July 2014

Alternating background colors in Reporting Services

One common question from many of those who are relatively new to Microsoft SQL Server Reporting Services is how to alternate the background color of detail rows in a table data region.

Although I'm sure samples of this have been posted elsewhere on the Internet, I thought I'd share a common technique in the hopes that those searching for a solution will find it, either here or elsewhere.

Let's consider an example. We have an employee phone list report as shown below.


To make the report a little easier to read horizontally, we'd like to change the background color of every other row. To do so, let's highlight the detail row of the data table in the layout tab.


In the properties window, find the BackgroundColor property for the highlighted row and choose <Expression...>. Add the following conditional formatting statement in the Edit Expression window.


Click Ok, and preview the report.


And there you go, a report that alternates the background color for each row.


How to Build an Online Help Page in Microsoft Dynamics NAV 2013 R2

Online help page is a web page which displays information in a web browser when user presses the key F1 for the selected field or page in MS Dynamics NAV 2013 R2.

In this blog I will try to document the process of creating online help page for Microsoft Dynamics NAV 2013 R2 version, from creating online help topic to building the complied (html) help page and also how to integrate the help page into your project.

   ·    Microsoft Dynamics NAV 2013 R2 with a developer license.

   ·    The Cronus International Ltd. Demonstration database.

   ·    Microsoft Dynamics NAV Help Builder.

   ·    Microsoft Dynamics NAV Help Server.

   ·    HTML Help Workshop.

   ·    An HTML Editor, example: - Notepad.

Following steps illustrates the process of creating and building an online help page:

1. Setting up the Help Project Folder

                  Create a folder which contains a Source subfolder. The Source subfolder contains all project system files and source files that you will need to work with. After you compile the Help project for the first time, a subfolder named Processed is automatically created next to the Source subfolder to hold the built .chm files. You will find the html folder, under the Processed subfolder, which holds all of the .html files.

The HTML files contains online help topic which is displayed in web browser when user presses the key F1 for selected field in a page.

          I.   Create a folder named HelpExample on drive C of your computer.

         II.   Navigate to the Help Toolkit installation location, and then open the Samples folder. The installation is typically located at "C:\Program Files (X86)\Microsoft Dynamics NAV 2013 Help Toolkit"

        III.   Copy the addin_a and Shared folders to C:\HelpExample, these folders contain system files which will be used by Help Toolkit to generate .chm and .html files.

2. Creating New Help Topics and Adding Them to the Help Project

                Create the topics and add them to a Help project file that will output the .html file. If you are creating many new field topics under a table, then you can save time by using the Help Generator Tool. For more information, see http://msdn.microsoft.com/en-us/library/dn414543(v=nav.71).aspx.

Create a Help topic for the new table, field and page

         I.    In the windows Explorer, open C:\HelpExample\addin_a\Source\HTML folder and select T_9.htm file and open it with Notepad.

        II.   To display number and name of the table on the title bar of a web page, find the and replace the text with the ($ T_TableNumber TableName $) where TableNumber and TableName is number and name of the table to which you are creating help topic.

       III.   To display number and name of a page on the header of a web page, find the and replace the text with ($ T_TableNumber TableName $).


                                           Figure 1: Shows <title>and <span> tags.

       IV.   Online Help page that displays the description of a table is added as element of the tag which is listed under the tag.

Figure 2: Shows <p> tag where you can insert a description of the kind of that the table, field or page defines.

        V.    Save all Help topics were created with an extension of .htm format.

       VI.    Repeat above steps for both page and each field in a table, just make sure that number of a table and field number of a table should be correct and should be in the bellow format.

                a.      For tables: - ($ T_TableNumber TableName $).
                b.      For fields of a table: - ($ T_TableNumber_FieldNumber FieldName $).
                c.      For pages: - ($ N_PageNumber PageName $).

      VII.     After you have created the help topic files, add them to the Help project by using HTML Help Workshop. Microsoft HTML Help Workshop (Hhw.exe) is an executable program designed to help you create help systems using source files based on Hypertext Markup Language (HTML).