Hi, I need help.
I had 3 tables, user, schedule and detail_schedule

User :
ID_User, Name

Schedule:
ID_Schedule, Date, Location

Detail:
ID_Detail, ID_Schedule, Activity

I wanted to make report design like this :




*The activity row at report output is empty

How to generate column activity header dynamically , values base on table detail ?
If at table had 5 value, so at the report it generate activity 1-5.

Any reference or source ?

Thanks




Edited by jipo - 17 Jan 2009 at 1:28am