microsoft.public.crm :: Problem with Report Filter


	Problem with Report Filter Hi, I'm trying to make my reports in REPORTING SERVICE 2000! The report are ok, but when I try do add a filter in CRM, appear a msg saying that I can't add a filter in my report! Any one can help me ?? Hi, You will need to prepare your report for filtering. you can do this by adding an alias to the filteredview with the prefix "CRMAF_". That means that you should not use this as query: "select * from filteredaccount" instead use this query: "select * from filteredaccount as CRMAF_filteredaccount" then you can use prefiltering in your report. Hope this helps, -- Ronald Lemmen - MSCRM MVP Avanade Netherlands http://www.ronaldlemmen.com/ - Hide quoted text - "olavo.o.n@gmail.com" wrote: > Hi, I'm trying to make my reports in REPORTING SERVICE 2000! The > report are ok, but when I try do add a filter in CRM, appear a msg > saying that I can't add a filter in my report! Any one can help me ??