how to calculate avg(footer) of computed avgfiled
-
Hi all, i am using sql server 2005. let me explain the scenario. i have report where i bring perticular employee totalcall and workeddays then in third field i wrote an expresion to evaluate avg call that is totalday/workeddays and all the three field i displayed in table now requirment is in footer i should get avg of avgcall calculated please suggest some idea thank you
regards imran khan
-
Hi all, i am using sql server 2005. let me explain the scenario. i have report where i bring perticular employee totalcall and workeddays then in third field i wrote an expresion to evaluate avg call that is totalday/workeddays and all the three field i displayed in table now requirment is in footer i should get avg of avgcall calculated please suggest some idea thank you
regards imran khan
Look into the compute keyword in BOL. Compute avg(avg(calltime)) Caveat - this will give you 2 tables in your dataset when using dataset.fill
Never underestimate the power of human stupidity RAH