calculated field not shown in Excel when exporting report to Excel

[Psychadelic]

Hello,

i have created a report which calculates the labor hours from employees.
I have for example the following fields in my report:
Sum_Duration
Sum_Breaks
Sum_Normal_Labor
and
Sum_Overtime

all above mentioned fields are shown in the Excelsheet when exporting the report to excel, except for the field "Sum_Overtime".

Sum_Overtime is a textbox:
with as controlsource the following code:
=IIf(Sum([Normal_Labor])>7.5,(Sum([Normal_Labor])-7.5),0)

This works great in my Report, but does not show in the Excel when exporting it.

Anybody know how to solve this?

*Most of the data are generated with a query with joins on different tables. Some are calculated within the report.

 

[Psychadelic]

These are the details of the other calculated fields:

textbox: Sum_Duration
Control SourcE: =Sum([Activity_Duration])

textbox: Sum_Breaks
Control Source: =Sum([Breaktime])

textbox: Sum_Normal_Labor
Control Source: =Sum([Normal_Labor])

 

[DCrake]

It could be that the summation is done at report level and not at query level. To prove this add an unbound field to the detail section and r3efer to a bound field and try and print the report. See if it appears

 

[Psychadelic]

hello,

in Detail section within my report i have:
textbox: Activity_Duration
Control Source (referring to a column in my query): Activity_Duration

textbox: Breaktime
Control Source (referring to a column in my query): Breaktime

and

textbox: Normal_Labor
Control Source (referring to a column in my query): Normal_Labor

For the summation of my Overtime i do not have any textbox in the detailsection, because i have no overtime summation in my query. i just do the calculation of hours (when the normal labor hours are above 7,5 hours then there is overtime otherwise its 0)

I do not know if a summation works in the query and what i should write in the query for the summation of the overtime.

thnx for your help thusfar,

 

[Psychadelic]

still can't get this done.

What should i put in the query to sum up the Overtime hours?

this is my current SQL Query:
SELECT Qry_Report2_Overtime_Advanced_p1.Ref_Nr, Qry_Report2_Overtime_Advanced_p2_date.Ref_Nr, Qry_Report2_Overtime_Advanced_p2_date.Date, Qry_Report2_Overtime_Advanced_p1.Period, Qry_Report2_Overtime_Advanced_p1.Start_Time, Qry_Report2_Overtime_Advanced_p1.End_Time, Qry_Report2_Overtime_Advanced_p1.Area_Nr, Qry_Report2_Overtime_Advanced_p1.Activity_Code, Qry_Report2_Overtime_Advanced_p1.Exp, Qry_Report2_Overtime_Advanced_p1.Activity_Duration, Qry_Report2_Overtime_Advanced_p1.Breaktime, Qry_Report2_Overtime_Advanced_p1.Normal_Labor
FROM Qry_Report2_Overtime_Advanced_p2_date, (Qry_Report2_Overtime_Advanced_p1 INNER JOIN Areas ON Qry_Report2_Overtime_Advanced_p1.Area_Nr=Areas.Area_Nr) INNER JOIN Activity_Code ON Qry_Report2_Overtime_Advanced_p1.Activity_Code=Activity_Code.Activity_Code
WHERE (((Qry_Report2_Overtime_Advanced_p1.Ref_Nr)=Qry_Report2_Overtime_Advanced_p2_date.Ref_Nr))
ORDER BY Qry_Report2_Overtime_Advanced_p1.Ref_Nr, Qry_Report2_Overtime_Advanced_p1.Period;


I'd like to show the sum of Overtime hours in my Excel export sheet. Thanx

 

[GTA_doum]

Hello,
I was curious if a solution was found, since I'm facing the same issue ...