Thanks John..the update for date worked perfect..the one for quantity failed..but made a small change to ur query and it worked fine too..

i modified it as

update @table

set Qty =...

i think the error is due to not supplying credentials..when you work in your test machine, does your machine account is associated with SQL Server RS?. if so, putting on...

Thanks Ninja's it worked well.! There is no product info table. This is the only table with all the information. this database gets populated on a daily basis from another...

i have another question now..dont know if this is a right place to post..

How would one do a parameter validation in sql reporting services. For ex: If I have a...

Thanks dave. worked like a charm. I am also thinking about the second option you mentioned...Both the options work.I dont know how they need it..anyways,Thanks a lot!

thanks both for the reply.

The query is used for generating a report using sql reporting services. I am using 2 databases to generate one report.

I have a query tht is...

Thank you both of you for the explanation.

Regards,

Sankar

sorry to bump in..what is a calendar table..(ignore my ignorance)

Thanks,

Sankar

oh ok..! noted that..i dont see any problem why the code fails..just thought it could be with the SP's ''...thanks for letting me know

did u notice this, may be this will help.. you r missing the ' ' for all varchars

ex: SET CustomerReference = '@CustomerReference'

Thanks,

Thanks for your reply. The server is located in a different location. I see a page under construction message and i dont think i have permissions to check what you...

never mind..figured it out..(used the visibility property) to do it.