Sidebar: Uniquely defined Hierarchical Data

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.

All Forums

Development Tools

Reporting Services Development

Sidebar: Uniquely defined Hierarchical Data

Author

Topic

LaurieCox

158 Posts

Posted - 2007-09-11 : 16:04:26

Hi,

I have been trying to get help on a complicated stored procedure over in the Transact-SQL (2000) forum in three separate threads: first, second, third*. Being that the final result is going to be done in reporting services I thought I'd ask if I was on the right tract with my current solution over here.

I am not going to repeat the description of the problem in this post. You can get the best description (I think) in the OP of the third thread.

… pause to allow reading of OP …

Ok … I am completely new to reporting services, so I have no idea about its functionality. I am wondering if I can format the report in reporting services from the table #ValidPaths or does the thing need more manipulation in the sp?

Run the script in the second post of the third thread to get the data in #ValidPaths.

I want the report to display this (the numbers refer to the id columns in the tables):


Library: TestLink3
   Problem: Productivity-(P:6)- Productivity
         Objective: Access-(O:1265)- Access to Community Resources
 
  Problem: Supportive Needs-(P:7)- Supportive Needs
         Goal: Community-(G:427)- Community Participation Level
              Objective: Access-(O:1265)- Access to Community Resources
 
              Objective: Activities-(O:1266)- Participation in Community Activities
 
         Goal: Social-(G:428)- Social Interaction Level
              Objective: Activities-(O:1266)- Participation in Community Activities

Thanks,

Laurie

* I hope no one considers this spamming. Each new thread clarified the problem (I think) and I have made sure that I have linked between all threads. I will also check the threads for any responses. This thread is just a preemptive strike in case I am actually done manipulating the data in the SP and am ready to learn Reporting Services.

jhermiz

3564 Posts

Posted - 2007-09-12 : 22:13:02

quote:
Originally posted by AlgaeSea

Hi,

I have been trying to get help on a complicated stored procedure over in the Transact-SQL (2000) forum in three separate threads: first, second, third*. Being that the final result is going to be done in reporting services I thought I'd ask if I was on the right tract with my current solution over here.

I am not going to repeat the description of the problem in this post. You can get the best description (I think) in the OP of the third thread.

… pause to allow reading of OP …

Ok … I am completely new to reporting services, so I have no idea about its functionality. I am wondering if I can format the report in reporting services from the table #ValidPaths or does the thing need more manipulation in the sp?

Run the script in the second post of the third thread to get the data in #ValidPaths.

I want the report to display this (the numbers refer to the id columns in the tables):

Library: TestLink3
Problem: Productivity-(P:6)- Productivity
Objective: Access-(O:1265)- Access to Community Resources

Problem: Supportive Needs-(P:7)- Supportive Needs
Goal: Community-(G:427)- Community Participation Level
Objective: Access-(O:1265)- Access to Community Resources

Objective: Activities-(O:1266)- Participation in Community Activities

Goal: Social-(G:428)- Social Interaction Level
Objective: Activities-(O:1266)- Participation in Community Activities

Thanks,

Laurie

* I hope no one considers this spamming. Each new thread clarified the problem (I think) and I have made sure that I have linked between all threads. I will also check the threads for any responses. This thread is just a preemptive strike in case I am actually done manipulating the data in the SP and am ready to learn Reporting Services.

This is a normal typical question for anyone new to RS. Your problem is very simple as this is exactly what RS can do. In fact the indentation that you have stated can be simulated using GROUP BY rows as well as a final details section. Each indentation is a group by. They follow one another I assume because you have foreign keys.

Jon

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

LaurieCox

158 Posts

Posted - 2007-09-17 : 15:14:06

Hi Jon,

Thanks for the response.

I think my problem is a little more complicated than what you suggested. I do not have an obvious grouping column. I think that is part of what I am trying to do in the stored procedure I am writing.

... Anyway I have made some progress, but am still in need of help. I have continued my search for said help in this thread

Laurie

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources