link one output field to another summary field

[scottaherbst]

Hi all,

Im using CR 10.

In my details section, the first thing that I list is the start date of services for a client. Sometimes, a client gets more than one service and I am listing each one.

The second thing I list is the date a test was given during those services. Often, the assessment is given more than once and I want to list each time it was. No problem there. I am also listing the score on the test. Sometimes, no test was given, and it is important for me to list those as well.

Here's my problem. In the group header, I want to have a field that tells me what the date for the most recent test was and what the score of the test was. The way I have been listing the date is to make a summary field for the date with the criteria of maximum. What has me at a loss is how to display the corresponding score in a different field.

Let me know if this is unclear. Thanks, Scott

 

[lbass]

You could write a formula like:

if not isnull({table.testscore}) then
totext({table.testdate},"yyyy/MM/dd") +
" " + {table.testscore})

Then insert a maximum on this. You would need to format the date as shown, however, for this to work.

-LB