Custom Fields - how to report from them

[Steve]

I have created some additional fields to be used for Issues. When I try to
create a SQL Reporting Services Report from them, I cannot find them in the
WSS Issue table in the Reporting Database - how do I therefore report from
them?

 

[.jussi]

Hi Steve,

I gather you mean that you have created additional issue columns in the
sharepoint site. To my knowledge these columns do not get propagated to the
reporting database, they only exist in the WSS content database which of
course makes reporting on them rather problematic.

For enterprise custom fields, the *_UserView -views in the reporting
database contain the custom fields as well and the views get automatically
updated as you add or remove enterprise custom fields. The issue columns
(which are sharepoint content columns) are a very different construction from
the enterprise custom fields (which are part of the project structure).

Hope that helps.
- Jussi

 

[Steve]

thanks

Hi Steve,

I gather you mean that you have created additional issue columns in the
sharepoint site. To my knowledge these columns do not get propagated to the
reporting database, they only exist in the WSS content database which of
course makes reporting on them rather problematic.

For enterprise custom fields, the *_UserView -views in the reporting
database contain the custom fields as well and the views get automatically
updated as you add or remove enterprise custom fields. The issue columns
(which are sharepoint content columns) are a very different construction from
the enterprise custom fields (which are part of the project structure).

Hope that helps.
- Jussi