Search results for query: *

IF {cr_trgraph1.Max_Spec}>={@Value} and {@Value}>={cr_trgraph1.Min_Spec} THEN 0 Else if {@Value}<{cr_trgraph1.Min_Spec} then {@Value}-{cr_trgraph1.Min_Spec} else {@Value}-{cr_trgraph1.Max_Spec} It is an if then statement seeing if {@value} is within spec, if it is not within spec then how...

An example of something that would be nice if I could write a formula like below: {@deviation} WHERE Temp. Sensors = TE003

I have roughly 50 rows and each has a formula field called deviation. I have assembled a process diagram in the footer and would like to have the some of the results from this formula in the footer. Temp. Sensors Deviation TE001 2...

On Change Of: Unit Serial Number Show Values: @SubShowValue This will show 2 Serial Numbers on the X axis (which is correct) but only one point for each Serial number. I think what is actually the case is each has multiple points being plotted at that exact point. I did another plot that...

Subreport is in the report footer of main report. Chart is in the report footer of the subreport.

She finally works! The group and group number change is what made the difference! The only thing that seems a bit off is that it plots all the points for unit 93 as 34.03. Which makes sense because that is the number that 'ShowValue' displays but in reality, the other points range from 0 -...

I dont think it is. I have the results showing in the detail section on the main report and each result has a number value showing. The results of 'OnChangeOf' and 'ShowValue' are both showing in the Group footer section A. On the first group, 'OnChangeOf' displays '93^' -93 is the serial...

It is a lot like a SQL query in which you can only return a single value. Here is a good article on it. http://www.tek-tips.com/faqs.cfm?fid=1377 The problem I had with it that really restricted its functionality for me was that I didn't know how to use the output of the SQL expression in a...

So I added the whileprintingrecords to the 'ShowValue' formula and made sure the boxes were unchecked. So that all looks good. Refreshing in the main report works better and I am not prompted for those values. A graph does not show up though. I subbed in another field in place of the...

My form names seem to be correct and are shown below along with the formulas. When I try to preview the chart, it still ask me for the values of 'Pm-@OnChangeOf' and 'Pm-@Show value' like they were parameters. 'OnChangeOf' formula whileprintingrecords; stringvar strOnChangeOf; strOnChangeOf...

I might consider a graphing package. For now I think I'll try to work around by having a graph that just plots all failures without specificying the failure mode. I can also have a graph for each failure mode and that will also eliminate the problem.

So I followed the guide(atleast I think I did) but I keep getting asked for 'Pm-@OnChangeOf' and 'Pm-@Show value) as if they were parameters when I try to look at the results of the subreport chart. UnitSN onchangeof formula whileprintingrecords; stringvar strOnChangeOf; StrOnChangeOf :=...

So the above formula seems to be checking out! Any thoughts on why formula field isn't showing up in the chart expert data sets?

whileprintingrecords; numbervar x := {@FailTime}; numbervar y; numbervar z := z + y; if {failurereport1.RunNum} = 1 then y:=0 else if {failurereport1.RunNum}>1 and previous({failurereport1.RunNum})<>{failurereport1.RunNum} then y:=previous({@TotalTestRunTime}) else if {failurereport1.RunNum}>1...

I do have a unique identifier and it is idComments. So I concatenated idComments and failure mode; this worked and plotted every point. The only caveat is now every point has its own legend entry and different color. Now I dont know if I can have the lemonade and drink it too, but itd be...

Thats fantastic! So it works almost perfect. The one flaw is that on multiple test runs, it keeps adding the 'Testrun' time. ID RunNumber TestRun(hr) FailureFound(hr) TotalRuntime(hr)100 1 5 1 1 100 2 10 2...

ID RunNumber TestRun(hr) FailureFound(hr) TotalRuntime(hr) 100 1 10 .5 .5 100 1 10 6 6 100 2 20 3 3+10 100 3 5 5...

ID RunNumber TestRun(hr) FailureFound(hr) TotalRuntime(hr) 100 1 10 .5 .5 100 1 10 6 6 100 2 20 3 3+10 100 3 5 5...

Sorry, I thought you just wanted to see the general code to check how I was doing it. Time til Failure ({JoinedComments.CommentTimeStamp} - {JoinedComments.RunStartTimeStamp})*24 -Failures logged in a table called Comments RunTime ({JoinedComments.MilestoneTimeStamp} -...

For time difference between two time stamps: ({JoinedComments.CommentTimeStamp} - {JoinedComments.RunStartTimeStamp})*24 A formula like this has been working for me. Honestly it seems to simple to me to work but it does. Also, there can be multiples of any test run because a system can have a...