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
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
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
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
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
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
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 0×00,… Read more
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
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
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…
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
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
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
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
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
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
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
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
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
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