Problem with Report Filter

[olavo....@gmail.com]

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 ??

[Ronald Lemmen]

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/