Wiki and forms/reporting integration
I am new to Tikiwiki and its features so would appreciate some advice on the best way to configure a particular requirement for an Intranet. Sorry if my description is a bit long-winded.....
All our project teams have a wiki workspace which contains a bunch of static sort of info about their project. Progress reports are also provided by the team leader as file attachments.
I have been asked to provide a page (electronic form) which prompts each team leader for some kpi's. The team leader would submit this info monthly. A report then should be generated which collates all the individual projects results in one multi-line report or spreadsheet. A link to each project's wiki space should be included so that readers can drill down into the project if they are concerned about a kpi. Read access to this report needs to be restricted.
What is the best way to do this so bot the data input and the result is tightly integrated within our tikiwiki? Pointers to tiki features to use / read up on would be greatly appreciated.
Thanks!