I have a daycamp that has kids attending camp for multiple weeks. On the first week that they attend camp, they get a t-shirt. So, I need to calculate their first week of camp for all weeks in order to give them a shirt.
Child 1 is attending week 1,2,3,4,5
On Week 1, T-shirt = True
On Week 2-5, T-Shirt = False
child 2 is attending week 3, 5, 7
On Week 3, T-shirt = True
On Week 5, T-shirt = False
On week 7, T-Shirt = False
I need to give a report each week that shows the kids who need to get a shirt.
Sounds like a highschool word problem.
This is reporting in Crystal Reports, but I'm thinking I can do the evaluation in SQL and then pass the results to crystal?