Word: This document contains links that may refer to other files

If Thor had an office job, his desk would be a pile of splinters….Possibly one of the most annoying warnings in Microsoft Word is the warning “This document contains links that may refer to other files” when you open a document. It doesn’t matter if you choose Yes or No, you will continue to be prompted every time you open the file.

 

worddocumentcontainslinks

You can turn off the warning altogether…by going to the File menu, Options, Advanced, then scroll down to the General section and untick the box beside “Update automatic links at open”.

wordoptions

 

Whilst this won’t resolve the cause, it will stop the warning from popping up next time, for any Word document.  The gotcha is every user must set the same option in their installation of Microsoft Word.

To identify links used in your document you can expose the “Edit Links to Files” function.  You can expose this by going through File, Options, Quick Access Toolbar, select “File Tab” in the “Choose Commands From” dropdown, find the function “Edit Links to Files” and select “Add”.

EditLinksToFiles

This will explose the following icon in the Quick Launch Menu where you can view links to other files.

EditLinksToFilesIcon

 

 

 

SSRS : Use the same colour Palette in different charts in the same report

In the following example you have two pie charts – each chart is set to default colours – you want to make sure that the charts are coordinated, meaning they use the same fill colour for each category – so the blue always aligns with Category 1, the green always aligns with Category 2 and so on.
colourpalette

The following reference highlights how to do it http://technet.microsoft.com/en-us/library/dd239350.aspx however some additional tips.

Use the sample code below (adapted from the above technet article) but substitute your colours with either the colour name or the hex colour with the # e.g. CadetBlue or #5F9EA0.  You can use the following colour reference for help choosing http://msdn.microsoft.com/en-US/library/aa358802.aspx.  Make sure you choose enough colours to cater for the maximum number of categories in your dataset.

Once you have created code within your Report properties Code module, you just need to call the code….right click on your pie chart, select Series properties and under fill, set your expression under the Color property. Make sure your expression refers to the field value e.g. =Code.GetColor(Fields!YourCategoryField.Value)

Private colorPalette As String() = {"#5F9EA0", "Gold", "Gray"}
    Private count As Integer = 0
    Private mapping As New System.Collections.Hashtable()
    Public Function GetColor(ByVal groupingValue As String) As String
        If mapping.ContainsKey(groupingValue) Then
            Return mapping(groupingValue)
        End If
        Dim c As String = colorPalette(count Mod colorPalette.Length)
        count = count + 1
        mapping.Add(groupingValue, c)
        Return c
    End Function

SSRS : Report fails – RdlObjectModel is not a member of ReportServices

You run a report in Reporting Services which subsequentially fails with error RDlObjectModel is not a member of ReportServices. You investigate the suspect textbox and find an expression in the textbox contains the following code Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions.  This appears to happen when you copy and paste a text box that contains and expression.

A connect case is available here http://connect.microsoft.com/SQLServer/feedback/details/757358/pasting-objects-with-expressions-pastes-fully-qualified-functions but for now you will need to manually strip the expression of this code. Either do this manually within your textbox expression or open the report in View Code mode and search and replace.

SSRS: User does not have required permissions…windows user account control uac restrictions

You run Report Manager and you get a user does not have required permissions / uac error, yet you know you have permissions, in fact you would put money on it…except you stand there locked out of your Report Manager.

A combination of the following is likely to resolve :

1. Disable UAC (Open Control and change User Access Control settings to Never Notify – may require a reboot)
2. Run Internet Explorer as administrator then open the report manager
3. If all else fails, add the url of the report manager to the Local Internet Zones in Internet Explorer, not Trusted Sites.
4. Once logged in, if you are required to me an adminstrator, verify you have the System Adminisator role within the Site Settings link in Report Manager. Additionally set yourself Content Manager permissions at the Home folder level.