Skip to Content
Aug 12, 2011 at 07:15 AM

power consuption report (pm)



my requirement is to show the power consumption of each generator we have 4 .

and also the difference.




ex : 1.07.2011 is starting reading of that month (.this is a) .

for 2.07.2011 it should subtract with 1.07.2011 (this is b)

for 3.07.2011 it should subtract with 1.07.2011 like this(b-a) here my problem is, this initial date have to change based on month (i.e for every month 1st is the initial reading all days of that month should sub with that day only).

i had written select query and filtered the only power consumption readings only ...

for me not getting how to write condition for this ....

it is regarding to pm i had used table equi ,imrg,imptt

Thanks a lott

Moderator message : Spec dumping not allowed, show the work you have already done. Thread locked.

Edited by: Vinod Kumar on Aug 12, 2011 1:18 PM