Crystal Reports Reverse subreport results

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Reverse subreport results

Post Reply

Post New Topic

Author	Message
Twizik Newbie Joined: 19 Apr 2012 Online Status: Offline Posts: 21	Topic: Reverse subreport results Posted: 21 May 2012 at 5:18am
	Crystal XI, I have a subreport that pulls notes for an invoice, the notes show up like: 1-25-2012 - completed work 1-23-2012 - worked on area 1-15-2012 - etc... I would like to flip those results over to read 1-15-2012 first.
	IP Logged


yggdrasil Senior Member Joined: 19 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 150	Posted: 22 May 2012 at 10:42pm
	Are these dates always the first part of the Notes? If so, I would create a formula extracting the substring as a date, and putting it in the same line as the note. You can then suppress it so it can't be seen, but still sort on it.
	IP Logged

Twizik Newbie Joined: 19 Apr 2012 Online Status: Offline Posts: 21	Posted: 23 May 2012 at 2:03am
	They are not always in the notes, but there is a data field with the note date, I will try to do what you said. Thank you Edit: Worked, Thank you Edited by Twizik - 23 May 2012 at 6:47am
	IP Logged

Printable version

Printable version

Forum Jump

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