Supressing Subreport On Formula

[mabis]

Thank you in advance for any assistance you can provide. I am attempting to conditionally suppress a sub-report based on a T, F value in the main report. The problem is it is suppressing more data than it should.

Running CR10. I have linked two SQL2000 dbs as follows:
QWRIGHT is the sales history database
SALESLOGIX is the CRM database
Common db field to link the two is the account id where:
QWRIGHT=account.account_number and
SALESLOGIX=account_1.accountid (table is set up as an alias due to duplicate name.

GH1=Useridmaster.lastname (salesperson from QWRIGHT)
GH2=account.account_name (account name from QWRIGHT)
GH3=order_header.head_order_nbr (invoice number from QWRIGHT)
Details=sales history data from the orders

This portion of the report runs great offering summary sales data and variance for the last 3 years.

Database expert links back QWRIGHT to a table in SALESLOGIX called retention by
Account.Account_number(QWRIGHT)>account_1.accountid(SALESLOGIX)>contact.accountid(SALESLOGIX)>contact.contactid(SALESLOGIX)>ret_retention.contactid(SALESLOGIX)

Subreport link to field account.account_number (QWRIGHT) with data in the subreport based on account.accountid (SALESLOGIX field in the subreport).

I can add the subreport (sub retention.rpt) to GH2b or GF2b with no issue. But, I want to suppress the report when ret.retention.retention is <> ‘T’

As soon as I add this to suppress the group OR suppress the subreport itself, many of the accounts disappear entirely including GH2, details and GF2.

Using isnull({RET_RETENTION.RETENTION}) or {RET_RETENTION.RETENTION}='F' or {RET_RETENTION.RETENTION}=' '

Again, any help you can provide is appreciated. I hope my explanation is complete.

 

[synapsevampire]

Where are you placing this formula???

The subreport should be in it's own section, then right clich the section and select format section->X2 next to suppress and place:

not({RET_RETENTION.RETENTION} = "T")

-k

 

[mabis]

Im placing it in GFb by itself. When I follow your direction it does suppress when it should. However it is also suppressing GH2 and GH2a and GH2b (where the sub report is) in some cases.

With the supress forumula my total sales numbers are $60,000 short. Strange.

In these cases RET_RETENTION.RETENTION would be null or F.

I need it in GH2 or GF2 to associate to the account.

Thank you,

Mabis