What are you grouping on? Student? Course? Both? Other maybe?

Have you managed to produce the desired report, despite not having any filters set in place?

It would be nice if the filtering was completely separate from the data itself so you could tackle that once you know you have at least everything you need.

Judging from the first couple lines, you probably won't be able to get it in one report. Unless those U's and C's and I's and T1's are hardcoded. Then it might be possible depending on your query.

Anyways in your subreport you will have a reference to {?LastName} (which I guess should be student ID?)

This value would be sent from the master report as a subreport link cause a different ID would be sent at each separate page of the report (since it goes down the list of ID's retrieved from the DB).

The subreport would only show the student with this ID at that specific instance, effectively producing distinct results for each page.

Edited by Keikoku - 27 May 2011 at 2:49am

Switched my Sub reports to use

Ok I am not 100% sure this is what you are asking for however I have taken some screenshots of the tables I am using.

Edited by Shawnlo - 30 May 2011 at 9:09am

Hi Shawn -

Here are a few thoughts for you to think about.

First, in your post to me you mentioned null values messing up your formula. This is because when a formula has a null value in it, it will force the entire formula to return False no matter what. To get around this problem you need to test the value for Null as the first part of the formula If IsNull({table.field})....  But an easier way to handle nulls is to set the report property that tells Crystal Reports to convert nulls to their default values (a Null string becomes the empty string ''). (File > Report Option > Convert Database Nulls). You may still need to check for '', but at least it won't force the entire formula to go to False every time there is a null field in the data.

Next, I think the problem you are getting with the subreports is called a Cartesian Product. This frequently happens when the subreport isn't joined to the main report on a unique field. The fields in the subreport will match too many fields in the main report and you get tons of extra rows which are meaningless and redundant. You have to go under the suberport dialog box and choose the linking options tab to set which field in the main report should be joined with which field in the subreport. Picking the correct field is critical for clean data.


Brian


Edited by BrianBischof - 30 May 2011 at 8:54pm