Start a Group with a Specific Value - Need Help!
I am creating a report with has the following data fields in Crystal Reports XI:
ID
Name
Program
Enter Date
Exit Date
I have a prompted parameter to pull anything from the Enter Date to the Exit Date. I also have the report Grouped by ID Number
Each ID may have multiple entries with many different programs. Especially if my parameters are for over a month. So I may get some data like this:
001
001 - John C. - ARP - 7/1/2010 - 7/05/2010
001 - John C. - DTX - 7/06/2010 - 7/15/2010
001 - John C. - RHB - 7/16/2010 - 7/19/2010
001 - John C. - INT - 7/20/2010 - 7/31/2010
OR - some may just display with one field like this:
002
002 - Katie M. - RHB - 7/1/2010 - 7/15/2010
OR - some may display results like this with nothing related to the DTX Program:
003
003 - Doug H. - RHB - 7/1/2010 - 7/7/2010
003 - Doug H.- ARP - 7/8/2010 - 7/12/2010
003 - Doug H. - INT - 7/13/2010 - 7/15/2010
003 - Doug H. - BCB - 7/16/2010 - 7/19/2010
What I want my report to do is only pull the ID clients starting with the DTX value, and listing anything that have been entered after that date, and if they dont have the DTX value at all, have them supressed. So from the data I provided above, I would get results like these below:
001
001 - John C. - DTX - 7/06/2010 - 7/15/2010
001 - John C. - RHB - 7/16/2010 - 7/19/2010
001 - John C. - INT - 7/20/2010 - 7/31/2010
Any ideas?
I am creating a report with has the following data fields in Crystal Reports XI:
ID
Name
Program
Enter Date
Exit Date
I have a prompted parameter to pull anything from the Enter Date to the Exit Date. I also have the report Grouped by ID Number
Each ID may have multiple entries with many different programs. Especially if my parameters are for over a month. So I may get some data like this:
001
001 - John C. - ARP - 7/1/2010 - 7/05/2010
001 - John C. - DTX - 7/06/2010 - 7/15/2010
001 - John C. - RHB - 7/16/2010 - 7/19/2010
001 - John C. - INT - 7/20/2010 - 7/31/2010
OR - some may just display with one field like this:
002
002 - Katie M. - RHB - 7/1/2010 - 7/15/2010
OR - some may display results like this with nothing related to the DTX Program:
003
003 - Doug H. - RHB - 7/1/2010 - 7/7/2010
003 - Doug H.- ARP - 7/8/2010 - 7/12/2010
003 - Doug H. - INT - 7/13/2010 - 7/15/2010
003 - Doug H. - BCB - 7/16/2010 - 7/19/2010
What I want my report to do is only pull the ID clients starting with the DTX value, and listing anything that have been entered after that date, and if they dont have the DTX value at all, have them supressed. So from the data I provided above, I would get results like these below:
001
001 - John C. - DTX - 7/06/2010 - 7/15/2010
001 - John C. - RHB - 7/16/2010 - 7/19/2010
001 - John C. - INT - 7/20/2010 - 7/31/2010
Any ideas?
Last edited: