Skip to Content
0
Former Member
Jul 16, 2009 at 09:07 PM

Groups / Details Issue? Advice?

24 Views

Hi All,

I have a SQL stored procedure that returns a large volume of data about students. Eg grades,comments,homework stuff like that.

The report is setout as below:

GroupHeader which just contains text labels(grouped on StudentID)

SubjectName Target Est Homework

Details Section (database fields)

Subjectname target est homework

GroupFooter

Just text that explains about the grades

So far the report looks like this:

SubjectName Target Est Homework

Art A C Average

Music A A Good

Science C D Poor

"Text just explaining about the grades and Stuff"

What i need to do is now have a page break after the report footer so that i can display a breakdown of the subjects. So on the next page i need to display:

Art

"a bunch of text from the teacher saying how well or poor he/she is doin"

Music

"a bunch of text from the teacher saying how well or poor he/she is doin"

Science

"a bunch of text from the teacher saying how well or poor he/she is doin"

Then the report will go onto the next student.

I have managed to acheive this using a subreport on the next page but this is impractical as i'm passing StudentID from the main report to the subreport and then passing that StudentID onto a stored procedure to select on. If there are 1000 students thats a 1000 calls of the procedure and a 1000 selects.

All the information i need is in my very first stored procedure so if i can some how do a non-nested 2nd group or do an additional details section after the group footer? I'm running out of ideas for this.

The way i have it at the moment is if i supress the subreport effectivly just giving me the front sheet for every student it runs instantly. But if i unsupress and have the summary breakdown page as well the report is taking 10minutes plus to run.

Sorry this is long but trying to make it as clear as possible as i'm at a loss.

Thanks for any help adive,

Dave.