SSRS Report Builder 2.0 - Use with SQL 2005

sql-server sql-server-2005 reporting-services ssrs-2008 reportbuilder
Sam Schutte picture Sam Schutte · Jan 15, 2009 · Viewed 7.5k times · Source

I'm starting to look into SSRS Report Builder 2.0, and I see in the documentation that it supports connections to SQL 2005.

Does anyone know if the reports made against SQL 2005 can then be upload to the SSRS 2005 website and ran from the site? Or, can they only be run from the SSRS 2008 website if they were generated in Report Builder 2.0?

Answer

Dustin Brooks picture Dustin Brooks · Jan 16, 2009

You can not run a 2008 report on the 2005 engine, you can however run a 2005 report on the 2008 engine, it converts the report on-demand.

Here is a link to a similar q/a:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=350119&wa=wsignin1.0

Related questions

Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query. select Date,TotalAllowance from Calculation where EmployeeId=1 and Date …

Read More