Install Report Designer (RS 2000) on VS2005 Express?

Does anyone know if it's possible to install the Report Designer component of Reporting Services 2000 on one the Visusal Studio Express versions? My client is running SQL Server 2000 in production, and wants to evaluate Reporting Services for an upcoming project. However, they aren't currently running any version of Visual Studio 2003. I know we can buy VB.Net 2003 and then install the report designer on that machine, but they'd like to get buy as cheaply as possible (like, free); hence the interest in using VS Express.
They don't want to commit to SQL Server 2005 or I'd suggest they install the CTP on a development machine and play with Reporting Services 2005.
Thanks,
Ericany solutions to this problem?sql

Install of SQL express edition with vs2005 pro

I was able to install and use the vs 2005 for the first time today, and it was so far, so good!

However, I would like to know more about how it setup my SQL 2005 Express edition when I installed the full package of vs2005. What I would like to specifically know -- if the instance is using my Windows Authentication, or what the "sa" password might be.

When installing vs2005, it automatically installed SQL Express 2005, without prompting me for setup options on the sql part. Soooo, does is use windows authentication automatically, or some type of default "sa" password.

Very curious to know...

I'm pretty sure that by default it gets installed using Windows Authentication mode, so SA is disabled.

Paul

sql

Install of SQL express edition with vs2005 pro

I was able to install and use the vs 2005 for the first time today, and it was so far, so good!

However, I would like to know more about how it setup my SQL 2005 Express edition when I installed the full package of vs2005. What I would like to specifically know -- if the instance is using my Windows Authentication, or what the "sa" password might be.

When installing vs2005, it automatically installed SQL Express 2005, without prompting me for setup options on the sql part. Soooo, does is use windows authentication automatically, or some type of default "sa" password.

Very curious to know...

I'm pretty sure that by default it gets installed using Windows Authentication mode, so SA is disabled.

Paul

Install Developer Edition & Express?

Hi: I have installed SQL 2005 Developer Edition and VS 2005. Do I need to also install SQL 2005 Express edition too?

My version of VS2005 is proffesional. I cannot seem to find SQL 2005 Developer Edition in the Server Explorer of VS2005. So I am wondering if I need to install SQL 2005 Express. Before I had SQL 2000 and MSDE installed with VS2003 and there was no problem.

Thanks

no need to install express.|||

So I do not need to install express edition. Okay. So why can I not see it using Visual Studio 2005 Server Explorer?

Thanks for your speedy reply.

|||

do you dee 'data connections' ?

right click and select 'add connection' follow the wizard

|||

Yes that works. But why can I not see it under the Servers node? In VS2003 I have no problem and it appears under the Servers node.

It may be a problem with my install of VS2005 because the Help is not working properly also.

Thanks

|||I think it is a change in vs 2005. Things have changed alot with regard to data in 2005.|||

Thanks Blair. I will ask MS support when I am talking to them about my help files. I will post the anwser when I find it.

Thanks again for your responses.

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.