No I don't want to go through wizard.

I would like to prepate a specific template for my company

Is it possible?

Thank You so much

I got it now

Thank you so much for your help.I changed my code like this

SELECT     x1, x2 

FROM       xx,yy

WHERE(

  (CASE

          WHEN  @y1 Is Null THEN 1

                    Else dbo.xx.y1=@y1            End)

AND

  (CASE ...

Thank you very much for your answer.

I tried your approach. The only hiccup that I face here is that the if the user does not give Value A then the value...

Hi Ninja,

I am soo thankful for your reply.

After i updateg your logic  I am getting the following error.

Could not generate a list of fields for the query.

Check the query syntax,...