URL Linking on report

Mark Wilson
Mark Wilson used Ask the Experts™
on
I have a crystal report which shows example data as follows, there are literally hundreds of id's which change on a daily basis.

ID           Name
1             Smith
2             Jones
3             Bill
4             Adkins

I want to link the id to a sarepoint list which gives further information on that id and name,
there is no username and password on the list

The url is

http://intranet/sites/Lists/Change%20Requests/DispForm2.aspx?ID=1&Source=http%3A%2F%2Fintranet%2Fsites&ContentTypeId=0x0100E8A78526866E4646A576570B8B1F2F81

The ID relates to the ID column so 1 will pen 1, 2 will open 2 etc

How can I do this so when the user clicks on 1,2 or whatver number id it will open to the relevany id on sharepoint?

Im using BOXI R2

Thanjks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Right click on the id field -> Format field -> Hyperlink tab -> Hyperlink Type = A website on the internet, and enter a conditional website address formula

"http://intranet/sites/Lists/Change%20Requests/DispForm2.aspx?ID=
& Cstr({table.id},0,'') &
"&Source=http%3A%2F%2Fintranet%2Fsites&ContentTypeId=0x0100E8A78526866E4646A576570B8B1F2F81"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial