Joined: 15 Oct 2009
Online Status: Offline
Posts: 1
Topic: Report displays all, but I only need most recent Posted: 15 Oct 2009 at 8:40pm
I have a report that is displaying more than one result but I only want the last (newest) result to post. I can't seem to write a formula that isn't a custum formula. I'd like to use the Select Expert to display only the records that I want by choosing 1 or 0 but custom formulas do not display in the Select Expert. Any suggestions??
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 18 Dec 2009 at 7:21pm
I have had to do this several times. What I normally do is create a group and sort the data in asc order. Then do a summary and you can choose the topN record for that field in the group footer. Then move your pertinant fields into the header row and surpress the details row.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 19 Jan 2010 at 7:34am
or you could depending on where you need the data, just display the group footer...most sorts are from oldest to newest, so the newest record is the last one, and this is the one displayed in the group footer....
Or reverse the sort order and display in the group header, and suppress the details.
Joined: 23 Jan 2010
Location: United States
Online Status: Offline
Posts: 2
Posted: 23 Jan 2010 at 4:21pm
It depends on what the data looks like when it is returned. It is possible to accomplish this in a variety of ways. I suggest that you post a sample of your data.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
