I am trying to execute a script on the detail section of a report that(calculates employee efficiency). However I don't want to see every entry, I just want the total which is displayed a footer.

So what I've done is I have reprot with an on Format script that does the calculation. And then I have the Detail visibility set to false. I guess it isn't formatting that section due to being invisible, so it never uses the script.

The script works fine if I don't have visiblity set to false. Is there a way I can get this script to be called, and still have the detail section invisible?

can you get this calculation built into the query, rather than coded in the report?

then you can use the results directly

Deleted this entry