tags:

views:

9

answers:

0
Q: 

Calculate day,hours ,minutes in SSRS 2005 correctly

In SSRS 2005 expression I have values for time that are given in days,hours and minutes. The values are fine until i have to do a sum in a column on them and I end up with values like "2 days 52 hours 122 minutes" where else i would like to show proper time with the previous value as "4 days 6 hours 2 minutes" how can i achieve this.?

related questions

SSRS 2005 Saving Report Parameters
Returning data from SQL Server reporting web service call
SSRS 2005 Report Automatically Rendering
Modifying parameters with code in Microsoft Reporting Services
Subreports try and keep together leaving blank spots/pages
Locking SSRS fields in place
Subtotal error on calculated field in a Reporting Services Matrix
Dual Axis Graphs - Reporting Services 2005
Report Builder, prompt filter, how to ignore the filter?
In SQL Reporting services, is there a way to dynamically hide some parameters (but not all) from users?
How to use Multiple result sets in Reporting Services
Dimension Security in SSAS & SSRS
Using an ASP.NET server control in a sql server 2005 reporting .rdl file
Setting up Windows Authentication In Reporting Services Using Kerberos
SSRS 2005 - How do I find the value of a cell 1 column over and 2 rows up?
HTTP 400 returned while accessing SQL Server 2005 Reporting Services Report Manager
Rendering SSRS reports from VB.Net
Exporting from SSRS to Excel with no headers
How to control the target frame of reporting services (SSRS) drill down
Set a table's visibility to false when it has no rows (in reporting services)
How do I best display CheckBoxes in SQL Server Reporting Services?
How to set sql profiler to profile SQL 2005 reporting services
3rd party controls for MS SQL 2005 Reporting Services
How do you view SQL Server 2005 Reporting Services reports from ReportViewer Control in DMZ
SQL 2005 Reporting Services custom report item (CRI) - what are the limits?