Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 314 subscribers
  • Views 810 views
  • Users 0 members are here
Related content from around SugarClub

reporting

Ellen Wood

Is it possible to build a report that shows data lists from multiple modules? 

The "single page" report I've been asked to create is based at the global client account level.  This is where they want a run-time filter to select various key accounts to look at multiple data sets for the multiple child accounts associated with this key account.  They want groupings of rows and columns lists of all contacts, Won contracts, and Open contracts.  

Parent Account (run time filter)
Child account 1
Contact 1 name, title, etc.
Contact 2 name, title, etc.
Contact 3 name, title, etc.
Child account 1
Won Contract 1 Name, Team, etc.
Won Contract 2 Name, Team, etc.
Won Contract 3 Name, Team, etc.
Child account 1
Open Contract 1 Name, Team, etc.
Open Contract 2 Name, Team, etc.
Open Contract 3 Name, Team, etc.
Child account 2
Contact 1 name, title, etc.
Contact 2 name, title, etc.
Contact 3 name, title, etc.
Child account 2
Won Contract 1 Name, Team, etc.
Won Contract 2 Name, Team, etc.
Won Contract 3 Name, Team, etc.
etc.

Is this even possible without custom reporting programming? 

Parents
  • 0

    hello Ellen,

    that is heterogeneous data in the third column of the example, therefore IMHO that is a union of different reports, which is hardly doable with out-of-the-box Reports.
    However,  there might be Advance Reports functionality out-of-the-box, that allows Sugar Admins familiar with SQL to write SQL queries and make a union - that might help to get this kind of heterogeneous data reports for Sugar users without custom dev or employing analytic tools

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Reply
  • 0

    hello Ellen,

    that is heterogeneous data in the third column of the example, therefore IMHO that is a union of different reports, which is hardly doable with out-of-the-box Reports.
    However,  there might be Advance Reports functionality out-of-the-box, that allows Sugar Admins familiar with SQL to write SQL queries and make a union - that might help to get this kind of heterogeneous data reports for Sugar users without custom dev or employing analytic tools

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Children
No Data