"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