SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSRS export to Excel converts DateTime Column to Text Column

Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was formatted using the FORMAT function as “MM-dd-yyyy HH:mm:ss” (24 hrs format). However when this report was exported to Excel, this column was converted as Text column instead of… Read more

0 comments, 1,363 reads

Posted in What I Learnt @ Work on 2 July 2013

Mirrored Database as SSRS Data Source

Recently one of our report started to fail with error like Unable to Connect to Database error. Then only we came to know that the said database is in a mirror setup. In the mirrored environment, we have to always connect to Principal, Mirrored database will be inaccessible to the… Read more

0 comments, 1,011 reads

Posted in What I Learnt @ Work on 13 November 2012

SSRS: FORMAT option for milliseconds

Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a change in the internal website which required us to send the a particular Date as a parameter. The page was expecting the milliseconds also.

This looked simple as we thought… Read more

5 comments, 1,704 reads

Posted in What I Learnt @ Work on 21 May 2012

SQL SERVER Replication – Troubleshooting Steps for Beginners

Few days back there was a replication issue in one of the QA servers. Since the DBA was out of office that day, I was called in to look into the issue. Though I am not an expert in replication, I was able to identify the issue. Just wanted to… Read more

1 comments, 5,072 reads

Posted in What I Learnt @ Work on 26 March 2012

Converting SQL SERVER DateTime? Test it thoroughly….

Today one of my user complained that a report was missing one particular ticket from the output. The report in question is very simple, it accepts start date & end date and filters on the ticket creation date time column to get the list of tickets.

The report query was… Read more

10 comments, 4,071 reads

Posted in What I Learnt @ Work on 28 February 2012

Passing BIGINT data to SSRS Sub Report

Few days back one of my team mate complained to me that one particular sub report is failing randomly with

Error: Subreport could not be shown

The particular sub report was called from another report’s tablix control column. It accepts  a parameter whose base data type in SQL SERVER database… Read more

1 comments, 1,146 reads

Posted in What I Learnt @ Work on 27 February 2012

SSRS 2008 Error – The report definition is not valid

Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and everything looked good. However when I tried to upload the file in the Report Manager got a strange error

The report definition is not valid. Details: ‘.’, hexadecimal value 0x00,… Read more

1 comments, 4,492 reads

Posted in What I Learnt @ Work on 27 February 2012

Dundas Dashboard – My observations

Dundas Data Visualization Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated them into SSRS 2008 & R2. These controls adds rich visualization to SSRS reports.

However one of the feature that SSRS miss is the real “Dashboard”. Dundas seized… Read more

4 comments, 1,467 reads

Posted in What I Learnt @ Work on 4 February 2012

SQL SERVER connectivity error: SQL Server does not exist or access denied

Recently I was troubleshooting a connectivity issue in a development environment from an application. The application was using the connection string as

“Provider=sqloledb;Data Source=myserver\instance1,1433;Network=DBMSSOCN;Initial Catalog=mydb;Integrated Security=SSPI;”

I was able to connect to the SQL SERVER from SSMS, however when connecting from an application it was throwing the error

[DBNETLIB][ConnectionOpen (Connect()).]SQL… Read more

5 comments, 45,699 reads

Posted in What I Learnt @ Work on 16 January 2012

Review of my blog posts in 2011

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:

The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 26,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 10…

Read more

0 comments, 696 reads

Posted in What I Learnt @ Work on 2 January 2012

Data Driven Subscription failed with timeout error

One fine day, one of our data driven subscription which was running fine, failed with timeout error.

library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling data-driven subscription 1b850434-fe69-47e5-a227-219d1b2e040c to report /External Reports/Report1, owner: domain\user, delivery extension: Report Server Email.
library!WindowsService_118!1288!12/20/2011-07:30:01:: i INFO: Initializing EnableExecutionLogging to ‘True’ as specified in Server system properties.
library!WindowsService_118!1288!12/20/2011-07:30:01:: i… Read more

1 comments, 1,148 reads

Posted in What I Learnt @ Work on 23 December 2011

Silly issues with SSRS

Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started by checking the report body to ensure that the corresponding column was called appropriately, then looked into the dataset fields to see whether there was any mapping issue. Both of… Read more

0 comments, 853 reads

Posted in What I Learnt @ Work on 29 November 2011

Displaying blank sub report

Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two date parameters , a data set displayed in a tablix,  NoRowsMessage was enabled on the tablix to display a message when the data set returns empty row.

This report feature,… Read more

0 comments, 993 reads

Posted in What I Learnt @ Work on 28 October 2011

This field is missing from the returned result set from the data source.

This warning

The dataset ‘dataset1′ contains a definition for the Field ‘column1′. This field is missing from the returned result set from the data source.

is very common error and reason behind it is really simple. The report object is referring to a field which is not available in the… Read more

1 comments, 7,513 reads

Posted in What I Learnt @ Work on 23 September 2011

SSRS 2008 R2: Object reference not set to an instance of an object

We have a report in SSRS 2008 which calls multiple sub-reports. One of the sub-reports contains a data region (tablix)  in which one of the column is populated by another sub-report i.e. the sub-report will render for each row of the tablix. This report is working fine in 2008.

As… Read more

1 comments, 2,499 reads

Posted in What I Learnt @ Work on 10 September 2011

SSRS 2005 Error: The Item “/” cannot be found

Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it had thrown a message

The item “/” cannot be found

After repeated attempts, the report server opened up. But when we tried to access a report it erred with a… Read more

0 comments, 3,896 reads

Posted in What I Learnt @ Work on 10 September 2011

SSRS 2008 R2: Report Server crashing intermittently

One of our report server which is SSRS 2008 R2 (10.50.1720.0) started to crash intermittently. The IE failed with Internet Explorer cannot display the webpage. The report server log files didn’t contain any other information. After few mins (~2 mins), the report server came alive. This was happening intermittently.

The… Read more

0 comments, 3,548 reads

Posted in What I Learnt @ Work on 9 September 2011

Side by Side installation of SQL Server 2008 and SQL Server 2008 R2

Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER 2008 BIDS. Since SQL SERVER supports side by side installation of same/different versions (in fact we have BIDS 2005 & 2008 installed in a machine), I thought this should not… Read more

0 comments, 1,797 reads

Posted in What I Learnt @ Work on 26 August 2011

Impact of manipulating SSRS parameter inside dataset

Recently I had to convert a report’s dataset, which was using Stored Procedure, into inline T-SQL commands. The dataset had 4 parameters , which it was passing to a stored procedure. I had to add two more parameters and since this was an emergency fix, I took the code from… Read more

0 comments, 1,331 reads

Posted in What I Learnt @ Work on 11 August 2011

Conditionally summing up values in a dataset in SSRS

Recently I had situation wherein I had to conditionally sum up a data set and display the value in a text box.

The value in the dataset looked like

In this case, for example, I had to sum up ”VwCount” for FYMonth  = 6. So I came up with an… Read more

3 comments, 12,458 reads

Posted in What I Learnt @ Work on 22 July 2011

Older posts