 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / August 2005How to MOD and TRUNCATE in vb .net
we have the following formula in a business objects report that we to convert to use in reporting services - I have no clue how to perform the MOD or TRUNCATE in vb .net =If(<Agent_Calls>=0) Then "00:00:00" Else FormatNumber(Truncate((<TOTALTALKTIME>/<Agent_Calls>/3600) ,0) ,"00") & ":" & FormatNumber(Truncate(Mod(<TOTALTALKTIME>/<Agent_Calls> ,3600)/60 ,0) ,"00") & ":" & FormatNumber(Mod(Truncate(Mod(<TOTALTALKTIME>/<Agent_Calls> ,3600) ,0) ,60) ,"00") I think I have a start anyway ... this is what I have come up with so far ... its ugly! =IIF(fields!agent_calls.value = 0, 0, (Format(CInt(Fix(Fields!TotalTalkTime.value/Fields!AgentCalls.value/3600)),"00") & ":" & Format(CInt(Fix(Mod(Fields!TotalTalkTime.value/Fields!AgentCalls,3600)/60), "00") & ":" & Format(Mod(CInt(Fix(Mod(Fields!TotalTalkTime.value/Fields!AgentCalls,3600),60), "00") ) > we have the following formula in a business objects report that we to convert > to use in reporting services - I have no clue how to perform the MOD or [quoted text clipped - 5 lines] > & ":" & FormatNumber(Mod(Truncate(Mod(<TOTALTALKTIME>/<Agent_Calls> ,3600) > ,0) ,60) ,"00") |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.