Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Records for 1st Quarter Specific Year Post Reply Post New Topic
Author Message
bremen
Groupie
Groupie
Avatar

Joined: 28 May 2013
Online Status: Offline
Posts: 93
Quote bremen Replybullet Topic: Records for 1st Quarter Specific Year
     Posted: 16 Feb 2015 at 5:05pm
I am designing a report to look at inventory usage from specific years. 

I would like it broken down by quarter.  I have this formula, but it is obviously pulling data from all first quarter usage

if  {PARTSSOLD.SOLDDATE} in Calendar1stQtr
then
{PARTSSOLD.QTYSOLD}
else
0



How would i adjust this to show me 1st quarter from the year 2014?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Feb 2015 at 3:49am
if  {PARTSSOLD.SOLDDATE} in Calendar1stQtr
and datepart('yyyy',{PARTSSOLD.SOLDDATE})=2014
then
{PARTSSOLD.QTYSOLD}
else
0
IP 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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.