I'm not having any luck with setting up Usage Reporting on this SP 2007 server. I am in Site Settings ---> Site Features and I want to activate the Reporting Feature, but it's not listed. Is there something I need to do before this options is available?

You have to configure to enable Site Usage Reporting

Three Quick Steps to Configure Site Usage Reporting

Try this and let me know

Regards

Enable usage reporting

Activate usage reporting

The exact steps that you take to install and configure the Reporting Services Add-in may vary depending on your requirements. The following are the basic steps.

• Install the add-in using the rsSharepoint.msi file. In a SharePoint farm deployment, the add-in must be installed on each Web front-end server. For more information, see How to: Install or Uninstall the Reporting Services Add-in. The add-in is installed by the SharePoint 2010 prerequisites and if the add-in was already installed, you do not need to use the rsSharepoint.msi.

• In SharePoint Central Administration, configure Reporting Services integration, which includes specifying the URL of the report server to integrate with the SharePoint farm. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration.

• In SharePoint Central Administration, verify the report server integration and Central Administration features are activated under site collection features. For more information, see How to: Activate the Report Server Feature in Site Settings.

• In SharePoint Central Administration, activate the Report Server File sync feature. This feature helps keep items that are manually copies to document libraries, synchronized with the report server catalog. For more information, see How to: Activate the Report Server File Sync Feature in SharePoint Central Administration.

• In SharePoint Central Administration, configure the types of events you want added into the SharePoint Trace log. For more information, see How to: Turn on Reporting Services events for the SharePoint trace log (ULS)

• For each document library, add the three reporting services content types: Report Builder Model, Report Data Source, Report Builder Report. This will make the reporting services options available in the new document list. For more information, see How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

Follow this link also-

http://msdn.microsoft.com/en-us/library/bb326358.aspx

Enable Windows SharePoint Services usage logging

Enable usage reporting

Activate usage reporting

Monitor usage reporting

Usage reporting can be viewed in several places:

• Site administrators, including administrators of the SSP administration site, can view usage reporting for their site by clicking Site usage reports in the Site Administration section of the Site Settings page.

• Site collection administrators can view usage reporting by clicking Site collection usage reports in the Site Collection Administration section of the Site Settings page.

• Site collection administrators for the SSP administration site can view a usage summary by clicking Usage summary in the Site Collection Administration section of the Site Settings page.

• SSP administrators for search can view search usage reports by clicking Search usage reports in the Search section of the SSP home page.

To activate or deactivate Reporting Services integration on a Site Collection

Configure site usage reports in MOSS 2007

Hi Robert,  

Could you please tell me which installation type are you using when installing SharePoint server 2007?

You must select complete installation type, if you choose the front-end Web installation option; you will not be able to run additional services, such as search, on the server.


Do update us again, For further troubleshooting, your issue will be resolved.
Thank you
Anil

Riley,

I appreciate the input, but these are the exact steps I have gone through. When I get to activating the Reporting Feature it's not listed as an option to activate. The features I do see are as follows...

• Office SharePoint Server Enterprise Site Features
• Office SharePoint Server Publishing
• Office SharePoint Server Standard Site features
• Office SharePoint Server Training Features
• Team Collaboration Lists
• Translation Management Library

I'm not sure why it's not in the list... that's my dilemma.

Anil,

The SharePoint server has been in service for a few years now. How would I tell if it was installed as just a web front end?

I am not sure if this works but  you could try activating from command line using PowerShell


eg

stsadm.exe –o activatefeature –name Reporting –url http://sp2010

If your command worked successfully, you will see nothing and just get a blank prompt back.

Try and let me know if this worked

Regards

Just to let everyone know i have done all of this so far and the feature does not show up.

1. Enable Usage Logging in Central Administration

   A. On the Central Administration home page, click Operations.

   B. On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

   C. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

   D. Type a log file location and number of log files to create.

   E. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

2. Enable Usage Reporting on SSP Admin Page 
   

   A. On the SSP home page, in the Portal Usage Reporting section, click Usage reporting.

   B. On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.

   C. In the Search Query Logging section, select Enable search query logging.

1. Activate the Reporting Feature for the Site Collection

A. On the Site Actions menu, click Site Settings.

B. On the Site Settings page, in the Site Collection Administration section, click Site collection features.

C. On the Site Collection Features page, click the Activate button for the Reporting feature.

Hi Riley,

Yep, I did all the step, accept the part where i activate the reporting feature, because it isn't there. That's my issue.

Thanks.

Hi Robert,

I can see that you are working on central administration, that means you have the complete installation type. Well, of course the complete installation does not show such errors, try installing the reporting services, and then see where does it take you.
Follow the link for the same: http://msdn.microsoft.com/en-us/library/ee384252%28v=sql.100%29.aspx

Do update us again and keep disturbing till your problem is not solved.
Thank you
Anil

Hi Riley,

I tried this with no luck. It won't start it. Thanks for the idea.

I re-ran the SharePointRS install and did a repair. It ran through fine, but I still don't see the reporting feature in the list.

Hi Robert,

First of all, Open Up Registry Editor on the server and navigate to the following path

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS



http://technet.microsoft.com/en-us/magazine/ff686706.aspx
http://msdn.microsoft.com/en-us/library/ee384252%28v=sql.100%29.aspx

Thank you
Anil

Hi Anil.

I am attaching a screen shot of my SP Reg string. It's different than what you're pulling, so I'm assuming it's a different install than you have.

Let me know what you think, and thanks for sticking with me on this.

Hi Robert,

It is a Farm Complete installation, what I can see. Also there is no reporting feature.
Go through the article below, it will guide you to integrate the sharepoint reporting with server. Follow the 3rd point carefully. Integrate it and let me know, Then we will move ahead.

Thank you
Anil

Sorry, forgot to attach the link, here it is:
http://msdn.microsoft.com/en-us/library/ee384252%28v=sql.100%29.aspx
Update again.
thank you
Anil