Hi, Danny-
>
>Assuming you're using SQL as the data backend you may could do something like the following (also assuming you're using a data grid component) ...
It's a Fox back end, which I should have mentioned.
So, for displaying data, I'll select from my data, and then populate my denormalized datatable with the data I select in a straightfoward way. At least, that's been my thinking.
I guess the datagrid with gawdawful number of columns is my best route.
Processing in and out of the denormalized structure will be a bother, but that doesn't worry. I'm a little concerned with the quality of the user experience, though, since I've come to learn just how new to computers some of my audience is.
>I used the below table structure for my demo:
Thank you, though for this example. I'm just starting to use SQL Server for another client, and so have a lot to learn, and I know that this will be very helpful example. Thanks.
>Next, in order to get the task totals per row, you could use the code behind / ItemDataBound event of the grid... Summing each "Day" column to derive the value of the total column, per row.
Does this require a round trip to the server, though? I'd considered simply having a button to update the row and column totals so the user doesn't have to be bother with a round-trip every time they make an entry.
>Finally, for the "Daily Hour Total" footer I would reccomend a seperate routine to loop through the data object (DataSet, DataTable, Etc..) and append totals to an array with 32 elements (31 Days and 1 Total). Once you have looped through every record, use the totals in the array to populate the footer.
Yes, that's a good idea.
>I figure if nothing else, maybe a place to start : )
I appreciate the brainstorming help.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only