Hi All,

I have a requirement in which account status should be updated if its all related contacts have same status. I have three status values in contact, 'New', 'In progress' and 'Cancelled'. Suppose an account A has three related contacts C1, C2 & C3. If the status of all three contacts is 'New', then account's status should be 'New'. Can anyone help me out on this? 

Regards,
Raksha

How can I make a query similar to following:

Report r = [SELECT id,name FROM Report WHERE foldername='myfolder' LIMIT 1];

Unfortunately, the report object doesn't contain field that is like 'foldername' 
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_report.htm