What should be height and weidth?? can you please specify???

Thnk you all for the suggestions.It works now.

ya..that the reason I took (SELECT * FROM dbo.SplitParameterValues(@Team,'|')))

But while filtering my report , in drop down it is passing value like'A,C,D,.......'

which is not working.

I have team name something like below

'Pegasus Texas Construction, LP'( which is one word)

declare @team varchar(max)

Set @team ='Pegasus Texas Construction, LP'

so i cannot take

(select * from dbo.SplitParameterValues(@Team,','))

Anyways I took round ()off to get avg time in minutes in ssrs exp

yes...I converted your sql expression to SSRS expression , but getting avg minutes:2259:33333:(

if we can convert hours to mins and then take average of it??? in expression??

yes but in hrs:mins format

yes...

trying taking:

parameters :

start_time END_time

2012-05-17...

Acieving thru function:

ALTER FUNCTION [dbo].[Usp_GetHoursMins1]

(

@para_start_time varchar(30),

@para_end_time varchar(30)

)

RETURNS VARCHAR(20)

As

BEGIN

-- Declare the return variable here

DECLARE

@hrs_min as varchar(20),

@total_time as int,

@datecalc as datetime,

@iDateCnt as int,

@minutesleft as int,

@hours as int,

...

I created pagination in my report to show 100 records per page.

also craeted groups in my report.So, when i filter my report by some parameter...it shows extra pages even if...

it is just showing #error while in preview mode.

My satrt and end date is datetime.Is that because of datetime???If so, how to calculate average days between 2 datetime values???

As per your query we are getting recent datetime and if it is enrollment analyst then assigning it as "complete" if not "pending".But I need a query which checks next...

Gone through rules...the query is not working as per rules I posted:(