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

Ken Remington · ‎11-17-2011

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

Meghan Williams · ‎11-17-2011

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

Thanks

Meghan Williams · ‎11-17-2011

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