Conditional Suppress in Grouping 1

[jdaily]

I have a problem with my grouping and needing to suppress certain data. There are too many codes to enter into Select Expert but can be done.

Using CR 8.0 on Win98<-(don't ask)

I am trying to suppress certain data from my groupings.

I have two groups that I need specific data suppressed from out of a total of 7 groups. Here is the formula that I have (which isn't working):

I have tried this formula in the detail section and group section under format section in Suppress (No Drill Down).

// If the financial class is K or Q in the Responsible_Dept
// Billing Errors or Coding Issues, then suppress accounts
// with finacial class K or Q, otherwise
// show the K or Q accounts.

If {Do_Not_Use_-_Denial_Codes.responsible_dept} = [&quot;Billing Errors&quot;, &quot;Coding Issues&quot;] and
{Patient_Information.fin_class} = [&quot;K&quot;, &quot;Q&quot;] Then
Not ({Patient_Information.fin_class} in [&quot;K&quot;, &quot;Q&quot;])
Else
({Patient_Information.fin_class} in [&quot;K&quot;, &quot;Q&quot;]);

I only need to supress the K or Q if in those 2 dept's on the report.

Any help will be greatly appreciated!

Thanks in advance!

John

 

[Ngolem]

Try this in the conditional suppress for all appropriate sections

If {Do_Not_Use_-_Denial_Codes.responsible_dept} in [ &quot;Billing Errors&quot;, &quot;Coding Issues&quot; ] and
{Patient_Information.fin_class} in [ &quot;K&quot;, &quot;Q&quot; ] Then
True
Else
False;


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[jdaily]

Thanks Ngolem! It works great except that my subtotals don't come out right. They are still adding the original information.

What should I do?


Thanks!

John

 

[Ngolem]

you are probably using summary functions to do this .... yes?

Why do we always have to guess at the report structure???

If this is so you will have to use formulas to do your adding and put the conditions for suppression of the sections in to the formula to not add those components

If I have GUESSED wrong show how the subtotals are calculated

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[jdaily]

Jim,

You are right about the summary functions. I am very new at programming, do you have any suggestions for me to do the subtotaling and adding the suppression formula in the subtotal formula also?

Thanks!

John

 

[Ngolem]

Again...no details...so

Set Guess mode ON

Do a 3 formula sum

in the group header or report header if this is done only once, place the following formula

//@init (Suppressed)[\b]

WhilePrintingRecords;
//this is for 2 totals calculated...you can adjust accordingly
NumberVar Total1 := 0;
NumberVar Total2 := 0;

In the detail section

//@CalcSum (Suppressed)[\b]

WhilePrintingRecords;
//this is for 2 totals calculated...you can adjust accordingly
NumberVar Total1 ;
NumberVar Total2 ;

If {Do_Not_Use_-_Denial_Codes.responsible_dept} in [ &quot;Billing Errors&quot;, &quot;Coding Issues&quot; ] and
{Patient_Information.fin_class} in [ &quot;K&quot;, &quot;Q&quot; ] Then
(
Total1 := Total1;
Total2 := Total2;
)
Else
(
Total1 := Total1 + {Table.value1};
Total2 := Total2 + {Table.value2};
);


Now in the footer place the display formulas

//@DisplayTotal1

WhilePrintingRecords;
NumberVar Total1 ;

Total1 ;

Similar for Total2

Set Guess mode OFF

I hope I have guessed right...think so.



Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[jdaily]

Thanks again Jim!

Here's what I did:

Local numbervar SumAcctBal;

If Not({Do_Not_Use_-_Denial_Codes.responsible_dept} in [ &quot;Billing Errors&quot;, &quot;Coding Issues&quot; ] and
{Patient_Information.fin_class} in [ &quot;K&quot;, &quot;Q&quot; ]) Then
SumAcctBal := {Payment_Info.acct_bal};

I inserted another detail line under the original and suppressed it. Then did insert subtotal and grandtotal.

This worked out really great!

Thanks for your suggestions.

John

 

[Ngolem]

only one other suggestion.....don't use Local...numberVar by itself defaults to Global (available throughout the report). But Local is just for that formula.



Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!