Pls see attachment.i want roundoff option for grand total and total qty......pls help meee
Printable View
Pls see attachment.i want roundoff option for grand total and total qty......pls help meee
Both fields are STRING type
You should convert them to numeric in order to format
You could use the ToNumber function
JG
How to convert.pls give me the steps to convert....
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...
Thnx for reply,but i cant find & i am using cr 8.5
Insert a new formula field, name it FTotal (or whatever you like)
Inside the formula, write :
Place this formula in the detail section instead of your actual field print.totalCode:ToNumber({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
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
Check it !
JG
:):):):):thumb:thank u very much....this is what i want..& one thing that 0.00
seen in all lines is there any way to disable that.& i need that total qnty ALSO...
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
JG
thanku very much...i got it for total quantity???
For total quantity
Insert a new formula (name MyTotQty)
Inside the formula, write :
(replace {print.totalqnty} with your actual field name)Code:ToNumber({print.totalqnty})
And place that formula in the desired section
JG
thnx bro,.i think i want to add TOTALQTY field in my database..how to do ...pls help me with the attachment....
thnx JGGTZ..
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)
JG
This is the actual report......
That's all
JG
the report comes error that the string is non-numeric
no thanx bro....i done it...thank u...
some suggetions in VB 6 ,CAN I POST HERE......
THNX JGGTZ...
JGGTZ...
ONE MORE HELP PLS....
continue in nextpage while printing..
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
JG
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....
selvasathyam...
sir ,
i had added an image of my billing software created by VB6 ,i want round off for the rounded ones.....see the image pls......
Pls don't double post. It can be easily discovered :eek2:
Our mods don't like this