Crystal Reports How DO I ?

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: How DO I ?

Author	Message
Datahead Newbie Joined: 19 Oct 2009 Location: United States Online Status: Offline Posts: 6	Topic: How DO I ? Posted: 23 Nov 2009 at 11:19am
	I just need a subreport to show the three newest, ( latest ) Notes entered into the database by date entered, by client ID. The "notes" field is a memo field. AND only for that specific client. WHen I use "top 3" in SQL statments I get the three latest dates, not by client. Any ideas? Edited by Datahead - 23 Nov 2009 at 12:01pm
	Datahead2009
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 24 Nov 2009 at 12:53pm
	Do you a link to the subreport with a 'client id' of some sort?
	IP Logged

saoco77 Senior Member Joined: 26 Jun 2007 Online Status: Offline Posts: 104	Posted: 24 Nov 2009 at 1:55pm
	Look at the Top N function to see if that will work
	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.