hyperlink

Belias

in order to create links to pages in reporting services, we have to write odd url like this
="DynamicsNav://DN-NWS01:7046/DynamicsNAV/mycompany/runpage?page=18038646&mode=view&bookmark=" + Fields!FORMAT_PatientRecRef_RECORDID_0_10_.Value

is there a way to retrieve this part ([url=DynamicsNav://DN-NWS01:7046/DynamicsNAV/mycompany/runpage]DynamicsNav://DN-NWS01:7046/DynamicsNAV ... ny/runpage[/url]?) automatically from the system?like nav does for record links.
thanks for your suggestions

ara3n

The only thing that is dynamics is the service name and Company Name. You can get those in CSide and pass them as datasource.

In Report layout on the properties of the text box in the Navision Tab Select Jump to URL and

set the expression to
= "DynamicsNav://" & Fields!ServerName & ":7046/DynamicsNAV/" & Fields!CompanyName & "/runpage?page="

Belias

:-k
i guess it's better than nothing...the problem is that reports with hyperlink working in development db, can fail (i mean, only the hyperling is going to fail) if the production database have a different service name

prototyper

Have you thought of storing the link in a setup table?
Then you have a different value in development than in production.

Belias

Yes, this is also good solution...it's only one setup, but things can change (e.g. the company reorganizes the hardware, giving different server/service names) or that report is developed for an addon (thus deployed for multiple customers) and the setup must be revisited every time...
how in the hell nav get that nice address in the recordlink table?
it has to catch it from somewhere, hasn't it? :-k

ara3n

There is another post that shows you how to get the service tier name.

Buba

ara3n wrote:

There is another post that shows you how to get the service tier name.

Where? I used the search, couldn't find it. Implement Google search

ara3n

viewtopic.php?f=32&t=44186