Error:TableData 2000000001 does not exist.

We get the below error when we try to connect the database

To resolve this error,we need to set the below permission in Sql server

I hope it will help you.

How to Set filters on factbox through code

I would like to set filter on my fact box which is not able to do through page link.

Steps are shown below

I have added below the function in my factbox page and

Set the name for the factbox in our main page.
Now we need to call as shown below in onaftergetRecord trigger

Microsoft Dynamics NAV 2016 System Requirements

You can find the below system requirements

 

Client components

• Microsoft Dynamics NAV Windows Client Requirements 
• Microsoft Dynamics NAV Development Environment Requirements 
• Microsoft Dynamics NAV Web Client Requirements 
• Microsoft Dynamics NAV Tablet Client and Phone Client (in a Browser) Requirements 
• Microsoft Dynamics NAV Universal App Requirements 

Server components

• Microsoft Dynamics NAV Server Requirements 
• Microsoft Dynamics NAV Web Server Components Requirements 
• Microsoft Dynamics NAV Database Components for SQL Server Requirements 
• Microsoft Dynamics NAV Help Server Requirements 

Additional components and features

• Microsoft Dynamics NAV as an App for SharePoint Requirements 
• Automated Data Capture System Requirements 
• Microsoft Office Outlook Add-In Requirements 
• Microsoft Dynamics CRM Integration Requirements 
• Automated Deployment on Microsoft Azure Requirements 

How can I Reset the page Number for each group in rdlc reports

Please follow the below steps to get the page n of m for each page

Step 1:  Make sure there's a textbox in the report which contains the group expression

Step 2:  Add shared variables to track the current group and page offset

 Shared offset as Integer
 Shared currentgroup as Object

Step 3:  Add a custom function to set the shared variables and retrieve the group page number

 Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
  If Not (group = currentgroup)
   offset = pagenumber - 1
   currentgroup = group
  End If
  Return pagenumber - offset
 End Function

Step 4: Use the function in the page header or footer

 =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)

Note:  Because this uses static variables, if two people run the report at the exact same moment, there's a slim chance one will smash the other's variable state  (In SQL 2000, this could occasionally happen due to two users paginating through the same report at the same time, not just due to exactly simultaneous executions)  If you need to be 100% certain to avoid this, you can make each of the shared variables a hash table based on user ID (Globals!UserID).

The history of Dynamics NAV / Navision

Read full story