Search results for query: *

I need to suppress a group header based upon a summarized value in the group footer. My set up is like this: GH1: CreatedDateTime Details ID# @Time_In_Status @SumTimeToEnd GF1: @Ave_Time_In_Status_Week the Time_In_Status formula gives a simple number value. The SumTimeToEnd...

You will just need to put the same suppression formula in those fields as you did in the field being suppressed.

If you change the "n" into "h" in lbass's suggestion, it will automatically go to hours.

Sorry, the time will probably be in minutes or hours, I just removed that portion for simplicities sake. One question in regards to the formula, is that the rows won't necessarily be in order, meaning it might have gone 101 103 102 101 . . . etc. The result will end up in a row with the id# Thanks

I need to find the date difference between two different rows of data. MY data is set up like this: ID# Old New Date 101 A B 15/01/01 101 B C 16/01/01 102 A B 17/01/01 103 B C 17/01/01 And I would need to find the difference between the...

Subtracting the two time from each other will give you the amount of time in second {Time1}-{Time2} (his assumes that your field is purely a time with no date part) use: If {Time2} > {Time(19,00,00) then {Time(19,00,00) - {Time1} Else {Time2}-{Time1}

To delete Saturday, change the - DateDiff('ww',Currentdate,{Due_dates.Duedate},6) to - DateDiff('ww',Currentdate,{Due_dates.Duedate},7)

I am trying to join several tables through inner and left joins. Problem: Prob# Type Date 01 KE Jan 01 02 P Jan 05 Incident Inc# Date Plink 01 Jan 03 01 02 Jan 07 01 03 Jan 11 02 Audit Parent_Link FN 01 TypeOfProblem 01 Status 02 Status What I need to end up with is: Prob# Type PDate FN...

When I attempt to join three tables through left joins, I'm getting a syntax error of: Query Engine Error: 'DAO Error Code: 0xc03 Source: DAO.Database Description: Syntax error (missing operator) in query expression 'dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID LEFT JOIN dbo_Profile...

Sorry, this was supposed to be posted to Business Objects: Crystal Reports 2 Data Access. Please Ignore.

When I attempt to join three tables through left joins, I'm getting a syntax error of: Query Engine Error: 'DAO Error Code: 0xc03 Source: DAO.Database Description: Syntax error (missing operator) in query expression 'dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID LEFT JOIN dbo_Profile...