Section Suppression

[Ragnarox]

Hello all,

I have a two column report that has 4 detail fields. The first one holds a name and email address. The next three hold licensing information. The licenses expire at different times and they can have more than 1 ( we currently keep track of 3 ). The problem that I am having is as follows :

Person #1 : License 1 Expires 04/01/2006
License 2 Expires 01/01/2005

Person #2 : License 1 Expires 02/01/2005

We are looking for all licenses that expire betwenn 01/01/2005 and 03/31/2005.

What happens is that the first person has both of their licenses printed out even though only the second one should be. I believe this is because the second person's first license has expired and so becuase it has to print Detailb it prints it for both columns even though that is not what i am wanting.

So in a nutshell - Is there a way in CR9 to get a detail section to be suppressed for one column and not for the next so that this does not happen? Or do I need to find another way to just get the info to print out?



Any help, as always, is greatly appreciated.

Brian

 

[synapsevampire]

Rather than suppress the data, eliminate it from the report using Report->Edit Selection Formula->Record:

{table.expiredate} in cdate(2005,1,1) to cdate(2005,3,31)

You might also create a date range parameter in the report and have the report prompt for the date range, and then use:

{table.expiredate} in {?MyDatePrompt}

-k

 

[MrBillSC]

By your post, it sounds as though the three licenses are in the same record. You must be checking all three field in your record selection formula in order to find customers with an expired license.
If this is correct, you can conditionally suppress field by right clicking on the field and selecting "format field". On the "common" tab click the "X-2" button across from the "suppress" check box and enter a formula for suppressing the field:
// example for suppressing a date field
Not ({table.expiredate1} in {?MyDateRange})

or if your dates are hard coded:
{table.expiredate1} < Date(2005,01,01) or
{table.expiredate1} > Date(2005,03,31)

MrBill