Wednesday, May 28, 2008

microsoft office word has stopped working everytime after closing word down

SOLUTION

Close Word

Navigate to :

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word

Find the "Data" folder and rename it to "Old-Data"

Restart Word

Thursday, May 15, 2008

SUPPRESS BLANK REPORT - surppressing blank report Crystal - suppress subreport if there are no records

  1. RIGHT click on the subreport,
  2. then choose FORMAT OBJECT
  3. In the SUBREPORT tab, check the box next to SUPPRESS BLANK REPORT.

Thursday, May 08, 2008

SSRS ReportBuilder won't run - Unauthorized

SSRS report builder doesn't run

I was having problem when logging on to SSRS from another PC outside of the domain that the SSRS server is on.

Error msg


http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

To sort this problem out follow these steps:

If the ReportBuilder application won’t run then run IIS on the reports server:

Navigate to:

Default Website\ReportServer\ReportBuilder

Right click ReportBuilder.application file
File Security / Authentication and Access Control / Edit
Tick Enable anonymous access












PLATFORM VERSION INFO
Windows : 5.0.2195.262144 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [08/05/2008 09:33:39] : Activation of http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [08/05/2008 09:33:46] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://192.168.1.2/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)