How to Develop forms and Reports for Standalone laptop based Navision system

Business Central/NAV User Forum
1

Hi

I have installed Microsoft Dynamics NAV along with sql server 2005 Express sp2 on my laptop.

Navision license is Cronus.

I want to learn this Navision Development, like I want to learn how to create Forms, Reports.

How to do this. Please suggest me.

Just Installing this Erp is enough or Do I need to configure some extra things to be able to develop forms and reports

Thanks,

sami

2

Hi,

I have installed Microsoft Navision 2009 software along with Microsoft Sql Server 2005 sp2 in my standalone laptop.

Out of six Installation steps I have installed Developers Environment option.

I have created user ID and assign super role also by going through Tools–>Security–>Windows Logins

I wanted to create user ID and assign role to Database also by going through Tools–>Security–>Database Logins

But it giving error i.e. The Microsoft Dynamics NAV Classic and Sql server Security systems have not been successfully synchronised. The Sql server login sami(user ID) does not exist on the smtech server.

Moreover It is not allowing me to create form or other objects

showing the Error, You do not have permission to create the form

I want to create form or report in this newly installed software How to do this

Please help me

Thanks,

sami

3

For database User, you need to create those first in SQL Server, this can be done from SQL Server Management Studio (SSMS). In SSMS, go to Security>> Log-in>> Create New Login

What navision license are you using? In case it is the demo (Cronus) license, then you can’t do development (or more specifically, can develop few objects and the numbers are specified for that, search on this website for Cronus License development).

You can check your license from NAV Classic client, Tools>> License Information

4

Hi Mr. Dhan Raj Bansal,

I have checked the navision license, It is indeed Cronus license.

Moreover when I am opening SQL Server It is not showing SQL Server Management Studio (SSMS)

where do I find this SQL Server Management Studio (SSMS).

What is the possible solution.

What can I do to create simple report or form

please explain me.

Thanks,

sami

5

Hi,

I have checked the navision license, It is indeed Cronus license.

Moreover when I am opening SQL Server It is not showing SQL Server Management Studio (SSMS)

where do I find this SQL Server Management Studio (SSMS).

What is the possible solution.

What can I do to create simple report or form

please explain me.

Thanks,

sami

6

your post is little confusing… i believe you open “navision sql server option” and wanting to find the SSMS…

SSMS is part of sql server, so you need to install sql server along with client tools.

Creating report or form is done from within navision, but you need to read about technical development of navision to be able to do so.

i hope this helps you.

7

Dear Sami;

  1. You Cannot create any custom forms or tables or reports with cronus licence.For this you need developer licence.

That you have to bye.

Thanks

Jerome Marshal.J

8

Hi,

Thanks for your Reply.

How can I get Developer Licence so that I can develop forms and Reports

Regards,

sami