Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi Readers, In This article we will discuss how to resolve an Issue that we face During Creation of a RDLC Report. Applies To - NAV 2009 and Later (RDLC Reports) Scenario - You are creating Say a Document Report. There are multiple tables in Body. For Linking these tables you put all these tables inside a List. When You want to save the Report, You get an Error Message - Error while validating RDL content: The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.

Hi All, Today we will discuss about the Parameter String Field in Navision Job Queue Entry Page / Form.  The Functionality is still same, so the steps below can be replicated and used in NAV Classic also. For Demo Purpose We will be using NAV 2013 R2.

Hi all, I know most of us know this but its a post for the New Consultants. This post is based on requirement of one of my friend + Shrikant Sharma .  In this post we will see How to Add Users  in the Database, so if you know how to do you can skip the post.

Hi all, With NAV 2009, while using web services we face a common issue related to Metadata of the Table with Id 2000000073. Let's see the reasons behind it and how to resolve it.

Hi all, I found lot of Queries about this, so lets try to do this. I Divide this article into three parts - 1) Enabling Multiple Copies in a standard Report - Classic. [This Article] 2)  Enabling Multiple Copies in a standard Report - RTC. 2) Set Page X / Y in Multiple Copies printing Reports. For the Demo I will be using Standard Report 16593 - Excise Invoice. This report have none of the above listed points.

Hi all, In all the previous posts we have discussed about how to create multiple NAV Services to Run Multiple RTC for same or Different version of Role Tailored Client. But we never discussed about how we can create multiple Web Services. I required to Publish Multiple Web services and that is the reason i come up with this Post. Hope you will find it use of this post somewhere.

Hi all, As promised in the blog entry  I will list down some common known things that we need to take care while estimating & developing RTC Reports in 2009 Versions. * These are my faced issues and their resolutions, you may not agree with all these. If that will be case I would suggest you to share same with others. Lets begin with RTC Report Header - During development you might have seen that in standard reports there are basically two ways to display report Headers. 1) Using Page Header. 2) Using Header in Body. When to use which?

Hi all, I know it to late but I wish you all a very Happy  & Prosperous New Year . I am so much busy these days that I can't even make a Blog entry. So here is the list of points that I will be coming up in next few days (once I will get free) - As most of us still working on NAV 2009 Reports. Let's figure out the challenges we face during development of RTC Reports.

Hi all, I think I got late with this post, but I was unaware that most of us still don't know how to add reports in Role Tailored Client Reports. So let's have a look on the same. For the demo purpose I will use standard report with ID 111.

Hi all, In Case of Report Development in Landscape Format, it was behaving wired. In need to select the printer orientation from the printer settings. But later on I thought about the same and started searching on the web. Then From MSDN i found out that if the report settings in RDLC are done correctly then we don't need to change the printer settings every time.

Hi all, While trying to open the Report Layout of a Report I faced a strange error that says. --------------------------- Microsoft Dynamics NAV Classic --------------------------- The provided metadata is not valid. --------------------------- I searched on the web and after finding the solution, I was kind of felling angry.

Hi all, While browsing for RTC Report Development i found out something, which i thought to share will all. Some videos for Report Designing in RTC have been uploaded in YouTube.  Have a look on the playlist here . Thanks & Regards, Saurav Dhyani www.sauravdhyani.com

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Hi all, While Trying to figure out something new features in Navision RoleTailored Client, I figured out a blog which I find useful to share with you all. Most of the time customer ask for Transheaders and Transfooters in Role Tailored Client(RTC) Reports and we say that it cannot be done as read in Microsoft documents. I tested by creating a report as suggested in the Blog and it worked as expected. Its is done by using the Hash Table in the Report Code Section. Please read the complete blog at here . Thanks & Regards Saurav Dhyani www.sauravdhyani.com

Hi all, If you haven't read part1 and part2 then click here for Part1 and Part2. Now lets see what can be done to create Page Header without any issues. Lets check what Microsoft do to create Page Header for the same report. Here is what it see the Layout of standard Report.

Hi all, If you haven't read the part first then read it  here. Now when you created the suggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body. The most part of an RTC Report is the Page Header, we all face issues in this. Let's discuss what happens when we say suggest layout.

Hi all, we all have some known and unknown issues while creating a Report For Role Tailored Client . we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch. I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1. Then I deleted its existing layout by using Tools->Delete Layout. Now lets create the Layout from Scratch. Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.