Suppress Records

[former_member406941]

In relation to this thread:

I now have a report where I'm selecting records Year-to-Date and at the end of the report I have summaries for YTD and Month-to-Date to date as well. 

I want to now ONLY show the MTD records in the details within this report.  I've so far successfully created new MTD formulas for all the fields in the details...for example: 

IF {Billing_Data22.Date Bill Paid By Client} IN MonthToDate then

     {Billing_Data22.Total State Allowable}

etc., etc, for all the fields within the details of the report. 

The issue now is that there are still records showing up as either zeroes or blanks, towards the beginning of the report.  These are obviously the records that do not fall in the MTD.  How do I now suppress these?

Thanks!!

Rich

[abhilash_kumar · Accepted solution]

Hi Rich,

You can easily suppress them by entering a conditional suppression logic however, do you also want to get rid of the space that they leave so that non-zero fields take their place?

-Abhilash

[former_member406941 · Accepted solution]

Yes.....I put in the conditional suppression logic of "Suppress if Zero" so now there's just blank spaces and no zeroes.  I want them to simply NOT show up on the report so there's no blank spaces.....and the other records 'take their place' as you're saying.  Thanks!

[abhilash_kumar · Accepted solution]

Rich,

This could get extremely difficult!

Here's an example:

-Abhilash

[former_member406941 · Accepted solution]

Oh boy.  Thanks for the link.  There are a lot of records to be 'replaced' so to speak, this would be somewhat grueling to attempt I think.  So would a SQL query make this cleaner you think?

[former_member406941 · Accepted solution]

Abhilash,

I had someone else figure this out with a much cleaner solution.  I'd share with you all.  The grouping formula was amended to the following:

IF {Billing_Data22.Date Bill Paid By Client} IN LastFullMonth

then {@InsName}

else "Hidden"

Then, a group selection formula was created to 'hide' these records:

Maximum ({@Month_InsuranceName},{@Month_InsuranceName}) <> "Hidden"

To correctly count these, a blank formula was created {@NULL}.  I then needed to amend all the formulas on the fields to in include this in the IF-Then-Else statements, so for example:

IF {Billing_Data22.Date Bill Paid By Client} IN MonthToDate then

     {Billing_Data22.Total State Allowable}

else Val ({@Null})

Thanks again for all of your help!!

Rich