Search results for query: *

Sounds fair enough to me... Thank you for all your help. I'll let you know how i go. BJ

Thanks Mufasa! This looks great... but... now i lose finding the max absolute values for each date. Is it possible to work this aspect into the query as well? Thanks so much for your help.

sorry for my ignorance, but i'm not sure i understand where this sub query fits into the query i already have... can you provide more assistance? thank you :)

How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0 2003-12-13 00:56:44.000 117.0 where...

sorry... i have another question! How would i go about converting this: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000 -9.0 37 2003-12-13 00:56:44.000 117.0 to this: xddatetime tilt54 pitch55 2003-12-13 00:56:43.000 -199.0 -9.0...

This works!!! Thank you so much for your help... Keep up the good work. Thanks heaps, B

i would like to find the max absolute value for each distinct sensorid and datetime. And then i want to be able to show these values in their original form, i.e whether they are positive or negative. there will be many entries for sensor id 54 and 55, but at different times throughout the day...

hi mufasa, i tried your suggestion and came up with this query: select xdsensorid, xddatetime, xdvalue, xdlongitude, xdlatitude from his_externaldata where abs(xdvalue) = (select max(abs(xdvalue)) from ((vmi_vehicles inner join ext_sensors on vunitid = sunitid) inner join...

Hi This is the original data: 37 2003-12-13 00:56:43.000 -199.0 37 2003-12-13 00:56:43.000 -156.0 38 2003-12-13 00:56:43.000 -9.0 38 2003-12-13 00:56:43.000 3.0 37 2003-12-13 00:56:44.000 117.0 What i would like to see some how is: 37 2003-12-13 00:56:43.000 -199.0 38 2003-12-13 00:56:43.000...

hi there! i have a bar chart which graphs the time a vehicle has spent at a specified location. At the moment i can only figure out how to display the data values as 20.45 (20 hours and 45 minutes) - i would like to display it as 20:45. Is this possible??? Thanks, B

...integer, Longitude numeric(18,10), Latitude numeric(18,10), LonLatDescr varchar(250), xdID integer ) insert into #DataList select #DayList.*, VT.[Description], S.sSensorTypeID, S.sDescr, STM.stmCalculatedValue, STM.stmCalculatedValueDescription, XD.xdDateTime, xdValue...

...integer, Longitude numeric(18,10), Latitude numeric(18,10), LonLatDescr varchar(250), xdID integer ) insert into #DataList select #DayList.*, VT.[Description], S.sSensorTypeID, S.sDescr, STM.stmCalculatedValue, STM.stmCalculatedValueDescription, XD.xdDateTime, xdValue...

i have solved this by using this formula in the suppress section. whileprintingrecords; Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * ({?Visitminimum} - 0.01)then true thank for all your help :)

hi all, this is what i want to achieve: (Location) (From) (To) (Visit Length) 1/5/03 XXXXXX 00:00 07:30 07:30 XXXXXX 08:16 17:31 09:15 XXXXXX 18:02 00:00 05:58 2/5/03 XXXXXX 00:00 07:00 07:00 XXXXXX 08:37 17:31...

...if {@DisplayVisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true it says 'a time is required here' - the cursor is in front of totext. @VisitLength : whileprintingrecords; if {@VisitIn2Shifts}...

...if {@VisitLength} <= totext(truncate({?VisitMinimum}),&quot;00&quot;)&&quot;:&quot;& totext(val(right(totext({?VisitMinimum},2),3))*60,0) then true and it says 'a number is required here' and the cursor is at the start of totext. i am using @VisitLength to calculate the length and am also...

...suggestion - but it asked for a number??? this is what i have tried and works for some cases and not others. Local numbervar ONE_MIN := 1 / (60 * 24); if {@VisitLength} < ONE_MIN * {?Visitmin} then //suppress visit length less than minimum true the only time it doesn't seem to work is...

i tried this: {@BreakDuration} > {@DisplayVisitMinimum} where {@DisplayVisitMinimum} is ToText({?MinVisitLength},0) + &quot; min&quot; + iif({?MinVisitLength}<>1,&quot;s&quot;,&quot;&quot;) and it came up with this error: 'This formula cannot be used because it must be evaluated later' Any...

...then TotalBreaks:=TotalBreaks+{@ExcessBreakHours}; nHours:=truncate({@ExcessBreakHours},0); nMinutes:=truncate(({@ExcessBreakHours} - nHours) * 60,0); nSeconds:=truncate(({@ExcessBreakHours} - nHours - nMinutes) *60 *60,0); if nSeconds>=30 then nMinutes:=nMinutes+1; if nMinutes >...

I don't seem to be able to do this because the @VisitDuration isn't in the selection formula list. Why would it not be in there? Thanks, B