you should find examples in the Help file included...
It must be something like..Right click the field->Format->display(or something like that->click on x-1 to the right of the textbox and then type ToNumber(yourField) in the code window... sorry I can't help you more b'cos I don't have crxi installed...
THANK YOU FOR RECOGNIZING MY CONTRIBUTION AND RATING ME!
Insert a new formula field, name it FTotal (or whatever you like)
Inside the formula, write :
Code:
ToNumber({print.total})
Place this formula in the detail section instead of your actual field print.total
You can format with decimals now because it's numeric data
You can insert a Summary for this field OR you can do it the same with your field print.grand_total (but this you are going to place in report footer section)
JG
Last edited by jggtz; Aug 31st, 2010 at 01:36 AM.
Reason: Syntax error in ToNumber, must be only ToNumber(field)
Thnx jg , but while inserting the formula some error occurs...one very small help..please do the changes in my attached file & post.......thnx in advance
To Suppress the zeroes :
1 Click rigth button over every field that you need to format
2 Select Format Field
3 The Format Editor window appears
4 Select Number tab
5 Click on Customize button
6 The Custom Style window appears
7 Check in Suppress If Zero
8 Accept & close the opened windows and that's it
Normally, if the field is going to contain numeric data, we design that field numeric type data in the table
Since the field print.qty is string data type, you have to convert to numeric in order to sum it and get a total
Post your actual rpt (again so you don't lose your last changes)
As I understand you want to print a bill every page :
1 Click right button over left side of the report in design view (over any of the sections' name)
2 Click on Section Expert
3 The Section Expert window appears
4 Select 'Group Header #1 ...' in the left side of the window
5 Check 'New Page Before'
If that's not what you want, then explain a little more
SORRY,
IN THAT REPORT there is 7 details ,you could see it in my report,if we write 10 details ,the balance 3 detalis should print in next page automatically.and the grandtotal also should come in that page....
Reply With Quote
thank u very much....this is what i want..& one thing that 0.00
