Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Reporting Services

  Asked By: Nicholas    Date: Jun 09    Category: Sharepoint    Views: 665

Does anyone have, or know of, a good post on using Web parts on SPS2003 for Reporting Services, SQL 2005?



3 Answers Found

Answer #1    Answered By: Tejaswani Barve     Answered On: Jun 09

You could use a Page Viewer Web Part to view specific SRS pages. You could
probably also point a Data View Web Part at SQL and render stuff that way. I've
never done the latter, but I would imagine it would work.

Answer #2    Answered By: Harshita Padwal     Answered On: Jun 09

There is also a report viewer web  part. Or really, two web parts. One web part displays a list of reports to which the logged on user has access, and the other displays the report itself when selected from the list in the first web part.

Answer #3    Answered By: Jennifer Jones     Answered On: Jun 09

The two web  parts provided by Microsoft are called the Report Viewer
and the Report Explorer. To me, it looks like they built the Report
Viewer by extending a Page View web part to be connected link selected
in the Report Explorer (which in turn just lists the reports in a
folder on the SQL Server 2005's Reporting Services web page).
msdn2.microsoft.com/en-us/library/ms159772.aspx explains how to
install them.

I found the default web parts  pretty disappointing because it's very
hard to get a good  view of the chart within the Report Viewer without
having to set the web part to a static (and very large) size.

I just found this article that tries to address the problem:
http://aspalliance.com/729 . The code is in VB. Go figure. I dodged
the problem by writing a web part that loaded up an image button with
a tiny image of a report's chart into a panel, and then had the users
select the report they wanted and drill through directly to the
Reporting Services pages by clicking on the image buttons.

If you have some money to spend, you could look at Decision Support
Panel (www.dspanel.com). If you have even more money to spend, the
way to go seems to be ProClarity (www.proclarity.com). They have a
product called ProClarity for SharePoint Portal Server, which appears
to be a free add on (once you buy ProClarity 6).

Didn't find what you were looking for? Find more on Reporting Services Or get search suggestion and latest updates.

Related Topics:



Related Post