Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Wednesday, March 21, 2012

Reporting Services - Tools

Hi there,
I am new to MS Reporting Services and would like to know if there is a way to add more controls to the tool box in vs .net to put variety of controls on the rdl reports. for instance by default the toolbox doesn't have a dropdownlist control. If there is a way of doing so, would someone please tell me how?

Thank you.
Because Reporting Services is output independent and we don't have an eventing model, you can't use regular VB or ASP controls on the page. We are looking at ways of making this possible in the future.

In SQL 2005, we have what is called 'Custom Report Items', which are Reporting Services specific controls. We expect that there will be serveral third parties offering these, including an enhanced chart from Dundas Software. See http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx for some information about Custom Report Items.

Monday, March 12, 2012

Reporting Services

I installed SQL 2005 Tools and everything appears to work except setting up the Reporting Services server. I started with my local instance of SQL Server 2000, SP2. I found a comment that said I needed SP4. I installed with no errors but when I check the version number still says SP2 even after a reboot. I still couldn't use it as RS instance.

I can write reports but without the RS server I can't publish them.

I then installed SQL 2005 Express which works fine and attached the Adventurework databases. But I still cannot designate an RS server.

No report servers were found on the specified machine. Details: Invalid namespace.

I believe there should be a RS service running but there is not. I tried reinstalling from both the original Tools directory and the Add/Remove Programs. In both cases, it says everything is alread installed.

I installed SQL Express 2005 w/ all the extras and now I have a local instance of Reports Services.