Joined: 21 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Topic: Last 30 days Posted: 21 Mar 2008 at 1:50pm
hey every one I am green with crystal , I need help getting the last 30 days of data from a report. I can create an SP in SQL, but is there a quick way to do this in crystal...
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 21 Mar 2008 at 2:06pm
If you're new to CR, you should check out my Encyclopedia book to get up to speed on all of its features. The formula you are looking for is simply Last30Days. You could use this in the record selection formula like this:
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 21 Mar 2008
Location: United States
Online Status: Offline
Posts: 2
Posted: 24 Mar 2008 at 12:11pm
Hey Brian FYI your book is on the way.... Anyway when I put this into the record selection formula it doesnt work, Like it is not a key word... Am I missing something, I have to create three reports that go back 30 60 and 90 days
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
