Supressing data 1

[Jazztpt]

First off I am new to Crystal, I have some experience with Access but am by no means an expert.

Here is what I can do and what I need to achieve:

I can extract customers and their recorded transactions.
I can group transactions by each customers name.
I can apply a date range parameter.

Each customer has an initial trial period of 13 weeks which offers a concesionary price for limited activities.

I want to report on the transactions for each customer during their 13 weeks concessionary period i.e suppress transactions which are outside their 13 weeks.

Of course each customer has their own start and end date:

Customer name Start date (end date)Start date + 13wks

For each customer I need to show all transaction in their 13 week period based on their own unique Start date and end date or suppress transactions outside those dates. Is this possible?

Hope it is clear what I am after.
Thanks in advance
Jazztpt

 

[synapsevampire]

Rather than speaking of suppression, you should be concerned with filtering the rows to only retuyrn what it is that you require.

To do this use the Report->Select Formulas->Record and place something like:

{table.transdate} in {table.startdate} to {table.unddate}

Obviously your table designs will differ, so you should post relevant information:

Crystal version
Database/connectivity used
Example data (show the columns and some data)
Expected output (as a result of your business rules applied to the example data).

-k

 

[Jazztpt]

Many thanks for the reply, I'll give that a go and come back if I need more help.
Jazztpt

 

[Jazztpt]

Hi - hoping I could get a bit more help. I have managed to filter my records by the customer concessionary period using:
{CustomerType.CustomerType} = {?Customer Type} and
{CustomerType.DateJoined} in {?First Date} to {?Second Date} and
{Transaction.TransDate} in {Customer.DateJoined} to {CustomerType.NextRenewal}

I now need to look at transactions which are outside the concession period ( i.e. not between datejoined to Nextrenewal)

I thought 'NOT or NOT IN' but that didn't work.
Thanks
Jazztpt

 

[kskid]

The Proper use of Not is

Not(
{Transaction.TransDate} in {Customer.DateJoined} to {CustomerType.NextRenewal}
)


Cheers,
-LW