Title & Code

Mon, 09/12/2011 - 05:41 — marksteadham

I'd like to get a cross reference list sorted first by Code and a second list sorted by Title. It makes it very difficult to find a Project by title if they are sorted by Code. I have a paper file by Code but need an alpha list by Title. Is this possible?

Organizer Forum

Tue, 09/13/2011 - 12:00 — Chris

No built-in report

Mark -

Thanks for the inquiry.

I checked the interface and there's no built-in way to get a listing of projects both by code and by title.

However, you can make use of the export to csv feature and build a quick spreadsheet to sort however you'd like. Set up a listview in Project Explorer that has all of the projects listed, e.g. select the "Projects" tree node (while not using Workspaces). Then select the tool bar button to save to csv.

You get a listing of all projects in .csv format, that you can then parse in excel to separate the code from the title. And then sort however you'd like. Use the 'Text to Columns' wizard in Excel.

I know it's not optimum - but it'll work. In the meantime, I will look at enhancing the reports so that it's a push button solution in the future.

thx
Chris