I need to Store History information in Qvd to Display a report Of Customers who are Active and INActive, The Database is not Storing the history information hence i need to store in Qvd.
Data :
Customer Status Date
A Active 01/01/2009
B Active 01/01/2009
C Active 01/01/2009
A InActive 02/02/2009
B Active 02/02/2009
C InActive 02/02/2009
A Active 04/04/2009
I need to store Data in this format and Also I need to create a report in below format
Report :
A Active
C InActive.
We need to display those Active Customer who has been InActive Once and Also we neeed to display InActive Customers.
