Page 1 of 1
get ineger from number
Posted: Sun Aug 30, 2009 9:54 am
by hamed Rezaei
hi
i want get integer part of any number
i use from Div
it work in design report but dont work in generat reports!
i use this code but not worked
{Div(Totals.Sum(GroupHeader1,Table1.fieldname),60)}
8.4?
i want 8 no 0.4
get ineger from number
Posted: Mon Aug 31, 2009 6:48 am
by Jan
Hello,
You can use following expression:
Code: Select all
{(int)Totals.Sum(GroupHeader1,Table1.fieldname) % 60}
Thank you.
get ineger from number
Posted: Tue Sep 01, 2009 8:53 am
by hamed Rezaei
very tanks jan
i changed your code to
Code: Select all
{(int)Totals.Sum(GroupHeader1,Table1.fieldname)/60}
then ok
but if sum =0
show nothing value want show 0
my code now is :
Code: Select all
{(int)Totals.Sum(GroupHeader1,Table1.fieldname)/60 +"":""+(int)Totals.Sum(GroupHeader1,Table1.fieldname)%60 }
wath code for formatting result i like show 127:08 or 127:00
now show 127:8 , 127:
Thank you.
get ineger from number
Posted: Tue Sep 01, 2009 8:19 pm
by Edward
Hi
You can use the following formatting then:
Code: Select all
{ ... ((int)Totals.Sum(GroupHeader1,Table1.fieldname)%60).ToString("#00")}
Thank you.
get ineger from number
Posted: Wed Sep 02, 2009 1:17 am
by hamed Rezaei
tanky edvard
but it not worked!!!
i use it in code :
Code: Select all
{((int)Totals.Sum(GroupHeader1,Table1.fieldname)/60) + ":" + ((int)Totals.Sum(GroupHeader1,Table1.fieldname)% 60).ToString("#00")}
i testing thes code so :
Code: Select all
{((int)Totals.Sum(GroupHeader1,Table1.fieldname)/60) + ":" + ((int)Totals.Sum(GroupHeader1,Table1.fieldname)% 60).ToString("00")}
Code: Select all
{((int)Totals.Sum(GroupHeader1,Table1.fieldname)/60) + ":" + ((int)Totals.Sum(GroupHeader1,Table1.fieldname)% 60).ToString("##")}
Code: Select all
{((int)Totals.Sum(GroupHeader1,Table1.fieldname)/60) + ":" + ((int)Totals.Sum(GroupHeader1,Table1.fieldname)% 60).ToString("#0")}
get ineger from number
Posted: Wed Sep 02, 2009 8:08 am
by Ivan
Hello,
Please try to use the following code:
Code: Select all
{(int)Totals.Sum(GroupHeader1, Table1.fieldname) / 60}:{((int)Totals.Sum(GroupHeader1, Table1.fieldname) % 60).ToString("#00")}
If the issue is still present, please send to us a mrt file with data for analysis.
Thank you.