Boolean to Suppress

[c0wt0wn1]

Hi,

I am running CR8.5 on a MSSQL2000 backend.

I developed a report that will only show me items on a person's account that have not been moved for over a year.

There are many employees and when I pull the report I get everyone's name even if they don't have any items that meet the above criteria.


I would like to view only the employees that have items that do meet the above criteria.

Here is the way the report is set up right now.

Group Header 1 : Employee Name
Group Header 2 : Items on account (unique barcode numbers)
Details : Max transaction date

Can anyone help me?

-c0wt0wn1-
MikeGose

 

[lbass]

Go to report->edit selection formula->GROUP and enter:

maximum({table.transactiondate},{table.barcodenumber}) < date(year(currentdate)-1, month(currentdate), day(currentdate))

If this doesn't give you the results you are looking for, please explain what you mean by "items on a person's account that have not been moved"--I don't know what you mean by "moved", but assumed that you meant there was no recent activity and therefore no newer transaction date.

Also please show a sample of your data and a sample of your desired results.

-LB

 

[synapsevampire]

If you want to see all items that are over a year old, as opposed to LB's solution which shows all items only if the newest is over a year old, try something akin to the following in the Report->Edit Record Selection->Formula:

{table.date} < date(year(currentdate)-1, month(currentdate), day(currentdate))

Keep in mind that trying to describe data and requirements will net speculative answers, try posting example data and expected output so as not to leave so much to the imagination.

-k