hi thanks this does work however how would i do wit without use T-SQL syntax ie without the exec @sql, jus run as a select with an order...

Hi,

If I change the Page Size it will mean the report will look very big, the purpose of the scrolling is so that the whole table fits into one...

Thanks for both replies...it is only possible to do the OR if its the same field-that makes sense, thanks.

Thanks for the example with expression, i will use that for my...

Ive just tired out ur logic vaseem and it works...I will try the next two to see which one gives me greater performance

Thanks i saw that step, i would still like to know if u can use an "IF" in the WHERE clause of the SQL statement cause i dont want to...

Oh i see so that was vb syntax

Is it possible for you to tell me how to implement the following logic then in the WHERE clause?

SELECT * FROM products

WHERE product_name...

Hey, the IF statement casues the following error:

Msg 156, Level 15, State 1, Line 11

Incorrect syntax near the keyword 'THEN'.

Msg 156, Level 15, State 1, Line 26

Incorrect syntax near the...

Thanks, but i need a IF because of the following:

DECLARE @product_name nvarchar(3)

SET @product_name = 'All'

SELECT * FROM product

WHERE product_name = CASE @product_name

WHEN 'All' THEN (SELECT...

Thanks but i get the following error when trying that:

Msg 512, Level 16, State 1, Line 5

Subquery returned more than 1 value. This is not permitted when the subquery follows...