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 have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list 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