Suppressing Group Data based on Date

[jconway]

I have account transactions grouped on Account Number in my report. There can be anywhere from 1 to 10 transactions for each account, with different dates. I want to show all transactions for any account that has at least one transaction in the past week. I'm trying to come up with the best way to accomplish this and am looking for suggestions.

Example

1 3/1/10 Pmt $100
1 3/15/10 Adj $50

2 1/15/10 Pmt $200
2 4/10/10 Pmt $200

I want to see nothing for account 1, and everything for account 2.

 

[Madawc]

Add the dataset twice, the first selected for this week. Link by account number. Show data from the second table, the 'alias'.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

Create a formula {@pastweek} like this:

if {table.date} in currentdate-6 to currentdate then 1

...or you could use "in lastfullweek" if that is your intent.

Then go to report->selection formula->GROUP and enter:

sum({@pastweek},{table.accountno}) > 0

-LB