Skip to Content
0
Former Member
Feb 25, 2009 at 04:39 AM

data extraction fron db and pull to smartform

23 Views

Hi friends,

I need ur help. I have 10 yrs employees data. I have upload only basic salary through bdc in database table.

For example:

(yr/month) (12% Basic Salary)

Apr 2007 1500 -


>Uploaded data

may 2007 2200------>Uploaded data

june 2007 2356------>uploaded data

"

"

jan 2008 3120------>uploaded field by bdc in every month

feb 2008 7894------->uploaded field by bdc in every month

Every month i'll upload basic salary and every yr data will change but data will store in same table, for that i made primary key year.I m showing it in smartforms.

When 2008 financial yr started year will be change, it would be

Apr 2008 5442------>Uploaded data

may2008 2352------->Uploaded data

"

"

mar 2009 5555------>Uploaded data

My requirement is only current yr data will be extact from database table not previous yr data.

Plz help me.

Regards,

Swapnika