i dont get you please elaborate more !!

when i run the application (c#) to get the parameters list of the report ( sql2005.reporting service) it shows an error: ============================= "System.Net.WebException: The request failed with HTTP status 502: Proxy Error ( The ISA Server denied the specified Uniform Resource Locator (URL). ). at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at TFIReportClient.RPTWebReference.ReportingService.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials) in ...." ============================= so, what can i do?

Thank you very much Of course I designed the database and I am the first one who can change or update it but you know in this phase of project i can not push my time on this matter

ooops! its a bit difficult to change the structure of a database for such a query !

use this: create spTest ( @top int) as begin declare @text nvarchar(500) set @text = 'select top ' + @top + ' from table where 1=1' sp_executesql @text end

select * from tab1 inner join tab2 on tab1.empno=tab2.empno inner join tab3 on tab2.empno=tab3.empno inner join tab4 on tab3.empno=tab4.empno inner join tab5 on tab4.empno=tab5.empno where 1=1

i want a transact sql for select queries which returns all rows that include something like here: table1 code, name, address, ?? , ?? 1 , john , toronto , .. 2 , mike , new york , .. 3 , alec , john city, .. ... select * from table1 where includes 'john' result is: 1 , john , toronto 3 , alec , john city [note1: i do not know field names] [note2: fields are in different data types] [ like : int, numeric, float, char, text, image ....] [note3: full text indexing is appropriate for string fields,not for all types]

i have installed sql server reporting service 2005 1. how i can get the list of reports (*.rdl) in a windows application c# 2005 ( sth like Server.GetReportNames ???) 2. how i can get the list of each report parameters in a windows application c# 2005 ( sth like Server.GetParameters ???)