install reporting service 2005

Hi
I tried to install reporting service after i had installed sql server 2005, I find reporting service checkbox is disabled, so i can not install it.
Why it is disabled, and how i install reporting service.
thanks

Do you have IIS installed on the machine? If not installed, RS will not install either.

Also, because you have a SQL instance already installed, you have two options.

1. Install RS as another instance and you will get a full install and the check box should be enabled.

2. Install RS as a files only installation for the existing SQL Instance. Then use the configuration tool to configure RS to work with the current instance of SQL Server.

|||Hi Brad
That solved the problem. I installed IIS , and succeded in instaling RS within a named sqlsever 2005 service.
I tried to create a simple report using RS wizard in VS 2005 to test the reporting service , and when finishing the wizard the error message:
"Exception of type 'System.Runtime.InteropServices.COMException' " was thrown , and i can not generate the report.
Pls, how can i resolve the problem.
Thanks.

|||I resolved the exception error thanks to the post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573569&SiteID=1&mode=1

after reading the post , I downloaded the refactor software . I tried to install it

, but it could not be installed due to error:

"Error 1001: The SavedState Dictionary contains inconsistent data and

might have corrupted."

I traced the propblem until i found that DXCore (software provided by same

company of refactor) was the reason.

I removed DXcore , and every thing in reporting service in visual studio 2005

become working well !!!..

Is it a bug in DXcore ?

sql

Insertion of Data

I am using vs2005 and sqlserver2000My problem is i have 5 checkboxes and some textboxes.In this user selects the checkbox and textboxes dynamically .In this user selects one or two or three or when user selects header checkbox then all checkboxes are selected.And in my database i mentioned a single column for group of checkboes.So how should i insert the data into databasedim con as new sqlconnection("userid=sa;pwd=; initial catalog=test")dim cmd as sql commandProtected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Clickcmd.CommandText = "insert into check values(" what should i write here ...'" & text.text &"','" @. text2.text "'... ")con.open()cmd.executenonquery()con.close()End Subyour insert will majorly depend on the structure of the database.....how r u storing the it in the database...as bits or strings ......be a little more elaborate about the database structure.|||

It looks like you have one column for check boxes, and then one column each for all of the text fields? This depends on that you want to put in the checkbox column, but if you are inserting text to a field for each of the textbox columns and those correspond to a certian checkbox, you will be able to search your table for which textboxes have text for an entry and decide from that which boxes where checked, so you might even be able to just use the checkbox column as your identity (primary key). i.e., data structure like so:

Columns: checkbox / text1 / text2 / text3 / text4

Data: "some number" / "" / "some text" / "" / "some text"

If you were to query that data row above, you would be able to see that the check boxes in question are the ones without null text field rows. However, if you allow null text values you'd have to re-think this method a bit.

Anyway, the checkbox field can be whatever you want, and that will just depend on whatever logic you come up with. You could do it the long way and make a reference table that holds a unique value for each combination of textboxes, but this will get long and messy. Using 1 column to signify a checkbox group might not be the best way to do things, but that's not up to me since it's your data. Anyway, with that setup an insert query something like this might work for you:

"INSERT INTO check (checkBoxField,TextField1,TextField2,TextField3...)VALUES (" & "checkboxNumber" & "," & text1.text & ", " & text2.text & ", " & text3.text & ")"

..where *check* is the table name, and checkboxNumber is whatever you decide to put in the checkbox field.