|
Home > Archive > Microsoft SQL Server forum > June 2005 > Crystal 9 hyperlink text
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Crystal 9 hyperlink text
|
|
|
| I am formating text by adding a hyperlink that looks like this:
"https://IQuoteSummary.asp?vid=" & {v_L.VersionId}&"&lid=" &
{Locations.LocationId}
Both database fields are type number
The url enters the address:
"https://IQuoteSummary.asp?vid=1,521.00&lid=12.00"
It works when I run the report in crystal but after publishing it on
the crystal publishing wizard thing, I get those weird numbers.
I need these numbers as ints and without a comma. I tried changing the
formatting on the database fields on the report but that doesn't work.
Any idea how to get the url to print like this:
"https://IQuoteSummary.asp?vid=1521&lid=12"
Thanks
| |
|
| Found it:
"http://blahblah/page.asp?=" + totext({field}, 0, "")
The zero removes the decimals and the third argument apparently is the
thousands separator.
|
|
|
|
|