Hi everyone.. I'm new to this forum and I joined because I can't find any other solution for this problem i have. First of all, I'm using Crystal Report 8.5

I want to create a report to display an academic transcript. We are just migrating from oracle report and want to do it using crystal report. The example of the transcript is shown on the image below... I have no problem displaying the top half of the report. The problem I have is with the small table below, which supposedly display the subjects for a particular student which have grade "D" or "E"... The data supposedly taken from the list above and filter the grade to be "D" or "E".

I have tried many different approaches... Some of them are:
- I tried using subreport. I made a subreport with the same ttx (from same stored procedure) as the main report and I filter the grade
- I tried using subreport. I made a subreport with different set of stored procedure but I linked the student ID parameter from the main report to subreport.
- I put the subreport on the group footer section of my report and it only display 1 record each time.

Can anyone point me in the right direction on how to make this report to work? I'm using SQL server btw.

Thank you for your time and help...




Edited by slyth - 07 Apr 2010 at 10:51pm

First off, yes I think I would use a subreport (the best bet is to use the same query).  But you would have to put the sub report in a group footer (student ID?), unless you are filtering so that you one have one student per report then you could put it in the report page footer.   Then you would have to work out how to link the main report and subreport (student ID?).

Hi,