Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-09-23 : 09:39:04
|
| Hi Team.I hope I’m posting this in the right section but here goes.I have been tasked to create a Projects table and SSRS report.I have no idea where to start so i was hoping 1 of you can point me in the right direction.I think I should at least start with the designing of the table/s structure.Once all data has been captured the report should look like this- ProjectName StartDate EndDate Status - Tasks - Task1 StartDate EndDate Status - Task 2 StartDate EndDate Status - Risks - Risk1 StartDate EndDate Status - Risk2 StartDate EndDate Status - Actions - Action1 StartDate EndDate Status - Action2 StartDate EndDate StatusThey require a hierarchical view of each project.Once the table has be created i'm might need here building a SSRS report as well.Can someone point me in the right direction here? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 13:51:22
|
| what you need is to have a table storing the hierarachy wise details flattened out.Are Project,Action,Task,... values stored in seperate columns? |
 |
|
|
|
|
|
Best Table structure