locked
How create a reports or views thats show account without offers? RRS feed

  • Question

  • Hi, I have question. In my CRM 2011 On-line i have accounts. For some of this accounts I have created a offers  and join them to the accounts. But I don't know how to display the rest of the accounts without offers using reports. I have try wich view to.

     

    anybody know what should i do?

    Monday, May 30, 2011 1:55 PM

Answers

  • One of the limitations of Advanced find queries (and fetch queries in general) is you cannot ask to display a list of records with no child records e.g. all Accounts without Opportunities. I'm guessing this is the problem you are facing.

    A codeless way around the issue is to add a flag to the account record called, for example, 'with offers' and have a workflow automatically tick the box when an offer record is created or when the link to the parent account is populated. This isn't completely bulletproof in the cases of offers migrating between accounts or being deleted but may be good enough. If you need something more robust you will have to resort to a plugin to populate the field.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet http://www.twitter.com/leontribe


    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Tuesday, May 31, 2011 4:50 AM

All replies