At the very LEAST:

Project List - Showing Project Name, Project Manager, Created Date, Due Date, Priority

Project List with Milestones - Same as above with each Milestone created for each Project (listed under each project).

Project List with Milestones and Tasks - Same as above also showing each To-Do List (including Items) for each Milestone.

I've tried importing the XML Data Backup into Crystal Reports 2008, but it requires an XML Schema File, which Zoho will not supply me with and also will not support this version of Crystal Reports.

I've tried importing the XML Data Backup into Zoho Reports....It won't accept it...

So now I'm importing the XML Data Backup into Microsoft Access.  There's a few errors but mostly with messages, but I dont' care about messages anyways.  I'm able to import it and it automatically creates the following tables:

associated-documents

client

clientuser

comment

document-tags

docversion

filetags

general-milestone

message

messagecategory

milestone

org

pmchatparticipants

pmchattopic

portaldata

project

projectdocument

projectfolder

tasknotes

todolist

todolistitem

todo-owners

user

userprojectmapping

whatamidoing

I'm able to create a relationship between the Project Table and the User Table with the following fields:

Table: project -- Field: projowner LINKED TO Table: user -- Field: login-id

With this relationship I can create a report showing:

Project Name | Project Manager --> The fields used are:

Table: project -- Field: projectname & Table: user -- Field: display-name

There is no area in Zoho Projects for a Priority (I don't know why???) So, I'm guess I'll have to create my own table in my Access Database and associate a Priority to each projectid.

Where I'm stuck at now, and am in need of some guidance from Zoho Support is I don't see any direct relation between these tables to create a relationship for Milestones belonging to a project...same for To-Do Lists belonging to a Milestone.  What is the relationship between Projects and Milestones and To-Do Lists.

Also, all the date tags in the XML have a string of numbers that I can't seem to figure out how to convert them into an actual Date.  Here is an example: <created-time type="long">1307557525438</created-time>  What does this mean?How can i get my date?

OR....

Zoho should implement more reports in Zoho Projects...

Thank you,