Avatar of Sherry
Flag for United States of America

asked on 

Calculating total minutes in sql or ssrs

I have a main query for a report.  I have the total minutes for each person.  I need to get totals for Case Managers (grouping is in place) and then Facilities (grouping is in place).  It "seems" to work fine in VS but when I deploy to a server, I get some huge numbers.

I'm attaching the main query file.  Below is what I have in the totals cells =SUM[(CMO_Total)]
Microsoft DevelopmentSSRS

Avatar of undefined
Last Comment

8/22/2022 - Mon