Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Open AND Closed status for Date Range Post Reply Post New Topic
<< Prev Page  of 3
Author Message
MBurnettt
Newbie
Newbie


Joined: 14 Aug 2009
Location: United States
Online Status: Offline
Posts: 14
Quote MBurnettt Replybullet Posted: 14 Aug 2009 at 1:00pm
What would be my conditions?  Anything in the Status table, i.e. Open, Closed, etc?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Aug 2009 at 1:22pm

It is up to you but my guess is just use the dates. definately do not use the status as it is dynamic and only reflects the last update not any status it may have been in which is what you want.

Most likely your condition for Open is
did the Open_date fall in your paramter range (yes include, no exlcude) so  later this formual to make the fierlds be the real items from your report
 
if table.opendate in startdate to enddate then 1 else 0
 
Sum this formula field at ther report level fo get a total # of opened in range
 
Most likely your condition for Closed is
did the Close_date fall in your paramter range (yes include, no exlcude)
Close count formula
if table.closedate in startdate to enddate then 1 else 0
Sum this formula field fo get a total # of closed in range
 
 
Or is you want to use Running Totals (RTs) they can use a conditional inclusion. It evaluates to True or False. (If TRue include if False Exclude). This is placed in the Evaluate section of a RT under Use a formula (click onthe x-2 and palce in there)
You need 2 RTS. OPenCount and CloseCount
OpenCOunt
Field to summarize = chg_ref_num
Type of SUmmary=Count
Evaluate, select Use a FOrmual and add in
table.open_date in startdate to enddate (repalce with real field names)
Reset set to Never.
Place on report Footer.
repaet process for ClosedCount but change the formul to something like:
table.end_date in startdate to enddate
IP IP Logged
MBurnettt
Newbie
Newbie


Joined: 14 Aug 2009
Location: United States
Online Status: Offline
Posts: 14
Quote MBurnettt Replybullet Posted: 14 Aug 2009 at 2:08pm

I keep having problems with the select statement:

{chg.open_date} in (2009,08,10) to (2009,08,14)
OR
{chg.close_date} in (2009,08,10) to (2009,08,14)
and {chgcat.sym}
 
I get a ")" is missing error.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Aug 2009 at 2:17pm
you need parenthesis around the OR statement
(
{chg.open_date} in (2009,08,10) to (2009,08,14)
OR
{chg.close_date} in (2009,08,10) to (2009,08,14)
)
Not sure that you need the and {chgcat.sym} unless you need to filter by this for some reason.
IP IP Logged
MBurnettt
Newbie
Newbie


Joined: 14 Aug 2009
Location: United States
Online Status: Offline
Posts: 14
Quote MBurnettt Replybullet Posted: 14 Aug 2009 at 2:40pm
I still get an error that states the following:
 
The ) is missing.
 
I'm not sure what else it could be.  I'll play with it some more.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Aug 2009 at 7:38am
(
{chg.open_date} in Date(2009,08,10) to Date(2009,08,14)
OR
{chg.close_date} in Date(2009,08,10) to Date(2009,08,14)
)
and
{chgcat.sym} startswith ["BA", "Dev", "PMO", "QAA", "QAP.Other", "QAP.Performance Testing"]
IP IP Logged
<< Prev Page  of 3
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.015 seconds.