How to avoid duplicate records in formula

[makk07]

Hello All,

I am using CR XI.I have a group on UserGroup Name & security type id columns.

My UserGroup Name is in detail section but I suppressed it.

And I am using formula to display security type id and description together under SecurityType Desc column. And I placed my formula in Group Footer.


The security type id and description is getting repeated i.e;
1-Hr Applications
3-Labor
10-Finance Applications

Please suggest how to get rid of this.

Here is the sample of my output on report:

UserGroup Name SecurityType Desc

Christ A 1-Hr Applications
Christ B 3-Labor
Christ C 10-Finance Applications

1-Hr Applications
3-Labor
10-Finance Applications

1-Hr Applications
3-Labor
10-Finance Applications

Thanks in advance
mak

 

[lbass]

Please show the content of the formulas you are using to accumulate and display the results.

-LB

 

[makk07]

Hi,

Below is my formula code:

FormulaDisplay SecType Desc

TOTEXT({vtsm_liaison_security_type.security_type_id},0,'') & " " & "-" & " " & {security_type.security_type_desc}

security type id is coming from one table and security type desc is coming from another table.

Thank You
mak

 

[lbass]

If you have a group on usergroupname and then on security ID, if you drag the usergroupname into the security group header and then add your formula to the same GH2, you should not get any duplication. Please show your results if you do this, with GH1 suppressed and the details section suppressed, and all footers suppressed.

-LB