Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

display rolling 12 month data in gridview

I am trying to replace an Excel spreadsheet and need to display rolling 12 month data with a gridview.  Here is some sample data.

tblProject                        
fldProjID,fldRegistration,fldStartDate,fldEndDate,fldHours
1,111ABC,25/07/2010,02/08/2010,16000
2,222ABC,09/08/2010,10/09/2010,24000
3,333ABC,02/09/2010,20/09/2010,24000
4,444ABC,20/10/2010,05/11/2010,32000

tblHours                        
fldHoursID,fldProjID,fldDate,fldHours      
1,1,01/07/2010,12000      
2,1,01/08/2010,4000      
3,2,01/08/2010,15750      
4,2,01/09/2010,8250      
5,3,01/09/2010,24000      
6,4,01/10/2010,22000      
7,4,01/11/2010,10000

I have attached a screenshot of how I would like the gridview to appear.  I have given two views and you can see how the months have rolled.

How do I get a gridview to show data in this manner?
screenshot.png
0
iepaul
Asked:
iepaul
  • 2
1 Solution
 
robastaCommented:
you can use datatables. Load your data (from the 2 database tables) into 2 datatables. Process each of the Registrations (tblProject records) to generate a 3rd datatable which you will then display to the user.
0
 
iepaulAuthor Commented:
Will I be able to edit the data when displayed like this?
0
 
robastaCommented:
Yes. With this approach, you would need to manually handle edits. I.E. when there is an edit, process it to map the data to the correct table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now