Formula for exception clause -- pl advise

[robercr12]

hi,

Scenario:

Servers are in the process of migrating from one data center to another datacenter on a particular week date.
Each server is associated with a particular project ID. Each project ID has many servers.

Old/Current/future projects are defined by dates mm/dd/yyyy

example:

Project A is an older Project that happened last month.
Project B is an Project that is happening now.
Project C is a project that will happen in 2 months in the future.

Project A: Has a total of 10 servers.
Server A1, A2, A3, A4, A5, A6, A7, A8, A9, A10

Project B: Has a total of 7 servers.
Server B1, B2, B3, B4, B5, B6, B7

Project C: Has a total of 9 servers.
Server C1, C2, C3, C4, C5, C6, C7, C8, C9

So lets assume that Project B is the "Current Project" so 7 servers are meant to be moving this week.

Now some servers in project A could not be migrated when they were scheduled. They were moved over to Project B (current project)

So current status of Project A/B and C looks like:

Project A: (Old project)
Server A1, A2, A3, A4, A5, A6

Project B: (current project)
Server B1, B2, B3, B4, + A7, A8, A9, A10

Project C: (future project)
Server C1, C2, C3, C4, C5, C6, C7, C8, C9,+ B5, B6, B7

You can see that A7, A8, A9 and A10 were added to project B
AND
B5, B6 and B7 were added to Project C.

The purpose of this report is to find out the exceptions;

What servers(and how many) were moved "INTO" the current Project B(and from which project did it move from) and what servers(and how many) from the Current Project B were moved "OUT OF" the current project(and from which project did it move into).

Is there a way to do this?

Thanks
Rob

 

[Madawc]

Group by server for both time periods. Do a running total for the old time period and one for the new. Difference is movement, do a formula field for it.

Then do another set of totals to sum this for projects. You might need to use variable.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

The problem is partly that we don't know what fields you are working with. Your example is abstract, so I don't know whether there really is some code that attaches a server to a project (like A, B, C) or whether you ONLY have the date field to work with. How exactly IS the server associated with a project? And what happens when the server is reassigned--is there a second date field? It might help to show fields as they are actually displayed in the detail section.

-LB

 

[robercr12]

There a 4 imp fields:

Current_sch_week
Previous_sch_week

Current_target_date
Previous_target_date

Others:
last audited date
reason for move

 

[lbass]

Your response did not address the questions.

-LB