Can't find Report Viewer/Explorer WebPart (SP v3+SQL 2005)

Hello all,
I'm new with SP v3 and the Reporting Services of SQL Server 2005.
I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.
Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.
Cheers
MarcHave you uploaded the web parts to the SharePoint site? I don't think they
come preinstalled with SharePoint.
On the server with SQL Server 2005 installed, you should find the web parts
in a cab at
C:\Program Files\Microsoft SQL Server\90\Tools\Reporting
Services\SharePoint\RSWebParts.cab
Copy the Cab file to your SharePoint server and install it using Stsadm or
any other program you use to deploy web part packages (cabs).
Kaisa M. Lindahl
"Marc" <M.Thierer@.web.de> wrote in message
news:1139324142.873377.225310@.g43g2000cwa.googlegroups.com...
> Hello all,
>
> I'm new with SP v3 and the Reporting Services of SQL Server 2005.
> I did a prototyp report and show it with "SQL Reporting Services
> Report"-WebPart, but I can't find the WebParts Report Viewer and
> Explorer in the WebPart Gallery.
> Please, could somebody give me a clue where the problem could be, or
> how I could isolate the problem area.
>
> Cheers
> Marc
>

Cant drill through from one report to another with report viewer

Hello all,

this is my first post to asp.net!

I am having a problem getting a drill through to work in the web report viewer. In report1 i have a table with groups and on the key field i want to drill down through i right click >properties> navigation and select jump to report. From there I select the predesigned report2 from the list and add the appropriate parameters.

It works fine when i test it in the dev enviroment and when i deploy it to the report server it works fine there. but when I debug and run it through the website itself and go to the report then click on the hyperlink it goes to a "page cannot be displayed' page.

I have been working on this for 2 days googling the heck out of it and testing several scenarios, but to no avail. I'm sure its something stupidly simple.

has anyone else had this problem?

Help!

thanks so much!

HI,CodeSquirrelMonkey:

Make sure you have put the target report in the right place which is defined in the drill through setting.

Second, you can have a try to open the target report directly on the website.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi Rex,

Thanks for the response. I did make sure that the drill through report is in the right place and it didnt work on the live site either.

I did get around the problem though. I created an fresh new aspx page and dropped a fresh report viewer on it and tried it again and it works fine now. I did a comparison of the two pages' code and couldnt find anything obvious that could have caused it. It does work fine now.

the only other thing was to make sure that the page_load has an if not ispostback on it so that it would refresh and drilldown properly.

Thanks again

Craig