All Sections Suppression Problem

[reidtw]

Hi,

I'm using CR8 connecting to a SQL Server thru' ODBC.

The object of the report is to reconcile fund holdings between ourselves (US) and our custodian (CUST).

The data is grouped by
1. account type (CUST and US)
2. effective date (constant)
3. security id (variable)

All the fund totals for the values and shares are summed in the group 3 footer.

I then need to remove funds that meet shares and values tolerances and I am using the following formulae: -

If isnull({@Branch B})
and isnull({@Branch C})
and isnull({@Branch D})
and ({@Difference CUST and US Fund Holdings}) <=1
and {@Difference CUST and US Fund Values} < ({@Variabley} / {@VariableX})
then true

else

If (not isnull({@Branch B})
or not isnull({@Branch C})
or not isnull({@Branch D}))
and ({@Difference between Summary and CUST}) <=1
and {@Value Difference between CUST and US Cals} < ({@Difference2} / {@Difference})
then true else false

I will explain the above in more detail if need be, but the fundamental problem is that I need to suppress all sections when the above criteria is met.

The formulae works just fine in the group 3 footer but no where else!!

I inserted a boolean in the detail section that indicated false when any of the above statements was true in the group 3 footer. Note that I have four detail sections but was trying to suppress in the parent detail section, if you know what I mean.

Any help would be much appreciated.

Regards
Trev

 

[Madawc]

Make an extra detail section below the section that the users will see on the final report. See what Crystal is doing with your work fields, which will highlight any errors or faults. Find out what's actually in {@Branch B} etc.

I've done it and found sometimes that data was not what I expected. Other times the running total (or whatever) was at fault.

Putting it as a section is neater because you can delete IT or hide it when you have the problem solved.

Madawc Williams (East Anglia, UK)

 

[lbass]

You have to share the contents of all formulas (including nested ones) if you want further help--but let me guess that you are using running totals in order to calculate the difference between CUST and US values. If you don't have duplicate records, you could instead create conditional formulas like:

//{@CUST}:
if {table.accttype} = "CUST" then {table.amt}

//{@US}:
if {table.accttype} = "US" then {table.amt}

If you use summaries of the conditional formulas instead of running totals, you will be able to use your suppression formulas in other sections.

-LB