Duplicate Records...Sort of.... 1

[ChiTownDiva]

Afternoon All...

I have duplicate records...sort of...in the details...

Date City Location Time Ses Code
1/14/2004 GA Atlanta 1234 S. 10th St .5 ABC1730
1/14/2004 GA Atlanta 1234 S. 10th St. .5 ABC1731
1/15/2004 GA Atlanta 1234 S. 10th St. .5 ABC1732

I need to be able say that the combination of Date, city, and location is a count of two or more sessions on one day.

If a user selects es to the parameter {Single Half Day Session?}, the only session they will be able to view is:

1/15/2004 GA Atlanta 1234 S. 10th St. .5 ABC1732

If they select o to the parameter, the user will see all three sessions.

I created a formula called {@Count} where count is

text({Date})+totext({Location})+totext({Room})+totext({City})

In the section visibility of the details, I have...

Count ({@Count}, {@Count}) >= 2 and {?Single Half Day Sessions?} = 'Y'

I don't know how to hide the "duplicate" sessions...it either hides too many records or not enough.

Any help would be greatly appreciated.

Thanks in advance

ChiTownDiva

 

[lyanch]

You post is a littke confusing but if you mean if they say yes they need to see *one and only one* of the two similar rows (ie when they choose yes they should see two rows your example and three if they choose no)

For the detail line in the suppression formula x->2 place the following:

{@Count} = previous({@Count})


Lisa

 

[nagornyi]

You don't need count. Just create group by your

text({Date})+totext({Location})+totext({Room})+totext({City})

formula and put the fields both in the group header and in the detail section. Then if parameter NO, supress group header, if YES suppress detail section.

 

[ChiTownDiva]

Thanks Nagornyi, it works like a charm !!!

Oddly enough, I did have a group for the "text({Date})+totext({Location})+totext({Room})+totext({City})", but because I added the count, that's what was throwing it off.

Thanks again for your help!

ChiTownDiva