Value based on date param?

[Former Member]

i work for a electric utility and we have customer meter readings imported into the database on a daily basis. I would like to be able to calculate the daily use based on (2) date parameters (BEGDATE) & (ENDDATE). Any ideas how to approach this?

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

Try to apply the fileter condition like this

>={?BeginDate} and <={?EndDate}

Now insert a summary in the report footer on meeter readings like this

sum({Meter Reading})

Regards,

Raghavendra.G

[Former Member]

Hi,

Another Way is to give range operator in Record Selection

For eg:

IN {?BEGDATE} TO {?ENDDATE}

Regards,

Sathish

[Former Member]

Thank you for the suggestions, but my problem is not on how to get the parameters for the Date prompts working, it is once I get the dates pulled in. How would I then pull the readings that correlate to the dates prompted? ie; Every date has a given reading assigned to it....06/01 = 200....06/02 = 225....06/02-06/01 = 25 kWh of usage.