Hi, hope this is not in the wrong section
I'm using Crystal reports XI.
Now, my subject question might sound easy, however its not working the way I want.
I have created a hyperlink field that goes to a website to show a picture.
Its for people that work in my company.
The link is basic:
I have adapted the end of the link to pick up the persons code, based on details on the report.
However on the report, the field that refers to the person ( Code is ab000) comes through in uppercase (AB000).
Now I converted this to lowercase, by using the lowercase command:
"https/ ({PERSON})+".jpg"
Now when you see this link on the report it shows, the following which is right:
However when you click on the hyperlink, the link takes you to this address which doesn't work:
If I overtype the AB to lowercase it then works fine.
So that's my problem, how can I get that to lowercase when the hyperlink is clicked?
I have tried another field on its own with the lowercase in it, and it didn't work, but looked fine on the report.
What im hoping to do in the end is produce the picture from the website on the report, but im getting the same problem with that.
So once I have this fixed one way, then im hoping the picture side will
Thank you
I'm using Crystal reports XI.
Now, my subject question might sound easy, however its not working the way I want.
I have created a hyperlink field that goes to a website to show a picture.
Its for people that work in my company.
The link is basic:
I have adapted the end of the link to pick up the persons code, based on details on the report.
However on the report, the field that refers to the person ( Code is ab000) comes through in uppercase (AB000).
Now I converted this to lowercase, by using the lowercase command:
"https/ ({PERSON})+".jpg"
Now when you see this link on the report it shows, the following which is right:
However when you click on the hyperlink, the link takes you to this address which doesn't work:
If I overtype the AB to lowercase it then works fine.
So that's my problem, how can I get that to lowercase when the hyperlink is clicked?
I have tried another field on its own with the lowercase in it, and it didn't work, but looked fine on the report.
What im hoping to do in the end is produce the picture from the website on the report, but im getting the same problem with that.
So once I have this fixed one way, then im hoping the picture side will
Thank you