Skip to Content
0
Former Member
Dec 21, 2006 at 01:07 PM

Fetching data for las 12 Months

13 Views

Dear All,

We are having one custom table where fields are customer no, material no, year, month, quantity1.

Now I want to create a report which on entering customer no & material no in input should add up the values for last 12 months from the current date and display as one value.

Example of entries in database:

custmr no matrl no. year month qty1

1 1 2006 01 45.00

1 1 2006 02 25.00

1 2 2006 01 10.00

After executing the report I want the result as

custmr no matrl no. year qty1

1 1 2006 70.00

1 2 2006 10.00

and this addition should be done for last 12 months from the current date.

Warm Regards,

Nishu