General information
Category:
Reports & Report designer
>>>>Hi all,
>>>>I have a report that in one of it's numeric fields i set its format to 999/999/999. but if my number be 87654 it show as / /87/654 . if i set format as 999,999,999 it show correctly as 87,654 !
>>>>where i do wrong?
>>>>Thanks for your help
>>>
>>>Use Transform(yourvalue, '@R 999/999/999')
>>
>>dear Tore,
>>when i double click on my field, in window i have two box : 1- expression 2- format
>>in which box i must use this?
>>
>>please test ?Transform(12345, '@R 999/999/999') it is wrong !
>
>I don't quite understand.
>
>1. Give me an example of a value you have.
>2. What data type is it?
>3. Give me an example of how you want to show the value on the report.
My Value is Numeric. i have a numeric column in my report and a sum row too.
i want to my numbers see such as 454/230/000 in column and 1/000/990/000 in sum for example.but if my field contain any function , i think the SUMMATION dont work and **** will appear instead numbers.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only