display data in different branches

[nb4884]

Hi All,

I have a report which has 5 phases. 1,2,3,4,5.

Each project has a phase. Project has costs in multiple phases

For ex: Data for costs in phase 5 project is
Phase Department $$
3 HR 500
5 Accounts 100
5 Admin 200
2 Accounts 300
1 Admin 100
1 Admin 200
1 Accounts 300
1 HR 400
Need to build a formula so that if you select phase = 5 in parameter, it would look in costs for phase 1 and department = Admin and display 300 (100+200).

Thanks

 

[lbass]

What is the logic behind this? Why would selecting Phase 5 be connected to Admin costs in Phase 1?

-LB

 

[Madawc]

I think you need to add the table twice: just select it twice and the second selection will be an 'alias' with a different name.

Do a left-outer link from instance 1 to instance 2, using Department.

This would give you 500 rather than 300 for your example. Do a running total, excluding the phase that was selected in the parameter, if that is the rule.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP