SharePoint - SharePoint 2007 - Reporting Site Feature not available

Asked By Robert Hartman on 17-Nov-11 02:57 PM
Earn up to 50 extra points for answering this tough question.
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?
Riley K replied to Robert Hartman on 17-Nov-11 09:08 PM


You have to configure to enable Site Usage Reporting

Three Quick Steps to Configure Site Usage Reporting

  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.
  3. 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.
Try this and let me know

Regards
Jitendra Faye replied to Robert Hartman on 17-Nov-11 10:49 PM

Enable usage reporting

After Windows SharePoint Services usage logging is enabled in the server farm, SSP administrators must enable the usage reporting service. SSP administrators can control the complexity of usage analysis processing, and select whether or not reporting is enabled for search queries.

Use the following procedure to enable usage reporting.

Enable usage reporting

  1. On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting.

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

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

  4. Click OK.

If advanced usage analysis processing is not selected, usage reporting statistics will be minimal.

For information about how to perform this procedure using the Stsadm command-line tool, see Usage Analysis: Stsadm properties (Office SharePoint Server).

Activate usage reporting

After usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available.

Use the following procedure to activate the reporting feature.

Activate the reporting feature

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

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

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

    For information about how to perform this procedure using the Stsadm command-line tool, see Usage Analysis: Stsadm properties (Office SharePoint Server).

Follow this link-

http://technet.microsoft.com/en-us/library/cc262541%28office.12%29.aspx#section3

Jitendra Faye replied to Robert Hartman on 17-Nov-11 10:49 PM

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.




Follow this link also-

http://msdn.microsoft.com/en-us/library/bb326358.aspx
Vimal Sharma replied to Robert Hartman on 18-Nov-11 12:38 AM

Enable Windows SharePoint Services usage logging

Before you can enable usage reporting in a SSP, you must first enable Windows SharePoint Services usage logging for the farm hosting the Web application containing the SSP.

Use the following procedure to enable usage logging for the farm.

Enable usage logging for the farm

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

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

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

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

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

  6. Click OK.

    For information about how to perform this procedure using the Stsadm command-line tool, see Usage Analysis: Stsadm properties (Office SharePoint Server).

Enable usage reporting

After Windows SharePoint Services usage logging is enabled in the server farm, SSP administrators must enable the usage reporting service. SSP administrators can control the complexity of usage analysis processing, and select whether or not reporting is enabled for search queries.

Use the following procedure to enable usage reporting.

Enable usage reporting

  1. On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting.

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

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

  4. Click OK.

If advanced usage analysis processing is not selected, usage reporting statistics will be minimal.

For information about how to perform this procedure using the Stsadm command-line tool, see Usage Analysis: Stsadm properties (Office SharePoint Server).

Activate usage reporting

After usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available.

Use the following procedure to activate the reporting feature.

Activate the reporting feature

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

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

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

    For information about how to perform this procedure using the Stsadm command-line tool, see Usage Analysis: Stsadm properties (Office SharePoint Server).

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.

Suchit shah replied to Robert Hartman on 18-Nov-11 01:01 AM

To activate or deactivate Reporting Services integration on a Site Collection

  1. Click Site Actions.

  2. Click Site Settings.

  3. Click Site Collection Features in the Site Collection Administration Group.

  4. Find Report Server Integration Feature in the list.

  5. Click Activate.

Suchit shah replied to Robert Hartman on 18-Nov-11 01:07 AM

Configure site usage reports in MOSS 2007

1) Configure site usage reports in Central Administration
Go to, Central Administration > Operations > Usage Analysis Processing

Usage Analysis Processing

Usage Analysis Processing

On the Usage analysis processing page select the check box Enable logging in Logging Settings section
Enter the location of log file and the numeric value in number of log files to created:
Select the check box Enable usage analysis processing and select the Start and End time.

Clcik OK to save the configuration.

Enable Logging Settings and Processing Settings

Enable Logging Settings and Processing Settings

2) Configure site usage reports in Shared Services Administration (SSP)

Go to, Shared Services Administration (SSP)

Configure site usage reports in SSP

Configure site usage reports in SSP

Under section Office SharePoint Usage Reporting click on Usage reporting

On Configure Advanced Usage Analysis Processing page, under Processing Settings section Select the check box Enable advanced usage analysis processing

Under Search Query Logging Select the check box Enable search query logging

Configure Advanced Usage Analysis Processing in SSP

Configure Advanced Usage Analysis Processing in SSP

After enabling usage report in SSP, now activate the Reporting feature in site collection administrators

3) Activate reporting feature

Go to Site actions, click Site settings
On the site settings page, under Site Collection Administration section click on Site collection features
Click Activate button to activate Reporting feature.

Activate the reporting feature

Activate the reporting feature

To view site usage reports, go to Site Actions > Site Settings

If you are a site administrator, click on Site usage reports under Site Administration section

No problem, if you are not a site administrator, usage reports can be view by site collection administrator too, click on Site collection usage reports under Site Collection Administration section

To view the site usage reports

To view the site usage reports

Site usage summary

Site usage summary

Site usage summary

Site usage reports can viewed by site administrators, site collections administrators, SSP administrators and SSP site collection administrators in their respective area

Anil Kumar replied to Robert Hartman on 18-Nov-11 05:14 AM
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

Robert Hartman replied to Riley K on 18-Nov-11 10:22 AM
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.

Robert Hartman replied to Anil Kumar on 18-Nov-11 10:34 AM
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?
Riley K replied to Robert Hartman on 18-Nov-11 08:02 PM


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.

PowerShellEnableSPFeatureNoOutput

Try and let me know if this worked

Regards


Robert Hartman replied to Robert Hartman on 20-Nov-11 01:44 AM
Just to let everyone know i have done all of this so far and the feature does not show up.
Robert Hartman replied to Robert Hartman on 20-Nov-11 01:44 AM
  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
    1. A. On the Site Actions menu, click Site Settings.
    1. B. On the Site Settings page, in the Site Collection Administration section, click Site collection features.
    1. C. On the Site Collection Features page, click the Activate button for the Reporting feature.
  • Robert Hartman replied to Riley K on 20-Nov-11 01:45 AM
    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.
    Anil Kumar replied to Robert Hartman on 21-Nov-11 12:11 AM
    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
    Robert Hartman replied to Riley K on 21-Nov-11 10:57 AM
    Hi Riley,

    I tried this with no luck. It won't start it. Thanks for the idea.
    Robert Hartman replied to Anil Kumar on 21-Nov-11 11:09 AM
    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.
    Anil Kumar replied to Robert Hartman on 22-Nov-11 01:33 AM
    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

    There will be an entry for "ServerRole" which will tell you the installation type 


    Stand Alone - SINGLESERVER
    Web Front End - WFE
    Farm Complete - APPLICATION

    Check the installation type and let me know is it a Farm type or some other type. Also, Meanwhile, Go through the two articles and let me know, what is the outcome then:
    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
    Robert Hartman replied to Anil Kumar on 22-Nov-11 11:59 AM
    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.
    Anil Kumar replied to Robert Hartman on 23-Nov-11 02:27 AM
    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
    Anil Kumar replied to Robert Hartman on 23-Nov-11 05:04 AM
    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