Our posts must have crossed, but your assumption was correct and your solution was exactly what I needed. I now understand a little more about CR and how to create certain reports. Thanks for your help.
@hr
if {StudGrades GPAMC.GPA Entry}>=3.5 then 1
//this allows me to count the instances of GPA above 3.5 during a student's 4 years
@sort
{Student.Grade Level Now}+{Student.Last Name}+{Student.First Name}+{Student.Import ID}
//this is used to sort records for 1100+ students
I'm not sure...
I thought of that but neither of my formulas called "count" or "award" appear in the fields that I can select for the cross tab even though they are in the report. The formula "count" is
Sum ({@hr},{@sort} )
that formula is then referenced by the formula...
I have created a formula in CR7 that looks at detail and returns a string value if the number in the formula is a certain value. For example
if {@count}=1 then "Honors Certificate" else
if {@count}=2 then "Honors Medal" else
and so on. My problem is that I also need to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.