Formula Help

[micro2005]

Hi everyone!
I am creating a report using SQL server 2000 and CR 10. The report is based on a view. My current report design includes two groups (office and status of complaint). The detials section includes the complaint and related info. All group footers are suppressed. There are some cases that have been consolidated. The view has two columns associated to the consolidation event.
1. consolidated -> gives the value for the matching consolidated cases e.g. 1 so all the two cases that have been consolidated will have "1" in this column.
2. ps_consolidated -> Has either 'P' for primary case, 'S' for secondary and null for N/A.
Currenlty I have used a created a formula which tells me if the case has been cosidated and if its primary or secondary.
if isnull({cr_activeemployee.consolidated})
then
'N'
else if not isnull({cr_activeemployee.consolidated})
and
{cr_activeemployee.ps_consol} = "P"
then
'Y'
else if {cr_activeemployee.ps_consol} = "S"
then 'S'
I need to display the secondary case number in the details section. I have tried to create a formula but it is returning the primary case id. Any ideas how I can do this?
Thanks!

 

[Turkbear]

Hi,
If the {cr_activeemployee.consolidated} field gives the # for the consolidated cases related to this case then just show that field in the details and suppress it when
{cr_activeemployee.ps_consol} <> 'S'





To Paraphrase:"The Help you get is proportional to the Help you give.."