Develop in VS2005 and deployment to SQL 2000

I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?
If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporti.../default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>
|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporti.../default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si >
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:

>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>