hi All ! i would like to know the fact which reports will be fetched faster in case is the report is of holding 7 parameters each parameter holding a data set for the options to be listed as drop down boxes? 1. Query for the main report and all queries for all dataset of parameters are defined in the BIDS to retrieve the records. 2. the query for the main report alone is from SQL stored procedure and all other queries for the parameter's datasets are in the BIDS. Please let me know.--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Looks like the second should be faster, but are you able to test it?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Looks like the second should be faster, but are you able to test it? Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ So if the queries being with the SQL ll give good performance rather than the queries with the report ? No i haven't yet given it a try. ll Try. ll come back :0) --------------------------- Radhai Krish | Golden Age is no more far | --------------------------