See the above image. But now my problem is i am completely out of idea in doing this. Coz i am having two tables and need to retrieve the necessary data's from those table in order to display the report like the above format.
Here is my code to achieve this...
* the iapplicationno is the primary key of the icustomer table and foreign key of txioninstall table.
* a single customer can have more than one entry in txioninstall table,according to the month and year he paid.
* i just need to display the details of customer like in the picture(please see the link), so first i retrieve the aplplication no from icustomer table and look for relevant entry in txioninstall table, and i am able to get the data's but i dont know how to do this. I am having 12 fields representing 12 months and unable to print the value in it.
Please guys shed some light on this issue.. I am very thankful if you'd help me guys...
Never try to be a hard-worker. Be a smart-worker.