Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Friday, March 30, 2012

multi-value dropdownlist as a .net control?

Does anyone know if I can utilize the same multi-value dropdownlist control that is available in Report Manager and the ReportViewer parameters section, in my own ASPX pages? This is the control that has checkboxes in a dropdown list.

If not, can anyone point me to a third party?

Thanks,

Brian

Brian,
know exactly what you are talking about as I was searching for an item like this myself. I have not found any similar control yet but managed to seperate the client side code that is driving the control in the ReportViewer. Did not have time to write a custom control that renders out this client side code but this is definitely doable. Let me know if you want to have the commented client side code that drives the dropdown (it does not work in Firefox though but should be good enough as an example).

Cheers,
Niels

multi-value dropdownlist as a .net control?

Does anyone know if I can utilize the same multi-value dropdownlist control that is available in Report Manager and the ReportViewer parameters section, in my own ASPX pages? This is the control that has checkboxes in a dropdown list.

If not, can anyone point me to a third party?

Thanks,

Brian

Brian,
know exactly what you are talking about as I was searching for an item like this myself. I have not found any similar control yet but managed to seperate the client side code that is driving the control in the ReportViewer. Did not have time to write a custom control that renders out this client side code but this is definitely doable. Let me know if you want to have the commented client side code that drives the dropdown (it does not work in Firefox though but should be good enough as an example).

Cheers,
Niels

Monday, March 26, 2012

Multi-Server setup: RS, Sharepoint, new SP2 Webparts

I was reading the SP2 readme and I see this in section 4.1.1:
"To use the Reporting Services SharePoint Web parts, Report Server and
Report Manager must both be installed."
My company's RS server is on it's own box (A). The RS Configuration db
is on it's own box (B). Our intranet (Sharepoint) site is on it's own
box (C). 3 servers total. I want to try out the 2 new web parts. Can I
just copy the the RSWebParts.cab from server A to our Sharepoint server
C and install it or do I actually have to install a full blown
installation of RS plus RS SP2 on that Sharepoint server C? If so, why?
Because I was planning to point the web parts to the reports that exist
on the separate RS server A, or is that not permitted?
Am I going to have to redeploy my reports to C, manage a second
configuration database / report server? I hope not.
Thank you!No, you do not need to install RS on Box C. The parts can be pointed to any
existing RS. The point of the documentation was to let people know they
needed a working RS for the parts to work, not that they needed to all exist
on the same box.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <macleary2000@.yahoo.com> wrote in message
news:1134065827.784617.228020@.g44g2000cwa.googlegroups.com...
>I was reading the SP2 readme and I see this in section 4.1.1:
> "To use the Reporting Services SharePoint Web parts, Report Server and
> Report Manager must both be installed."
> My company's RS server is on it's own box (A). The RS Configuration db
> is on it's own box (B). Our intranet (Sharepoint) site is on it's own
> box (C). 3 servers total. I want to try out the 2 new web parts. Can I
> just copy the the RSWebParts.cab from server A to our Sharepoint server
> C and install it or do I actually have to install a full blown
> installation of RS plus RS SP2 on that Sharepoint server C? If so, why?
> Because I was planning to point the web parts to the reports that exist
> on the separate RS server A, or is that not permitted?
> Am I going to have to redeploy my reports to C, manage a second
> configuration database / report server? I hope not.
> Thank you!
>

Friday, March 23, 2012

Multiple-step OLE DB operation generated errors

I'm trying to view a report on Report Manager (Reporting Services 2000) that displays Analysis Services (2000) data. I keep getting the following error message:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'CubeName'. (rsErrorOpeningConnection) Get Online Help

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I am using Visual Studio 2003 to build the report and I can successfully view the cube and pull data but when I deploy the report and data source to Report Manager I keep getting this error message. I am not using my credentials for the data source I am using a SQL account that is a sys admin and has access to the cube I am trying to view.

Additional Information: Visual Studio - local machine
SQL Server/Analysis Services - Machine A
Reporting Services - Machine B

See this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=706585&SiteID=1 is any help.

Multiple-step OLE DB operation generated errors

I'm trying to view a report on Report Manager (Reporting Services 2000) that displays Analysis Services (2000) data. I keep getting the following error message:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'CubeName'. (rsErrorOpeningConnection) Get Online Help Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I am using Visual Studio 2003 to build the report and I can successfully view the cube and pull data but when I deploy the report and data source to Report Manager I keep getting this error message. I am not using my credentials for the data source I am using a SQL account that is a sys admin and has access to the cube I am trying to view.

Additional Information: Visual Studio - local machine
SQL Server/Analysis Services - Machine A
Reporting Services - Machine B

See this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=706585&SiteID=1 is any help.