Showing posts with label numbers. Show all posts
Showing posts with label numbers. Show all posts

Monday, March 12, 2012

function to display the numbers 1-12 in detail of table

I have a table and in the table detail section it will never have more than 12 rows;therefore, I want to have the numbers 1-12 listed sequentially on each row. For instance:

Row Data

1 record1

2 record2

3 record3

.............................through 12. Any help is greatly appreciated.

Thanks!

You can use the RowNumber function: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_3quq.asp

Enter this expression in the detail textbox where you want the row number:

=RowNumber(Nothing)

--

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks. That worked!

Friday, March 9, 2012

function or formula that convert numbers into words

Hello
I am using crystal report 9. i get total of all item purchsed by customer. what is need a any function or formula that convert numbers into words. i.e 32125 should be converted to thirty two thousand one hundred twenty five only.
With regardsCreate a formula and in forumula section (module) there were so many options like functions conversions etc and in that section look for numbers to text option and using that you can achieve what you are looking for.|||I'm not sure about CR9, but in CR10 you can use the ToWords function.