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

Archives: February 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, 3,933 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,109 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,308 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,433 reads

Posted in What I Learnt @ Work on 4 February 2012