Search results for query: *

HO! Thank you for the support ... But something is missing ..I am not on Oracle .. I am in sql database the function TRUNC does not exist .. But I tried to replace it with @INT function but it did not work, try it using an sql database running report smith ... I think the key to this problem...

I am using report smith on sql , this is the result that I want rounded up to the next $1000. Example 88,200 = the report should print this 89,000. 44,000.21 = should print this 45000 44.000.00 = should print this 44000 45,200.00 = should print this 46000 44,700.00 = should...

I am using report smith on sql , this is the result that I want rounded up to the next $1000. Example 88,200 = the report should print this 89,000. 44,000.21 = should print this 45000 44.000.00 = should print this 44000 45,200.00 = should print this 46000 44,700.00 = should...

I am having the fallowwing problem ..can someone help ... kay, I saw one reply to an earlier post regarding rounding to the 1,000th but I haven't been able to get it to work: 1. Add 999 to your original field. 2. Truncate to a derived 2 digit integer field. 3. Multiply by 1000 with result in...

Ex: $21,166.00 rounds to $22,000 great. Another employee making $23,670.00 rounds to $25,000 bad, I need it to round to $24,000. How can I solve this rounding issue I am using reportsmith ... SCott