Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Report cannot have default filter RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi *,

    Currently, I'm facing some problem about CRM 2011 Custom Report. My custom report is using SQL to fetch data. I already put the "CRMAF_" for pre-filtering inside the query. In my development server, everything was ok. But in production, my report doesn't have the "Edit Filter" button and when I try to edit the default filter, I got this "This report cannot have a default filter". Can someone help me?

    This is the error that i get..

    Thursday, January 16, 2014 9:33 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Following steps may help you.
    1. Right click the report in solution explorer and select "View Code"
    2. Strip out everything between the <custom> and </custom> tags.
    3. Save the file and close it
    4. Reopen in VS
    5. You're good to go!
    6. Upload back to CRM (this adds the XML tags again).
    Thursday, January 16, 2014 11:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Try to bulid your report using report wizard in crm after that download report then make change in visual studio. then re-import your report.

    Hope this helps. ----------------------------------------------------------------------- Santosh Bhagat If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    Friday, January 17, 2014 4:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There may be a problem with how you've defined the CRMAF_ alias. Can you post the report SQL ?

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, January 17, 2014 8:28 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    @ALI_087 : I can't see any <custom> tag in my "View Code"..
    • Edited by mr_nougat Monday, January 20, 2014 2:22 AM
    Monday, January 20, 2014 1:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    @DavidJennaway : here is my query

    SELECT   new_lastpracticeyear, new_officestatename, new_activestatusname, new_secondarystatusname, COUNT(new_lastpracticeyear) AS Total
FROM     FilteredContact AS CRMAF_FilteredContact
WHERE    (new_lastpracticeyear <> 'NULL')
GROUP BY new_lastpracticeyear, new_officestatename, new_activestatusname, new_secondarystatusname


    • Edited by mr_nougat Monday, January 20, 2014 2:24 AM
    Monday, January 20, 2014 2:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    @Santosh Bhagat_2012 : Can I do that if I'm using SQL query?
    • Edited by mr_nougat Monday, January 20, 2014 2:23 AM
    Monday, January 20, 2014 2:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, in my suggestion read complete link:

    http://msdn.microsoft.com/en-us/library/gg328288.aspx

    Specially example that given.

    Hope this helps. ----------------------------------------------------------------------- Santosh Bhagat If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    Wednesday, January 22, 2014 5:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi *,

    I already changed my query. Now I'm using fetchXML. And it turn out that the filtering is working. Thanks a lot for all the help. But I still wondering why the "CRMAF_" not allow me to change the filter.

    Thanks a lot again guys..cheers!! =)


    • Edited by mr_nougat Wednesday, January 22, 2014 8:17 AM
    Wednesday, January 22, 2014 8:16 AM