Parameters not being used in report processing
- Category: SQL Server Reporting Services
- Hits: 33146
Problems:
- Given a date, the date format was reverting to US format as opposed to European
- Given a Campus as a text value, the SQL query was ignoring this completely
- Hardcoding the scalar local variables worked
Change Regional Settings for your Report
- Category: SQL Server Reporting Services
- Hits: 36515
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy).
Report Builder 2.0 - Hide Series1
- Category: SQL Server Reporting Services
- Hits: 35378
Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment.
Our setup is:
- SQL Server 2008
- Report Builder 2.0
- BMC Service Desk Express 9.8
DataSet1:
- Incident #
- Group Name
- Close Date & Time
- Assigned to Full Name
- Incident Type
The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null.
If Then Else in Report Builder 2.0 Expressions
- Category: SQL Server Reporting Services
- Hits: 47499
Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0
I'm looking at the following if statement:
If (MyFieldName = 0) Then
Return 1
Else
Return MyFieldName
Can be expressed as:
IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
SSRS Report Builder 2.0 - Error during processing
- Category: SQL Server Reporting Services
- Hits: 25221
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: 18872
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: 17811
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: 36199
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!