Custom Report: Can you hyperlink to a task or requisition?

Unanswered Question
Nov 17th, 2011
User Badges:

Custom Report: Can you hyperlink to a task or requisition?

When defining, configuring a custom form based report, how do you hyperlink to the task item or requistion?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Meghan Williams Thu, 11/17/2011 - 18:12
User Badges:

Hi

I've had this one answered with our yes! hours, I'm sure it came up in the training too - I'm assuming you are using advanced reporting?

If your requisition URL is http://servername/RequestCenter/myservices/navigate.do?requisitionId=18954&query=requisition you would need to create a colum in the report with the expression

'http://servername/RequestCenter/myservices/navigate.do?requisitionId=' || cast ([REQUISITIONID],VARCHAR(10)) || '&performerID=&query=requisition'

You would then need to insert a hyperlink type column and make the value of the computed value your hyperlink - I chose to make my ReqID the display name. As you are hardcoding the URL in, you will need to change it as you migrate between environments.

Hope this helps - it is going to make drill downs a lot easier for us now.

Meghan

Actions

This Discussion

Related Content