I have a crystal report which shows example data as follows, there are literally hundreds of id's which change on a daily basis.
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
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