Observation
When I rearrange and use the following as my formula, I get the expected "1" when the first record is an EM. When I remove the // to incorporate the rest of the formula the result for the first record changes to "0".
whileprintingrecords;
numbervar diff:= 0;
numbervar cnt;
if...
Still null on first record. I am trying this:
whileprintingrecords;
numbervar diff:= 0;
numbervar cnt;
if {WORKORDER.ACTSTART} >= previous({WORKORDER.ACTFINISH})then
diff := DateDiff ("n", previous({WORKORDER.ACTFINISH}),{WORKORDER.ACTSTART})/60;
if (onfirstrecord or
diff > 0) and...
The results in the footer are perfect, I have just one more issue.If the first record of the report is an 'EM', there is no previous record to do a date diff, so it is not counting it. I can't seem to figure out the proper syntax to count the first record if it is an EM.
I tried something like...
I am using Crystal 8.5 with an Oracle 9 database. I am having trouble with a formula which is carrying data into the footer and casuing my result to be inaccurate.
The report groups all records from one peice of equipment for a particular date range of workorders.
The first formula is placed in...
I figured it out. I used:
not ({WORKORDER.LEADCRAFT} like {?Trade})
in the x-2 and defaulted my discreet value to be *.
I should have figured it out in the first place ...sorry.
I am using Crystal 8.5 with an Oracle 10 database.
I have a report which has three parameters a date range, A location field and Leadcraft selection. The leadcraft selection basically says show me all records that contain that leadcraft.This is a parameter which gets used to supress details...
This is a continuation of this thread (http://www.tek-tips.com/viewthread.cfm?qid=1257961) but since it is diifferent, I decided to start a new thread.
I have Crystal 8.5 with and oracle 10 database.
I Have a formula field I want to sort my report by. The problem is, it does not show up in my...
I have come up with a way to manipulate the data which is more “normalized”. Although the result is not accurate, the sort order is about 99% accurate. If I can get this field to work I will display my original formula but sort by and suppress this normalized formula. Here is what I have:
The...
I am not familiar with using a stored procedure in report writing. Is there a thread(s) or a resource you could recommend? The scope of this seems to be quite complicated. I am selecting on two parameters including a date range and am reporting on averages of many records (including...
The "previous" function has caused me grief with other formulas. I am having trouble displaying this result in a chart also. I am assuming its also because of the same reason. Do later versions of Crystal address this issue?
Hi I am using Crystal 8.5 with an Oracle 10 database. I have a report which uses a formula based on the results of other formulas. I am trying to sort or order the report based on the results of the formula but I cannot see it in the TOP N/Sort Groups expert. I will try and explain what I have...
I am using Crystal 8.5 with an Oracle 10 database.
I have looked at many threads and cannot figure this one out. I have a formula:
WhilePrintingRecords;
numbervar sumhrs/({@sum workorders});
that is placed in the group footer to give me an average of records from another formula. It works great...
I am using Crystal 8.5 and am having trouble suppressing a details sections with an OR statement. My statement is
{WORKORDER.STATUS} <> 'WAITASGN' or {WORKORDER.WO13} <> 'Y'
and is placed in the X-2 box of the suppress button.
Whichever one is listed first works but not both. What am i doing...
I am using Crystal 8.5 with an Oracle 9.0 database.I am trying to show the "week #" of a date in which a task has been scheduled. I have found multiple ways of doing this but I am struggling with dates that span previous or subsquent years. For example a task scheduled for January 13th 2003...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.