SQL Report Writing Services with SQL 2000? 1

[JohnOB]

I understand MS SQL Report Writing Services comes free as part of SQL Server 2005, however I was at a conference recently and someone said it also came as part of 2000, does anyone know if that is the case?

"Stupid isn't not knowing the answer, it's not asking the question

 

[xlbo]

Yes it does but is effectively a beta test version. We are still using the version shipped with 2000 here at the mo...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JohnOB]

Thanks Geoff. With this Beta version are you able to write reports, export them (pdf etc) but also publish them as a URL so that users can get live figures whenever they run them? And for the users to run the reports this way do they need anything additional?

Thanks

John

"Stupid isn't not knowing the answer, it's not asking the question

 

[xlbo]

Yes - you can write, deploy and view reports - pretty much all functionality works but it is wise to download the service packs as they fix a couple of print issues etc. Can certainly publish as a report and run via a url - we do a lot of that here...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JohnOB]

Thanks again!

"Stupid isn't not knowing the answer, it's not asking the question

 

[JohnOB]

Me Again,

I have been reading up on this and saw this statement

'Report Designer is a Visual Studio .NET 2003 add-in. It extends Visual Studio .NET 2003 to permit
developers to define Reporting Services DataSets, specify
a query and layout, and preview and deploy the report
definitions, which are saved to report definition (RDL) files
in the project and then when deployed, are saved to the
Report Server database as intermediate language (IL).'

Does this mean that in order to write reports, I would need to obtain (and learn to use) Visual Studio.NET, or does the SQL Report Writing services come with it's own report author?

Thanks

John

"Stupid isn't not knowing the answer, it's not asking the question

 

[xlbo]

AFAIK, you have to create a reporting services report within the .NET environment. The actual building of an RS report is very similar to designing an MS Access or MS Excel form in VBA. You have a report body which you drag and drop controls onto. You then assign properties to the controls and bind them to data before deploying the report so that people can use it

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[JohnOB]

So, as far as you know, if I wanted to write reports using MS SQL Report Writing Services I would also need to purchase Visual Studio or another .Net application?

Thanks

"Stupid isn't not knowing the answer, it's not asking the question

 

[xlbo]

Yes - that is correct. It is the only way I know of to deploy an SSRS report to the report server

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question