Pls Help -- Sub Report Formula suppress

[maecode]

Hi! I got the sql Statement below.

SELECT CaseNo, cCode, NRIC_Fin, Contact_c
FROM IND_vPROFILE_2
WHERE (NRIC_Fin = 'S7801231')
GROUP BY cCode, CaseNo, NRIC_Fin, CaseNo, Contact_c


Result

CaseNo cCode Nric_fin contact_c
----------------------------------------------------------------
CASE0001 B S7801231 65145877
CASE0001 B S7801231 65145878
CASE0001 B S7801231 http:/

http://www.contact.com

CASE0005 B S7801231 65145877
CASE0005 B S7801231 65145878
CASE0005 B S7801231 http:/

http://www.contact.com

CASE0004 DC S7801231 65145877
CASE0004 DC S7801231 65145878
CASE0004 DC S7801231 http:/

http://www.contact.com

CASE0003 S S7801231 65145877
CASE0003 S S7801231 65145878
CASE0003 S S7801231 http:/

http://www.contact.com

-----------------------------------------------------------------

In my Crystal Report View:

I will group it by the nric_fin.
I will place the nric_fin in the group section
the detail i will put the contact_c.

would like to make a subreport of the caseNo. so I can place it with the goup with multiples records.

subReport1 = I will display caseNo where ccode = "B"
subReport2 = I will display caseNo where ccode <> &quot;B&quot;


SubReport1 Formula CaseNo =
If {IND_vPROFILE_2.ccode} = &quot;B&quot; then
{IND_vPROFILE_2.CaseNo}

Supress formula =
{IND_vPROFILE_2.CaseNo} = previous({IND_vPROFILE_2.CaseNo})

But I still get:
SubReport1
CASE0001
CASE0005


CASE0001
CASE0005


CASE0001
CASE0005

1) How to suppress the caseNo?
2) why this duplicate happen?

Any better idea on it?
Thank a lot!

 

[lbass]

What do you want your final report display to look like?

-LB

 

[Madawc]

If you're trying to suppress a section on the basis of data that the subreport will find, this doesn't work. There is a work-round, see thread782-477236

Madawc Williams
East Anglia, Great Britain