how to check for details values of a field within the same group

[johnjrd]

Hope someone can help with this

I have a report which is grouped by a students learner no.
and then showing various details about the enrolments for that learner.

However I only want to show all learner details if

a) the funding field is set to code 70

(it is possible that a learner will be doing multiple enrolments with each having different value in the funding field. I am after all enrolments for a learner if one of those enrolments is set to code 70)

So i need the output to look something like this

Group 1 Learner Code
L1
Surname, Forename, Funding, Course Code
Bloggs Fred 70 C1
Bloggs Fred 20 C2

I get the feeling this is simple but i have a mental block at the moment, so any help would be great

thanks

 

[lbass]

Create a formula {@funding70}:

if {table.funding} = 70 then 1 else 0

Place this in the details section and suppress if you wish.

Then go to report->edit selection formula->group and enter:

sum({@funding70}, {table.StudentLearnerNo}) > 0

This will return those students and all their funding sources if one of the funding sources = 70. Please note that you will need to use running totals, not the more usual summaries, for additional calculations, since the non-group selected records would still be counted in the usual summaries.

-LB

 

[johnjrd]

thanks it worked great, however i just summed up the formula and the filtered as you suggested. I also put in a summary to count the number of enrolments so i could stop where a learner with just with 1 code 70 enrolment being pulled out of the report

thanks again