Results 1 to 4 of 4

Thread: How to create custom selections?

  1. #1
    Chris80 is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    102

    Question How to create custom selections?

    Hi,

    I'm kind of missing the opportunity that I get with Access or other DBMS:

    I would like to do some advanced queries and not sure how to find out about questions like this:
    Show my the activities, related to the accounts or contacts within the zip code: xxx
    Show me all the contacts with their companies from the industry: xxx

    So basically we need to generate some lists and would like to be able to do it with SugarCRM.
    Is there any module which can help us?

    Thanks in advance.
    Bye, Chris

  2. #2
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,379

    Default Re: How to create custom selections?

    Zucker Reports in conjunction with ireports enables you to run complex queries against the sugarcrm db.

    ireports is a crystalreports-like open source application

    zucker reports is available in sugarforge

    there's a learning curve involved

  3. #3
    ben.gillis is offline Senior Member
    Join Date
    May 2010
    Location
    Pittsburgh PA
    Posts
    61

    Default Re: How to create custom selections?

    these don't seem too complicated at all. when you are in the report wizard all you have to do is select the related module to filter based on a related modules fields.

    example Show me all the contacts with their companies from the industry: xxx

    create report> rows and columns>contacts as primary module>to define filter by clicking on Accounts in related module window.(the word accounts) and select industry. then identify the filter criteria in the main filter window.

    your first example is a bit more complicated because activities is not a "real" module. it is really several; meetings, calls, notes, tasks, emails. so you could create individual reports for each type, or use a third party software to combine them. but the or filter is easy to setup.

    Hope this helps, by the way i am a SugarCRM certified trainer if you are interested we have a reports class. just click the link below for a list.

    Ben Gillis
    SugarCRM Trainer
    Plus Consulting
    for available classes go to www.plusconsulting.com/training.htm

  4. #4
    Chris80 is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    102

    Question Re: How to create custom selections?

    That sounds actually very good.

    Unfortunately, I'm not able to install it on a SugarCRM 6
    Should I better use a 5.5 now or should I wait?
    Any ideas about how long it will take until the module for version 6 is released?

    Didn't find a lot of information on that from zuckerfriends

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 2011-10-14, 06:24 AM
  2. Multiple selections dropdown
    By Nuno in forum Help
    Replies: 1
    Last Post: 2007-08-14, 03:58 PM
  3. Where are dropdown selections stored?
    By damocles in forum Developer Help
    Replies: 1
    Last Post: 2006-03-17, 12:43 AM
  4. No selections in Sugar CRM???
    By Danielsan in forum Feature Requests
    Replies: 2
    Last Post: 2006-02-16, 07:09 PM
  5. Selections and campaigns
    By Danielsan in forum Help
    Replies: 0
    Last Post: 2006-02-13, 09:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •