Administrative Lines - Export RRS feed

  • Question

  • We have approximately 200 separate 'Working' administrative lines.  Is there any way of exporting this to excel or as a minimum copying them all to be able to paste elsewhere?

    I need to compile a list of all admin lines we have, but am unable to Select All (or more than one), nor Export to Excel etc.  I can only copy and paste one line at a time which is pretty unsustainable for 200+ lines!

    Any ideas?

    Tuesday, January 3, 2017 10:42 AM

All replies

  • There isn't a convenient way to export administrative time into excel.   I would suggest writing a SQL query to create the list.  Also one of the OLAP cubes contains the administrative list. 

    TimesheetActual contains administrative time

    Timesheet Line Type are the administrative items

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Tuesday, January 10, 2017 3:29 AM