I have been working in IT since 2001 for companies such as Computacenter and Getronics. I started out as a first line support analyst supporting heterogeneous networks but rapidly worked my way up the ranks expanding my knowledge as I went to include areas such as system builds, deployments, networking, and security to name a few.In 2008 I decided to concentrate on the monitoring and management of large enterprise networks using Microsoft's System Center Operations Manager (OpsMgr) 2007 of which I have extensive knowledge. As testament to this the Windows Management User Group (WMUG), invited me to join their ranks as a Community Leader where I have been invaluable in helping to bolster the OpsMgr skills to the benefit of the group and it's members.I have now moved into an OpsMgr 2007 consultancy role to do what I like most - working with OpsMgr and sharing my knowledge and experiences with the community.
If trying to run a report but receiving a Cannot Execute Report error as below, the first thing you probably would think of checking is your regional settings and making sure you have the same date/time format as the reporting server. And, this may well solve the issue, however, it may also not. A less obvious setting to check is the Short Date Format and this is a very important setting, if the short date format is different on the computer running the report compared to the reporting server then this error will continue to appear. It is definately worth checking as just because your date/time format is correct, doesn't guarantee your short date format is correct.
To check your short date format (on Windows Server 2003) go to Control Panel and select Regional and Language Options then click Customize on the Regional Options tab. This will open a new window where you can select the Date tab and check the short date dormat and alter as necessary.