SSRS Report Builder 2.0 - Error during processing
- Category: SQL Server Reporting Services
- Hits: 23994
The Issue
After modifying a report and on running it, Report Builder 2.0 returns the following error:
An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure.
SharePoint 2007: Change profile picture with minimal permissions
- Category: SharePoint
- Hits: 17497
This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given.
Why?
Because I can
How?
About 5 seconds worth of fun
- Category: SharePoint
- Hits: 16841
Really not work related but if you know your sharepoint site:
Custom Error
http://<My_SharePoint_Site>/_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks.
Installer?
Sync Outlook 2007 Shared Calendar with SharePoint 2007
- Category: SharePoint
- Hits: 33333
I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't.
The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones.
Eeek!
UNC Paths in Sharepoint 2007 links
- Category: SharePoint
- Hits: 20056
- Microsoft Office Sharepoint 2007
I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link.
Why?
As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal.
How?
Include a carriage return in a column heading
- Category: SQL Server
- Hits: 34840
- MS SQL Server 2008 R2
- MS Windows 7 Enterprise (Client)
- MS Excel 2010
What?
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time.
Why?
I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the word "Academic".
What I have:
Academic Week Monday Tuesday Wednesday Thursday Friday ---------------- ----------- ----------- ----------- ----------- ----------- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 2 21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014 ...What I want:
Academic Week Monday Tuesday Wednesday Thursday Friday --------- ----------- ----------- ----------- ----------- ----------- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 2 21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014 ...
How?
To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the answer is a much simpler one,
Connection Strings for SQL Server
- Category: SQL Server
- Hits: 53466
MySQL Connector/Net
Type: .NET Framework Class LibraryUsage: MySql.Data.MySqlClient.MySqlConnection
Manufacturer: MySQL
Standard
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Default port is 3306.
Specifying port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Deserialization and cannot checkout files in TFS
- Category: Team Foundation Server
- Hits: 13121
So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can.
What?
Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while.
How?