Hi
I’m attempting to build a report that displays person data by their job and their job start date and then using an excel spreadsheet that lists each applicable course for that position. The spreadsheet lists a value which corresponds to the number of months in which that course must be completed by.
The spreadsheet looks as follows:
Position Course Value
When I return both data providers and link on Position I’m hoping to get multiple rows for each position where their position has multiple courses.
Ie Person Id Course Value
1 A 2
1 B 3
1 C 3
2 A 2
The data is not coming out like this, instead I’m getting one course returned many times and the remaining courses only once…
Any ideas how I can achieve this or how I can amend the underlying data source?
Cheers
Ben
bhall22275 (BOB member since 2005-08-17)