Im wondering if anyone can help me as I seem to be stuck…
We have a training database, 3 forms, person, course details and person course. The person course is a record created to specify someone has been on a training course taking information from the course document (duration, certificate details, expiry) and employee document on creation.
Previously we have displayed this in notes views and had an export to excel agent option. The export to excel lists all the courses across the top row, all the employees down the first column and then the ‘matrix’ is populated with the course dates of when the employees went on what courses. So one row would show an employee and you could read along and see all the courses they have attended.
I am trying to migrate this into xpages but would like to produce this ‘training matrix’ within the xpage as opposed to an excel output.
I am a bit stuck to say the least…
so … Should I :
-
Be trying to change my export agent to write into an xpage instead of export to excel (and how would I do this?) or
-
Should I be trying to use repeats within repeats . I have tried this without success wrapping around TD’s in a table to create columns for the courses…
Sorry if this is difficult to understand, I don’t think I have explained this very well!
Any advice appreciated