You are Super Star clayman, make my day 🙂

There is EmployeeID, it was just example and in a rush didn't define.

Thanks Again.

Insert all data into Temp table and do accorndingly.

Here is All you want, with dummy data,

CREATE TABLE #Test

(

IDINT,

ParentIDINT,

TNameVARCHAR(25)

)

INSERT INTO #Test

(

ID,

ParentID,

TName

)

SELECT 1,NULL,'Granfather'

UNION ALL

SELECT 2,1,'father1'

UNION ALL

SELECT 3,1,'father2'

UNION ALL

SELECT 4,2,'1st-son-father1'

UNION ALL

SELECT 5,2,'2nd-son-father1'

UNION ALL

SELECT 6,3,'1st-son-father2'

UNION ALL

SELECT 7,3,'2nd-son-father2'

SELECT * FROM #Test

--------------------------------------------

-- Recursive...

Agree with Sean,

Recursive CTE like below,

[Code]

WITH Tree AS

(

SELECT Parent.ID[ID]

, Parent.ParentID[ParentID]

FROM Entity Parent

WHERE Parent.ID = @Parammeter

UNION ALL

SELECT Child.ID

...

I had decimal(18,2) made it to more decimal points solved rounding problem.:-)(Thanks Jeff, Life Saver)

try

=FORMAT(<date>,"dd/MM/yyyy")

similar problem,

http://www.sqlservercentral.com/Forums/Topic1328723-150-1.aspx

i don't think you can use subreport field into main report, need to work out in your stored proc or query.

try to upload it again..!!

do you get result for

this might help you..

http://www.sqlservercentral.com/Forums/Topic1328723-150-1.aspx

in your main report use table and try it.

try....

Globals!RenderFormat.Name

OR

You could also use the .IsInteractive property, which will disable the links for PDF exports as well:

IIf(Globals!RenderFormat.IsInteractive, "YourReportPath", Nothing)

ok...

you could do like this,

1. in your date dataset and add CASE statement like if there is a team then it's fine else display as 'No Team'

2. in your team...

in your drop down list dataset query, add new UNION query for no team value

SELECT ........

<Original Query>

...

create two different datasets

1. Top5 handset

SELECT Top5 Handset

FROM tblHandSet

...