Author Archives: Suresh Kumar D

About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.

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 … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in SSRS | Tagged | Leave a comment

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 … Continue reading

Posted in SSRS | 4 Comments

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, … Continue reading

Posted in Replication, SQL SERVER | 1 Comment

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 … Continue reading

Posted in T-SQL | 10 Comments

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 … Continue reading

Posted in SQL SERVER, SSRS | 1 Comment

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 … Continue reading

Posted in SSMS | Leave a comment