Need to return all records in group... 1

[HiHeidi]

I have selection criteria based on a date parameter. I have a group of records that I need to return. Each record key contains the same last 6 digits with the first 3 digits representing the status of that records. I have grouped on the last 6 digits of the record. Each records contains a date/time stamp. I want to return the entire group when at least one of the records in that group contain the time stamp within the set parameters. I have not found a way to do this. I have running totals and counts that are not working because certain records are missing from the group. HELP! Thanks!

Heidi

 

[kenhamady]

This is tricky, but follow these 3 steps and you can do what you are asking to do:

1) Create a formula called {@test}:

if {date} in {?start} to {?end}
then 1
else 0

2) subtotal this new formula for each group

3) Put in a Group Selection formula:

Sum( {@test}, {Group.field}) > 0 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[HiHeidi]

I will see if this works. I'm thinking I tried that.. I do know I did a group selection. What we ended up doing is writing a UDF to import the records. The problem is with the database, not with crystal. Thanks for your response!

Heidi