How to report same record id's in row

Question

Dear Code Masters,

 

I believe this mail meet you well and in good condition.

 

Please i have this challange and i will appreciate your solution to resolve it, i have a database called tbl_Leavesheet that contain the follo record as shown below:

 

 

i was asked to write a report that will keep the same record in one row, their startedate and stopdate in different colun while their nodays will accumulate and display in another column of the same row, it should look like the one below:

 

all sample code is strongly appreciated.

 

thank you all 

Answer 1

You can create framed Web page. Then in the frame which should depict the latest feed contents you load HTML which automatically reloads every, say, 30-60 seconds (don't do it more often unless you're absolutely sure that client can refresh contents in time much shorter than 1 second anywhere in the world).

Make sure that this HTML is small and loads very quickly or otherwise users will have discomfort looking at the page which spends significant time in incomplete state.

If you can't load it quickly then make a background process which does the heavy job processing latest feed state, and simply creates fixed HTML which would then quickly be presented to users on every reload.

Zoran

Answer 2

Hi,
use AJAX to refresh the specific part of the page.........