Search results for query: *

Absolutely Perfect, Thanks once again Lbass :-)

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...

Sorry, The second issue (Sort Order) is addressed in this post: http://www.tek-tips.com/viewthread.cfm?qid=1257961&page=1

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...

That worked great. Thanks a million. Is there anyway to "order by" the results of the above formula? (Placed in a group footer)

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...

Believe it or not I try records with both suppressions and neither works now.

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...

Thanks again it worked excellent.

Actually you did follow, perfectly. Could you explain a little about the function you used like what does the 01,01 do, I would really appreciate it.

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...