Opening NAV from SQL Reporting Services

vegnews

I have built a SQL report that will be referencing open Sales Orders. I have added a hyperlink on the Sales Order Number that opens up the Sales Order form but I can't get it to open the correct Sales order number. Here is the hyperlink code that I have created that will open the Sales Order (SO1114) that is in the code. I am looking for the link to open the Order number that is clicked from the report.

="navision://client/run?servername=hqnav%26database=TEST%20Components%26company=Olon%20Components%26target=Form%2042%26view=SORTING(Field1,Field3)%20%26position=Field1=0(1),Field3=0(SO1114)%26servertype=MSSQL"

I am using NAV 5.0 SP1 and SQL 2005

It's obvious that it can be done, but I am missing something

Any assistance would be greatly appreciated.

Thanks
Rob

ara3n

What I do to get the link correct is go to a sales order. Click on File->Send-to->Desktop

Then go to properties of the link on your desktop and paste that in your report. It should work.

vegnews

Thanks for the response.

I knew how to do the copy that you mentioned, however what I am looking for is to open a Sales Order directly from a SQL report based on the Sales Order number clicked.

Thanks
Rob

ara3n

right, well all you change in your report is


Field3=0(SO06689)


to the order no that prints on the report.

vegnews

Again.. Thanks.

I know that if I change that value it will open the correct Order. I am trying to have a user click on Sales Order Number in a SQL report and open the Order Number they clicked. There has to be a piece of code of something that goes into the Hyperlink that will open the clicked Order.

Thanks
Rob

ara3n

I believe reporting services only allows http:// urls