I have a report of custom report type in unlimited edition with 3000 records, When I try to export,customize or run the report. The data is not showing up. It is giving the message like the report is taking long. This report is created using custom report type as the base with three objects having relationships. Is there a way to extract the report data from this report using dataloader, workbench?

Please let me know your thought!..

Thank you, Prasanth

  • 1
    3000 records is not so much strange, i downloaded reports with much larger data. Maybe has some issues your sfdc instance. Anyway, you may export the data via dataloader or workbench. You just need to built the query following the logic of the report. – Klodj_Meta Nov 10 '16 at 17:23
  • Do you have issues with a subset? – Klodj_Meta Nov 10 '16 at 17:24
  • HI klod_Tema, This report is created based on three objects which I wonder how to bring it on query with the condition. – prasanthcheenu Nov 10 '16 at 18:48

That's not a lot of records, but regardless, here is one solution.

Depending on your report, one option would be to use the Data Loader which I believe can export up to 50,000,000 records.

Setup > Data Management > Data Loader

You can then enter your query as below:

enter image description here

  • Hi Jones, Since the report is a custom report type , it is taking fields from different objects and I find it difficult to bring that in query. – prasanthcheenu Nov 10 '16 at 18:57
  • This is the exact message I'm getting "The query for the preview is taking too long. Consider adding filters to narrow your results." – prasanthcheenu Nov 10 '16 at 19:19
  • 1
    @prasanthcheenu Then you'd need to add more filters to reduce the number of query rows. Sometimes this can be done by reducing the date. For example, if you're looking at the Current Year, look at the current Quarter and export 4 of those then just merge the spreadsheets. If you absolutely must have an export of everything in 1 file, you may need to look at writing a little SOQL query that gets whats in your report. – Dan Jones Nov 11 '16 at 8:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.