Friday, September 23, 2011

Create File encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

Hi all,

Most of time while trying to attach a database in SQL Server We face a issue.

ERROR Message -

TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:Databasefilepath.mdf'.
(Microsoft SQL Server, Error: 5123)
For help, click:

Resolution -
While starting SQL Server Managment Studio, dont just double click the icon, Right Click it and select Run As Administrator.

Thanks & Regards,
Saurav Dhyani

Tuesday, September 20, 2011

JET Reports In Navision

Hi all,

Navision have introduced new type of Reports Jet Reports.

Lets see some details about the product.

As of today Jet Reports Express for Microsoft Dynamics NAV is available for download at PartnerSource and CustomerSource for customers on an active Business Ready Enhancement Plan.

Partner Source JET Reports For Navision

Customer Source Jet Reports For Navision

TransHeader & TransFooter in RTC Reports

Hi all,

While Trying to figure out something new features in Navision RoleTailored Client, I figured out a blog which i find usefull 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

Thursday, September 8, 2011

Database Backup from SQL Server Managment Studio

Hi all,

Some Client requires to take database backup on daily basis but due to increasing size of data its is tedious and time consuming if we suggest to go for Navision Backup.At this point the best solution to suggest is to take backup from SQL Server.So lets discuss how to take backup of a database from SQL Server Managment Studio.

For taking Backup from SQL Server there are certain steps -

Wednesday, September 7, 2011

Problem In Dynamics NAV 2009 R2...

Hi all,

While browsing over web about new features of Dynamics NAV 2009 R2, i find some information about same in Waldo Blog.

The title of the Blog is Dynamics NAV 2009 R2 is not a "normal" release ... beware!. 

After reading the Blog i was surprised and thought that every partner and customer should know about the same.

So before upgrading to Dynamics NAV 2009 R2, please read the article at Waldo Blog. You can read the post here.
Thanks & Regards,
Saurav Dhyani 

Monday, September 5, 2011

Types Of Pages in NAV 2009 and Later...

Hi all,

I figured out that lot of us find issues while designing Pages. So i thouht why not start writing about Pages.

Lets see different types of Pages in this Post and Later on in other posts we can discuss how to create them and transform them.

Diffrent Types of Pages avilable in NAV 2009 and Later are -
1)   Card.
2)   List.
3)   RoleCenter.
4)   CardPart.
5)   ListPart.
6)   Document.
7)   Worksheet.
8)   ListPlus.
9)   ConfirmationDialog.
10) NavigatePage.

Card Type Page is Same as Card-Type Form.
Example of a Card Type Page -

List Type Page is Same as Tabular Type Form.
Example of a List Type Page-

Role center Page is the page which we see when we start Role Tailored Client.
Example of a Typical Role Center Page -

CardPart Page
A Card Part page is used in a FactBox on another page to view or edit additional fields associated with a selected entity in the page. The following illustration shows an example of using a Card Part page on a List page that displays sales orders. In the FactBox on the right, a CardPart page displays details about the customer that placed the selected sales order.
A Example of Card Part Page is -

ListPart Page
List Part Page is same as List Page. Similar to a List page, a List Part page displays content from a table in a list format. The difference is that you use the List part page as another page in a FactBox or as a part of the Role Center page. The following illustration shows a List Part page that is used in the Role Center for showing a list of the user's customers.
An Example of List Part Page is -

Document Page
A Document Page usually consists of two separate pages combined into one, with one page nested in the other. A Document Page is suitable for use when you want to display data from two tables that are linked together. This is the case, for example, with sales orders, which have two source tables: Sales Header and Sales Lines.
An Example of Document Type Page is -

Worksheet page type for creating worksheet or journal task pages. The Worksheet page consists of a single grid in the content area and a section at the bottom with details about the selected grid line or totals for the grid.
An Example of Worksheet Type Page is -

A ListPlus Page is Like a Card Page having multiple Tabs.
An Example of List Plus Page is -

A Confirmation Dialog Page is a page which ask for user for Yes or NO. we can see a confirmation dialog page while selecting a customer in the sales order, and the customer credit limit is checked.
An Example of Conformation Dialog Page is -

A Navigate Page is used for navigation of Document Page. we use these type of page while navigating the posted entries.
An Example of Navigate Page is -

If you find the information about pages helpful then please comment so that i can go ahead and post other articles related to creating pages in Role Tailored Client.

Thanks & Regards,
Saurav Dhyani