crystal report printing problem

I'm not sure if this is the best way.... But if I were doing this....I think I'd do all of the logic in the C# program. Mostly because I hate trying to find the code inside a crystal report and it's harder to maintain or compare changes than in the regular code. And because I don't know how you would do it IN the report.

In the Crystal Report, I'd design it to have two detail sections. One that prints Side A of a student's card and one that prints Side B. Each detail section would suppress based on a code field in my datasource. Each detail section would have 2 cards on it.

My data source table would have a column to track which detail section should show, and then two columns for each bit of information that is printed on the front of the card and two columns for each bit of information that is printed on the back.

In the code I would create an empty table that matches the expected crystal report schema, lets call it dtFormat. I would pull data from my database in a second table, lets call it dtStudentInfo. I'd loop through dtStudentInfo and for each 2 students I would create a new row in dtFormat and fill in the side 1 information columns. So the first row of dtFormat would have something like this:
SideA, Student1, StudentId1, StudentPhoto1, Student2, StudentId2, StudentPhoto2

After that, I'd loop through dtStudents again. For every two rows I would create a new row in dtFormat and fill in the side 2 information columns...making sure to enter it somewhat backwards....so that the students are flip flopped and will match if you print it on the back
SideB, Student2, StudentId2, StudentPhoto2, Student1, StudentId1, StudentPhoto1

Then pass dtFormat to the crystal report.

So, yeah. It's kind of a lot of work, so I'm not sure if it's the easiest possible way. But it's one method you could try.