get ineger from number

[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

[Jan]

Hello,

You can use following expression:

Code: Select all

{(int)Totals.Sum(GroupHeader1,Table1.fieldname) % 60}

Thank you.

[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.

[Edward]

Hi

You can use the following formatting then:

Code: Select all

{  ...   ((int)Totals.Sum(GroupHeader1,Table1.fieldname)%60).ToString("#00")}

Thank you.

[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")}

[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.