All Ideas

Idea Details

Upvote Downvote

Post an Idea

10,780 Points

Open - Not Planned

Moira Heath

Create Report based on a SOQL query

Operational Reporting

I would really like to have the option in Salesforce to create a report straight from a SOQL query. This would be excellent for those more complex reports where the Custom Report Types are not good enough, example for queries that use the NOT IN clause.

Merge Idea · Flag

Comments ( 270 )

Sort By

Jake Backues - 12 days ago

Try filtering a report with a HAVING clause when usng groups, would be so easy to put in a SOQL query and get back some records.
- Flag
Alex Ramo - 19 days ago

Bumping this up!
- Flag

Julian Barton - 1 month ago

This would be so useful. Salesforce native reporting is frustratingly limited compared with other, older, tools. Adding the ability to build reports off a SOQL query would remove many of those limitations. This would also reduce the number of custom formula fields that are only created to roll-up/reference data across objects.

Flag

Drew Peterson - 1 month ago

Why is this not implemented yet? Seems like a pretty simple ask.
- Flag

Carly Wickell - 1 month ago

Agree with others - I have use cases where I need to be able to pull reports for my team and the current reporting framework (even custom) is still too limiting and we are having to create workarounds. This Idea has been open for 11 years - please take a look at implementing this, Salesforce Devs!

Flag

Jerry Alexander - 1 month ago

Salesforce Reports have come a loooong way, but have sooooo far to go!

They could save themselves some stress by allowing us to build our own reports from our own queries.
Report Types are limited and only allow 3 levels.
Give us the full power of reports that we need!

Flag

Enrique Muñoz - 2 months ago

Really needed!!!
- Flag

Aubrey Weber - 2 months ago

I would love to have it! My use case is that I'm looking for contacts with several different titles. Titles can vary, which requires a lot of filter criteria (ie, CTO vs Chief Technical Officer"). Being able to do this in a SOQL query from reports itself would make this a lot easier for me - and make my users happy!

Flag

Adi R - 3 months ago

Hi everyone an app is now available at appexchange which makes is possible to export csv based reports using a SOQL query >> https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000FMnZuUAL

Flag

Mathilde Castadot - 3 months ago

Yes it would be super useful :)
- Flag
Drew Peterson - 3 months ago

Please deliver this feature. THIS WOULD BE FANTASTIC.
- Flag
Madhu Ilapakurty - 4 months ago

This simplies a lot of reporting constraints and adds flexibility to reports and dashboards. Will be very useful for admin tasks
- Flag
Clay Hartman - 4 months ago

This would be great! I need to create a report with constants/static text and there is no way to do this in reports. This can be easily accomplished if we could use SOQL to source reports.
- Flag
Gideon Hertel - 4 months ago

I feel like this is a no-brainer. It would nearly eliminate all the limiations that the current report builder has.
- Flag
Bill Cali - 4 months ago

Great idea! You can use SOQL queries in the Developer Console but have no way of extracting those query results into Salesforce as reports.
- Flag