Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

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

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?

Everyone's tags (1)
2 REPLIES
New Member

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

I'm just adding a post so this comes up, I'd love to know too!

Thanks

New Member

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

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

233
Views
0
Helpful
2
Replies
CreatePlease to create content