Find projectscompleted in a report

[Sanjai]

Hi,

I have a table with the following fields:

PlannedDate

ActualDate

ProjectName

PlannedMonth

Milestone

Category

A project can have multiple milestones which would be in separate records. Same milestone can be selected for multiple projects. The project is completed if an actual date is entered.

I want to generate a report in the following format:

Category1

PlannedMonth(January 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

PlannedMonth(March 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Category2

PlannedMonth(January 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

PlannedMonth(March 2005)

Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX

I have created a layout with summary parts for Category, PlannedMonth and Milestone to group the records.

To show total projects I have created a summary field "SummCountMilestone" which is a count of Milestone. Then a calculation field which results in getsummary(SummCountMilestone, Milestone).

The calculation field above displays the TotalProjects for a milestone when the data is sorted by Category, PlannedMonth and Milestone.

My question is how should I show the ProjectsCompleted and DueProjects information in the report?

Thanks in advance,

--Sanjai

[Sanjai]

Hi Everyone,

I solved the problem. Thanks