Question on Integration of SSRS 2005 Graphs into Sharepoint

I have been assigned to work on a dashboard (see jpg below) which will hook into our Intranet on SharePoint 2003. I have a few questions as in teh approach and what is possible by creating charts through SSRS 2005 report(s):

http://photopizzaz.biz/dashboard.jpg

1) what technique to use to show all 4 graphs simultaneously on the same page in SharePoint Webparts? Is WebParts the best way here to accomplish this?

2) Eventually, they want to be able to click through on the graph parts such as bars, etc. and perform clickthrogh using Reporting Services. How can this be seupt on graphs like these? What is the approach and requirements in Designer...how to do this?

Hi,

We did a dashboard using sharepoint services, and we segmented the screen in two different zones calling 2 static report containers, in which we set subreports. Therefore, as soon as you have defined your 2 containers, if you want to modify the content you don't have to set your changes in sharepoint, you just have to modifiy the subreport link.

For the link through graph parts, I use popup links.

Check your mail, I send you a printscreen

Regards

Ayzan

|||

I have never touched Sharepoint. My boss expects this done in 2 days. Could you walk me through in detail how you created the report containers and how you linked the subreports to them...and if you used one .rdl period for all the subreports or one .rdl for each graph? I am new to all this so any help would be greatly appreciated to help me walk through this for the first time.

When you create those containers, you're saying it just points to the .rdl via a link somehow and renders the report in that container?

Did you create one report then the rest subreports or all subreports? (I don't even think all subreports is possible, but just wanted to find out)

|||

Azyan,

When you say you defined 2 zones, you mean 2 columns in the WebParts layout for the .aspx page?

|||

First check

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=239997&SiteID=1

Ayzan

|||

Yes 2 columns ... 3 if you need a menu.

For each graph you will desing in SSRS, we tried to respect these dimensions

11cm/8cm to display 4 graphs -> 1cm between each graphs

1 2

3 4

23cm/8cm for 1 graph

1

2 3

or

1 2

3

For each line, we set "a container" which is a report calling 1 or 2 subreports. Once configured the containers (dimensions in pixel, tool bars ....), it will be not necessary to set them again. You will just have to modify the subreports called and republish the containers and the subreports.

regards

Ayzan