FIND OBJECTS BEING REFERRED BY SSRS REPORT

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...

SOME BUGS IN SQL-SSRS 2005

Hi Guys
I know sql 2005 is getting outdated and there would be no support from Microsoft from this month. But lets not...

Handling decimal and non numeric types using Case statement

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...

syntax error in textheader of stored procedure - Cause and Solution

Hi Folks,

Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...

Hi Folks,

Hope you all are doing good. Would like to start with praying for all those who have been affected...

Data Rendering Eye Opener SSRS

Hi Folks

Greetings to everyone!!!

So last week one of the report was having a performance issue. It had 10 datasets ,5...

Toggle Functionality Looses In excel--ssrs 2005

Hi Folks

Highlighting on the issue that I faced last week while working on reporting services 2005.

Requirement :- A data region (table)...

Date Range Challenge in sql

Hi Folks,

When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...

Bug In ado.net enumerator in foreach loop in SSIS 2012

Hi Greetings to everyone,

Today I am going to report a bug in SSIS 2012. In one of the packages I...

CTE - Limitations

Hi

Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...