hyperlink

Belias
Belias Member Posts: 2,998
edited 2010-10-27 in NAV Three Tier
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
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog

Answers

  • ara3n
    ara3n Member Posts: 9,258
    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="
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Belias
    Belias Member Posts: 2,998
    :-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 :(
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • prototyper
    prototyper Member Posts: 70
    Have you thought of storing the link in a setup table?
    Then you have a different value in development than in production.
    Sleep on it... The best solutions come at 2am
  • Belias
    Belias Member Posts: 2,998
    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
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • ara3n
    ara3n Member Posts: 9,258
    There is another post that shows you how to get the service tier name.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Buba
    Buba Member Posts: 24
    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
    ara3n Member Posts: 9,258
    viewtopic.php?f=32&t=44186
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories