Ayuda de vídeo de Screencast
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Age calculation when exporting Service Desk reports

Created: 11 Febrero 2011 | 4 comments
el cuadro de los yabru
1 Acepto
0 Discrepe
+1 1 Vote
Login to vote

By default, in both SD 7.0 and 7.1, when you export or email a report in Excel, it will show the (Age) as the actual Time and Date, rather than the Age.

When viewing the report in the Service Desk console, the Age shows correctly as 3 days or 5 days 2 hours, this format should be kept when exporting the same report to Excel.

The only way around this now, is to export the sql code, then create new a report with that code and add the DateDiff syntax....which is way too much effort for the price and advanced nature of this product.

Please can we introduce this small yet very helpfull feature....like soon!  :-)

Comentarios ComentariosIr al último comentario

el cuadro de los yabru

How are you guys exporting your reports to discuss with your Management team???

0
Login to vote
el cuadro de los Deep Green

This is a good pickup as we had the same problem. 

We did use the export SQL code method but we used the Symantec delivered function dbo.GetAgeDescription instead of DateDiff which makes it a lot easier

0
Login to vote
el cuadro de los rickss38

I just found the same issue, has this been resolved? 

0
Login to vote
el cuadro de los TGiles

Exporting reports to Excel that contain the Age Description field produces the same out put in the Excel file as the report shows in the portal in 7.5. 

0
Login to vote