Report Detail onformat script while hidden

[abbers_01]

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?

 

[gemma-the-husky]

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

then you can use the results directly

 

[abbers_01]

Deleted this entry