Tell me more ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 3 down vote favorite

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?

share|improve this question
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 at 14:20

1 Answer

up vote 4 down vote accepted

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.

share|improve this answer
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 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 at 13:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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