Text Formattinng Problem In CE10

[rb2005]

Hi,

I have report which has few groups. One group is returnning 200504 in CR (in drill down section) but if I run the same report in CE10 it is comming like 200,504. I have formatted the group like (1234). Still it's not working in CE. I have checked the number format in Option and it was showing (1234). Any one has any clue? I am using Oracle9i, CR 10 and CE 10. This coulmn is of number data type and stored as 200504.

Thanks,
RB

 

[Madawc]

Try it as ToText({your.value})

Madawc Williams (East Anglia, UK)

 

[goodprg]

Try using ToText({your.value},0,''). Also run the page server and web component server under a domain account in CE.

I had the same problem and doing above fixed it.

Hope this helps.

 

[rb2005]

Thanks. Yesterday I was trying with ToText and it was returning like 200504.00. Now I have used ToText({your.value},0,'') and working fine.