hi friends, I am new to ssrs. And am having a doubt as follows, The sql queries with result, select CustomerID,QuotationID,ProductID,QuantityOrdered from Quote; select new_CustomerID,QuotationID,ProductID,QuantityDelivered from SalesOrder; My dataset query is as follows, select q.CustomerID,q.QuotationID,q.ProductID,q.QuantityOrdered,s.QuantityDelivered from Quote q, SalesOrder s where s.QuotationID=q.QuotationID and s.ProductID=q.ProductID; Quote Result: CustomerID QuotationID ProductID QuantityOrdered ABC Q1001 Pencil 1000 ABC Q1001 Eraser 800 CDE Q1002 Ruler 500 FGH Q1003 Pencil 400 Order Result: CustomerID QuotationID ProductID QuantityDelivered ABC Q1001 Pencil 1000 ABC Q1001 Eraser 0 CDE Q1002 Ruler 300 FGH Q1003 Pencil 200 Dataset Result: CustomerID QuotationID ProductID QuantityOrdered QuantityDelivered ABC Q1001 Pencil 1000 1000 ABC Q1001 Eraser 800 0 CDE Q1002 Ruler 500 300 FGH Q1003 Pencil 400 200 Here I need to specify two conditions inorder to get the correct result in my dataset. It is possible in sql queries but in FETCH XML we can give only one condition isn't it?????????If it is possible in fetchxml then anyone please put my dataset query into FETCH XML query....thank you

Hi Naveen, I am assuming when you refer to FetchXML, you are actually trying to build reports of Microsoft Dynamics CRM. If yes, here's a link that shows you in detail on how you can build FetchXML based reports: http://community.dynamics.com/product/crm/crmtechnical/b/lostinthoughtsofcrm/archive/2012/04/28/microsoft-dynamics-crm-2011-develop-fetch-xml-based-ssrs-reports-in-visual-studio-2008.aspx Let me know if this is not the case / if you need more info. HTH. Cheers, IceQBPlease mark correct answers :)