Search results for query: *

You are right and awesome! screenshot below...

so... 7 people have been onsite today and 1 is onsite now.

right he came back, so only 1 person is onsite now. it shows 7 onsite now (currently)

Ok, did that. getting same total as the total been onsite. Screenshots below...

ok, its attached. do you need the sub report as a separate attachment?https://files.engineering.com/getfile.aspx?folder=8662620b-851c-4f5e-9c2e-da7446f2c6f8&file=OnsiteNow_3.rpt

there is no personal info in the test db

can i send you a copy of the report to look at? i can make it downloadable from dropbox. i can also include a backup of the test db if needed.

only 1 formula in the sub-report using shared variable, @onsite and 1 formula in the main report referencing the shared variable

is this correct?

what do you mean by shared variables?

ok, that cleared that error up, thx! screenshot below shows the results, but the count onsite now is 0.00 (i'll format that once it's good), should be 1...

i'll do that right away

i removed it from the main report (it was blank) and get same error.

Whileprintingrecords; Shared Numbervar onsite; If remainder(sum({READER.TIMEATT},{EVENTS.EMPID}),3)=1 then onsite := onsite + 1; in the subreport

Ok, all that is done. When i preview the report i get the error below.

I get an error when saving the @onsite formula. says there must be a group that matches this field, and the following is highlighted... sum({READER.TIMEATT},{EVENTS.EMPID}). Do i need a group for reader.timeatt? oops nevermind.

I will give it a shot.

i'm willing to give anything a try. not sure how to do a subreport

Do you think the issue is that the sql expression is happening at the database level nd not the report level? Seems like it should be different for each record in the report to work?

Update the sql expression yields 9, but the onsitenow formulat is returning all nulls with the remainder,3