Hi Omar,

There is nothing wrong with your query.
Are you sure that it returns some rows?

It should work fine with a pivot chart.

Ed Ferrero
www.edferrero.com

omar_aa wrote;

i am not using views........infact i am using simple queries like the one
given below:
select * from rc where bid='bid123'
i am using the above query to use it...........
now plz tell me that how can i use the views in the pivot chart??