The report server e-mail delivery extension is not configured by default. You must use the Reporting Services Configuration tool to minimally configure the extension. To set advanced properties, you must...

That is what i do not want, I do not want to minimize the parameter area , i want it to be static when you acess the repor thourgh url....

Thank you everybody for the explainations.

That was bulls eye. You were right

Thank you

I shall try and rewrite the queries and avoid the the multi-statement UDF

Thank you once again

For example

Declare @Username nvarchar(50)

Declare @SearchType nvarchar(50)

Declare @FilterValue nvarchar(50)

DECLARE @CID smallint

Set @Username = 'abc '

Set @SearchType = 'abc'

Set @FilterValue = N'pap'

DECLARE @ModeSearch TABLE

(

PID int PRIMARY KEY,

CID smallint

)

INSERT INTO @ModeSearch(PID, CID)

SELECT DISTINCT...