AnsweredAssumed Answered

Scripted Search

Question asked by TerryTaylor on Jun 22, 2015
Latest reply on Jun 22, 2015 by philmodjunk

Title

Scripted Search

Post

Hello everyone, wondering if someone can please help me on this one, I am trying to create a script that will do two things on 20 different fields... First off my DB has a Field for "instructor" which is a list of 5 people and date feild that is a pop up calender. these two lists are used over and over again on each record on the 20 fields I have:

Student Name

Skill    Instructor    Date

------------------------------------

Skill1 Instructor     Date

Skill2 Instructor     Date

Skill3 Instructor     Date

Skill4 Instructor     Date

 

What I am trying to do is run a report that will have the instructor name:  then the student's name, and a list of the skills and dates that he/she has done within each record. then print the next instructors name, then the student's name, and a list of the skills and dates that he/she has done, repeat, repeat... I also don't want to print empty fields.

 

What I have been able to do is create global fields to find the date range that I am looking for, but I can't get the report to run, everytime it shows all the fields even though they are not the correct dates because it is matching the date on a previous skill.

 

Thanks for any help on this.

Outcomes