the integrated report viewer web part to display reporting services reports in sharepoint is good... but limited!
The web part do not support a dynamic report selection + connected parameters at the same time.
My page display a filter web part and the list of the reports from a document library, I try to connect both web parts t o the report viewer web part (the same parameter coming from the filter web part as to be sent to a common parameter define in each report coming from my document library)
But I'm not able to connect the filter web part after I connect the report list web part.
another issue I have: there is a lack of options to choose interactivity I want with the report (like exporting only, but not be able to print...) and also the system always use fixed size webpart, and I want a dynamic layout (the report as to take all the space possible, and I don't want the scroll bars)
so... conclusion... I'm looking for another report viewer webpart... or I have to create my own.
unfortunatly, when I try to create a webpart where I add the reportviewer control, I got an unexpected error.
And I have no idea why.
My current status in this development is simple: I have a simple web part where I just add the reportviewer control and I connect it to 1 report (later I'll add the interactivity required)
But this simple webpart crash.
Anybody as some sample code to create a new reportviewer webpart?Read more...