Insert Your Logo

Search Results for '100464'

•    

  24540

  points

  Exception Reporting (outer joins) Under Consideration

  There needs to be the ability to run exception or without reports. For example: show me all Accounts without an Opportunity. It would also be nice to include the total number of accounts in the report so % comparisons could be made. For example: of the 1000 Accounts in salesforce.com, 350 did not have Opportunities, hence 35% of all accounts are without an opportunity.

  108 Comments  •  Posted by  ToddJanzen  to Reports & Dashboards, Application Framework Oct 12, 2006
•    

  1290

  points

  Outer joins as "with and without" relationships in Custom Report Types Delivered (Archive)

  Make it possible to have a relationship between a parent and child objects when building a Custom Report Type that allows the return of parent records when they are no child records. This would be like a database outer join, and allow reporting when there may or may not be child records - something not possible today. Today's Custom Report Types allow only the return of a parent when there are child records. For instance, if reporting on opportunities, we want opportunity data whether or not there are products attached. This isn't about "exception reporting" covered in: http://ideas.salesforce.com/article/show/23676/Exception_Reporting_outer_joins

  17 Comments  •  Posted by  tt  to Reports & Dashboards, Delivered Ideas Jan 4, 2008