Steve,

I got the report to work in SQL reporting finally ....

Instead of manipulating in data in reporting...i modify the calling stored procedure so...

Hey Steve,

    I have got another urgent project to finish so i'm going to give it a break for a week atleast. But i'm so close and also learning a...

Steve,

  I am afraid i didn't understand your point. I noticed that SQL reporting only takes the felds which a stored procedure points towards the first select statement. That's why...

Hey Steve,

    I am posting the code here for anyone having similar problem.

CREATE PROCEDURE [dbo].[sp_exec_idependon]  @Asset varchar(50)

AS

begin

if exists(select 1 from tempdb..sysobjects where name = '##temp_idependson' and type = 'U')

drop table...

That works...Great!!

Ya, i don't have the +/- signs but atleast this solves the purpose. I wonder why reporting service didn't give me the recursive hierarchy with parent-child grouping. But this...

Hi Steve,

    I tried to use the parent child recursice feature but for some reason, i was not getting the required result and also the indentation. That was the reason...

Steve,

I can create a temp table and insert the data into it but how would i differentiate the recursive data. To clarify, let me show the text output

I Depend...