Wednesday, March 7, 2012

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"

ThanksFound it:

"http://blahblah/page.asp?=" + totext({field}, 0, "")

The zero removes the decimals and the third argument apparently is the
thousands separator.

No comments:

Post a Comment