Suppress Detail prior to date

[itsuit]

I'm trying to suppress the details of records with dates prior to 5/1/2002, using the following formula to format my Detail Section/Suppress:

{CLAIM.CLS_DATE} <= Date(2002, 04, 30)

However, this suppresses ALL claims with entries in the CLS_DATE field, not just those occurring prior to 5/1/2002.

Any suggestions? Thanks!

Kyle

 

[Guest_imported]

Use the Select Expert to display the dates u want to see. It works all the time. U can specify the dates u wish to be eliminated from your detail display. I try to use the Select Expert to do the job for me as they ahev the <= >= features there.

 

[rosemaryl]

Dear ITSUIT,

This should work. I just tested to double check.

Do you have a Record Selection (Select Expert) that could be excluding data?

If you remove this suppression formula, do the records show as expected with dates occurring before and after the date you indicated?

What version of Crystal?

Please provide more info and I will try to help,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[itsuit]

Rosemary -

I don't have a Record Selection formula that would be influencing this operation. Removing the suppression formula shows all data. I'm using CR6.

Thanks for any help.

 

[dgillz]

Is there a reason why you are suppressing data instead of writing a record selection formula?

If not, get rid of the suppression formula and write a record selection formula, its much easier to deal with. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rosemaryl]

Dear ITSuit,

Are you sure?

I am assuming that you have a reason for needing the records outside that daterange in the report and that is why you have chosen not to use a record selection formula.

I haven't used 6.0 in a while, but it shouldn't matter.

I believe in 6.0 the CurrentDate was something like NOW(), if not CurrentDate should be there.

Try excluding records like this, just to test.

{CLAIM.CLS_DATE} <= Now()-30

Does that give a different result?

Also, test if placing your formula in your Record Selection formula produces the same result?

Hope this helps, we just have to keep trying until it works.


Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.