Crystal Reports sorting by dates

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

Topic: sorting by dates

Author	Message
adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Topic: sorting by dates Posted: 09 Aug 2010 at 10:24pm
	Is there a function i can use to display the products that have order dates next to them 10/08/10, all other product have --/--/--, at the moment all products are displayed rather than just the one with dates.
	IP Logged

FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 10 Aug 2010 at 2:04am
	you can suppress the detail line if: '--/--/--' in {table.field}
	\|< /\ '][' ( )
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 10 Aug 2010 at 2:34am
	when entering '--/--/--' in {mrp.mrecdate} it replys a date and time is required here error? Is it possible to use an IF statement of some sort? thanks
	IP Logged

FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 10 Aug 2010 at 8:32am
	didn't realize it was a date field. Try: '--/--/--' in totext({mrp.mrecdate}) -----EDIT----- Maybe I didn't understand correctly. You want to only show those purchase orders with the date 10/08/10? or with any date other than --/--/--? Edited by FrnhtGLI - 10 Aug 2010 at 8:34am
	\|< /\ '][' ( )
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.016 seconds.