I have a report pulling out multiple child records, grouped by parent, where i want just the first child record based on created date/time. In SOQL i would use "order by CreatedDate and limit 1". Is there a similar thing i could do in reports to limit the child records?

  • If a tabular report is used, A dashboard can be used to limit the number of records shown there. In this scenario, a limit can be set on the report. Its not an answer but is a workaround. – Ganesh Mar 12 '13 at 14:20

Unfortunately, no. The Report Builder does not provide a LIMIT option. This will require doing your report through other means, whether a Visualforce page with SOQL or exporting the data to a different system.

You may be able to find something in the AppExchange.

  • my 2cents, I have used a program called Talend to write some pretty simple reports to excel. It may be a bit of overkill though. It is eclipse based so if you are used to ForceIDE it isn't the toughest thing to get a handle on. – jnoel10 Feb 15 '13 at 13:16
  • Thanks, I'm aware of talend. I too believe its an overkill. We need something simpler than Visualforce Reports and Out of the Box. – Ganesh Feb 15 '13 at 13:21

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.