navision://client... in Sql Server reporting services.

netblazer

I've built a report that lists all the items that need processing for X.

The user would like to click the a from Excel or SSRS that opens NAV, goes to that article.

I know this can be done with "send to desktop" which creates the fully working link. However when I copy / paste that to SSRS it just doesn't want to work.

I'm scratching my head as to how I could include the Nav path in there so that the client actually opens.

Any ideas?

Here's the link I have on my desktop that works...

[url=navision://client/run?servername=Srv%26database=PROD%26company=Groupe%20Inc.%26target=Form%2030%26view=SORTING(Field1]navision://client/run?servername=Srv%26 ... ING(Field1[/url])%26position=Field1=0(P-026)%26servertype=MSSQL

netblazer

Nevermind, I was testing incorrectly.

When deployed to in the web env. it works. But not straight from VS bids.


Now on to excel (fingers crossed)!.