Question

I want to write a formatted search (recursing through several subwebs) that produces a crosstab table output that shows for each sub web as a separate column.

I have a sub web for each department and I want to produce a matrix showing all projects being undertaken by the department that support a specific strategy. The strategies are attached to each topic via a form. Some sub-webs will have a null result of projects for a certain strategy.

I have the formatted search the produces all necessary data but can't workout how to convert the output to a crosstab.

Is this possible and how do I do it?

Environment

-- JeffMahoney - 04 May 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

You can put each web's search result into an HTML table cell. Put the closing and opening td tags in the header="parameter" of the FormattedSearch. Example (edit to see how this works):

-- PeterThoeny - 07 May 2006

Thanks Peter, I really appreciate the very quick response.

This works well and I will use this but was not quite what I was after.

I have used a formfield to capture which strategy each project support.

Below is what I was after :

-- JeffMahoney - 08 May 2006

Assuming the WGs are webs, and the Projects are topics with a common TWiki form, you can issue three SEARCHes, one for each Strategy. The header defines a cell boundary, the sparator for each project is a comma, a %BR% or a %BB%. Not sure though if it is possible to generate a TWiki table across webs, you might need to generate a standard HTML table.

-- PeterThoeny - 10 May 2006