Hi all,I am in strife using SCCM 2007 as I cannot get any of my reports to generate. Basically I am trying to run a predefined report on SCCM, when the report runs a report window is displayed with no contents in the report, all consective reports that are run do not even show a reports window, they just seem to be continually trying to load. Now all queries are working fine, so there seems to be something specific with the way reporting is working. I have used the reporting function when SCCM was first provisioned by me over 8 months ago when it was working and since have not touched until last week. Background info on enviroment:1. Windows Server 2008 x86 2. Microsoft System Centre Configuration Manager 2007 R12. DB on MS 2005 Cluster - remote servers3. Report Viewer installed4. asp.net, .net framework, bits, remote differential compression, webdav and windows authentication are all enabled or installed5. Management console works fine etc...I am extremely puzzled and have done all the googling and binging in the work to no avail, I am sure this will be something either very simple of something really obsecure but am hoping a someone smarter that I can help please.Thanks in advance

Hi,Is it SQL reporting Services or the builtin ASP reports? Do you get any errors?Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

Hi,I would remove the reporting point and reinstall it. It only takes a few minutes. Check the reportinginstall.log file for errors.Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

Hi Kent,Thanks for the quick response, much appreciated.Firstly I could not locate the reportinginstall.log file from a previous install and how would I go about re-installing the reporting point for SCCM?Cheers

Hi,You go to the site system, right click the reporting point role and select delete - check this article for detailed steps - http://technet.microsoft.com/en-us/library/bb693500.aspxKent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

There's smsreporting.log. Maybe there's something useful in it.

Again no errors, but here is a snippet of the log in case I have read it wrong.[2688] 01/14/2010 17:28:33 <SMSReporting: Start Connect> SMSSiteCode=CONTOSO SQLMachine=CONTOSOAUSINS04\IT SQLDatabase=SMS_CONTOSO[2688] 01/14/2010 17:28:33 <SMSReporting: Connect: SQL Server database name supplied as parameter> SMS_CONTOSO[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User name: CONTOSO\~tonys[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Domain Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSOAUSSMS01\ConfigMgr Remote Control Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: BUILTIN\Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: BUILTIN\Administrators[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: NT AUTHORITY\REMOTE INTERACTIVE LOGON[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: NT AUTHORITY\INTERACTIVE[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: NT AUTHORITY\Authenticated Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: NT AUTHORITY\This Organization[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\EngLib-RW[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Exchange Administrators[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Domain Admins[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Wireless Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\IT Support[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\UG Wireless[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Web Report Administrators[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Web Report Authors[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\EngLib-RW Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\MessageStats Web[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Denied RODC Password Replication Group[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Web Report Users[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: CONTOSO\Project Server Team Members[2688] 01/14/2010 17:28:33 <SMSReporting: GetUserNameAndGroups> User in group: Mandatory Label\High Mandatory LevelCheers

any ideas anyone ??? :S