SQL Report with User Input on Each Row?

[thec0dy]

I am trying to figure something out. I have two different databases that I am querying data from. One table has employees the other table has a list of times of service.

Now I am wanting to use this data to create some kind of scheduling web tool. It is a simple concept. You have the employees listed on the left. To the right of the employee there would be a drop down box with hours they should work for that day that can be selected. 0, 0.5, 1, 1.5 hours, ect. This column would be totalled up.

Once that is done the total is compared to the times of service. If it is less than that is good. If it over that is bad.

SQL Report builder gets me the data for "reporting", but there isn't anything I can find to add the drop down boxes and total them up for each employee, or row in the list. Is there a way, or is there some software I can download / purchase?

I am new to this, so I am experimenting.

Thanks!

 

[thec0dy]

Here is a screen shot.