I have a view that pulls information from several tables using joins. In the detail band of a report, I need to print two different types of information. I need to print all of the records for info type 1, and then print the records for info type 2. I know how to do this when type 1 and type 2 are in different records, but in my current scenario both types are in the same record. I believe what I want is referred to as a "sub-report" in other report engines, such as Crystal. I'll separate the data into separate records if I need to, but I want to know if there is another way using the data that I have.
Thanks,
Joel