Difference between Matrix and Table

Hello.
I'm fairly new to Reporting Services, so my question might seem really
simple to you guys. But what is the difference between a matrix and a table?
When should I use what? Are there any articles on the web that explain this?
The best I've found is in this article:
http://www.ftponline.com/vsm/2004_09/magazine/columns/databasedesign/default_pf.aspx
[Quote]
The report type defines the structure, or data region, of the data returned
by your query. The Report Wizard lets you present this information as either
a table or a matrix, though you have more options outside the wizard. The
main difference between these two types of data regions is the number of
columns. A table has a fixed number of columns; a matrix has a variable
number determined by the query results.
[/quote]
- But I'd like to see a more practical explanation.
Any input appreciated!
Kaisa M. LindahlI use matrix when I have both row and column groupings. What I mean is if I
have row groupings as Dept, Group, User (drill down) and in the column I have
year, quarter, month drilldowns, u have to use a matrix. If you just have row
groupings I would suggest use the table, because a matrix is quite buggy when
it comes to exporting to excel.
Hope this helps
"Kaisa M. Lindahl" wrote:
> Hello.
> I'm fairly new to Reporting Services, so my question might seem really
> simple to you guys. But what is the difference between a matrix and a table?
> When should I use what? Are there any articles on the web that explain this?
> The best I've found is in this article:
> http://www.ftponline.com/vsm/2004_09/magazine/columns/databasedesign/default_pf.aspx
> [Quote]
> The report type defines the structure, or data region, of the data returned
> by your query. The Report Wizard lets you present this information as either
> a table or a matrix, though you have more options outside the wizard. The
> main difference between these two types of data regions is the number of
> columns. A table has a fixed number of columns; a matrix has a variable
> number determined by the query results.
> [/quote]
> - But I'd like to see a more practical explanation.
> Any input appreciated!
> Kaisa M. Lindahl
>
>

Did MS change RS licensing in 2005?

Hi,
With SQL Server 2000 and Reporting Services, I'd have to have an additional
SQL Server license if I wanted to run Reporting Services on a server other
the database server. I don't want to run Reporting Services on the same
machine as SQL Server as I'm not so crazy about running IIS and SQL Server on
the same machine.
My question is did MS change licensing for Reporting Services in the new
version that will be released w/ SQL Server 2005? Or will I still need an
additional license for Reporting Services if I wanted to run it on a
different machine?
--
Thanks,
SamAs far as I know this has not changed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:AC7D944B-258E-4394-AF42-493E1E1E190E@.microsoft.com...
> Hi,
> With SQL Server 2000 and Reporting Services, I'd have to have an
> additional
> SQL Server license if I wanted to run Reporting Services on a server other
> the database server. I don't want to run Reporting Services on the same
> machine as SQL Server as I'm not so crazy about running IIS and SQL Server
> on
> the same machine.
> My question is did MS change licensing for Reporting Services in the new
> version that will be released w/ SQL Server 2005? Or will I still need an
> additional license for Reporting Services if I wanted to run it on a
> different machine?
> --
> Thanks,
> Sam

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.

developing reports for Exchange 2003

Has anyone had experience with developing reports based off items in
Exchange 2003? Is it possible to use reporting services to connect to
Exchange to report on types of emails or does another type of connection
have to made? Any insight would be much appreciated. Thanks.
--
****************************************
Andy S.
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
****************************************You might want to download the new "SQL Server 2000 Report Pack for
Microsoft Exchange":
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
It is a set of 13 Microsoft Exchange-based reports with a sample database
that lets you easily visualize and author managed reports for e-mail
administration.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Has anyone had experience with developing reports based off items in
> Exchange 2003? Is it possible to use reporting services to connect to
> Exchange to report on types of emails or does another type of connection
> have to made? Any insight would be much appreciated. Thanks.
> --
> ****************************************
> Andy S.
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> ****************************************
>
>|||Thanks, I saw that. However, if you notice, this SQL Server Report Pack is
for a 3rd party app developed by Super Software for their tool that exports
Exchange code.
What I really need to figure out is how to create a reporting service
connection to Exchange instead of having to figure out how to create a .NET
application that uses a CDO type connection. I keep seeing something about
an Exchange OLE DB Provider but no instructions on how to add it to the
available providers in reporting services or how to access the store in
Exchange with it.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> You might want to download the new "SQL Server 2000 Report Pack for
> Microsoft Exchange":
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> It is a set of 13 Microsoft Exchange-based reports with a sample database
> that lets you easily visualize and author managed reports for e-mail
> administration.
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > Has anyone had experience with developing reports based off items in
> > Exchange 2003? Is it possible to use reporting services to connect to
> > Exchange to report on types of emails or does another type of connection
> > have to made? Any insight would be much appreciated. Thanks.
> >
> > --
> > ****************************************
> > Andy S.
> > andymcdba1@.NOMORESPAM.yahoo.com
> >
> > Please remove NOMORESPAM before replying.
> >
> > ****************************************
> >
> >
> >
> >
>|||The Exchange OLEDB provider only works on the Exchange Server itself so you
would have to run Reporting Services on your Exchange Server. Your other
option is to find a WebDAV OLEDB provider (I believe there are some freeware
ones) and you could use that as well from Reporting Services.
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:e%23d2CUmpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Thanks, I saw that. However, if you notice, this SQL Server Report Pack
> is
> for a 3rd party app developed by Super Software for their tool that
> exports
> Exchange code.
> What I really need to figure out is how to create a reporting service
> connection to Exchange instead of having to figure out how to create a
> .NET
> application that uses a CDO type connection. I keep seeing something
> about
> an Exchange OLE DB Provider but no instructions on how to add it to the
> available providers in reporting services or how to access the store in
> Exchange with it.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uPxFW2jpEHA.1992@.TK2MSFTNGP09.phx.gbl...
>> You might want to download the new "SQL Server 2000 Report Pack for
>> Microsoft Exchange":
> http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
>> It is a set of 13 Microsoft Exchange-based reports with a sample database
>> that lets you easily visualize and author managed reports for e-mail
>> administration.
>> --
>> Robert M. Bruckner
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Andy S." <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
>> news:eMSHKeipEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > Has anyone had experience with developing reports based off items in
>> > Exchange 2003? Is it possible to use reporting services to connect to
>> > Exchange to report on types of emails or does another type of
>> > connection
>> > have to made? Any insight would be much appreciated. Thanks.
>> >
>> > --
>> > ****************************************
>> > Andy S.
>> > andymcdba1@.NOMORESPAM.yahoo.com
>> >
>> > Please remove NOMORESPAM before replying.
>> >
>> > ****************************************
>> >
>> >
>> >
>> >
>>
>

Developing a report with Reporting Services in SQL Express

Hi,

I'm trying to use reporting services in teh VS2003 but the Option to I create the project does not appear, i've already installed SP3 and no success, any idea ?

Thanks

Which reporting service? I don't believe SQL 2000 Reporting Services is supported on MSDE. You should probably be asking this question in a Visual Studio forum rather than a SQL forum.

Mike

|||

Ok, then

Thanks... And do you Know if SQL 2005 Express has this service ?

Thanks

|||

Yes, SQL Express with Advanced Services includes Reporting Services. The tool to create reports, BIDS, is available in the SQL Express Toolkit. Both can be downloaded from http://msdn.microsoft.com/vstudio/express/sql/download.

Regards,

Mike Wachal
SQL Express team

|||

Nice....

Another thing, I have an application that is currently using MSDE, I use some stored procedures and functions.... Is it all compatible with SQL Express 2005 do I need to change anything in my application ?

Thanks

|||

Hi, question regarding developing a report using SQL Express with advanced/reporting services. I have all packages installed correctly (I think) but am unable to start the BI report developer tool because the Start menu shortcut for the business intelligence development studio points to an executable that is not there. It points to: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

FYI, I am running Windows XP SP2 and do not have Visual Studio installed, although I do have Visual C# Express installed. There is a VCSExpress.exe in that directory, if that helps.

I can access the web based links for the reporting services manager at http://localhost/Reports$SQLExpress with no problems.

Any idea on how to use the report developer tool?

Thanks,

Todd

Developers on Other Machines (formerly: Problem installing SQL Server Reporting Services )

Bruce:
Sorry for the misposting.
I don't understand what you mean by "you haven't setup your roles for
the developers on other machines." Once a user role (developer or
otherwise) is set up on the server, shouldn't it be in effect no
matter where a user logs in from?
Jody
"Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> Your problem seems different. He was having a problem installing. Your
> problem seems to be accessing it. It looks to me like you haven't setup your
> roles for the developers on other machines.
Bruce L-C
>"JodyT" <datagal@.msn.com> wrote in message
>news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
>> I'm having a similar problem...
>>
>> Enterprise and Developer set up on one server machine, Developer on
2
>> other desktops. If you access Report Manager from the Server
machine,
>> everything looks fine. But Report Manager accessed from the
>> non-server machines shows the top banner only... No tabs, no
folders,
>> nothing below the line, so a developer can't upload without
switching
>> over to the server, and even then there are often errors.
>>
>> Is there some configuration subtlety we missed?
>>
>> Otherwise this thing is giving me problems with OutOfMemory errors
on
>> local debugs that I know aren't too big.
>>
>> Ideas?
>> Jody
>>I suspect one of two things are happening. You have anonymous access on
which ends up treating everyone as the same regardless of how they are
logged in and they end up not having the permissions you wish them to have.
Or, the developers are either not assigned to a role, or are assigned to a
role that does not have the correct rights, or are assigned to a role with
the correct rights but that role has not been applied to the appropriate
part of the website. Unless you override it, any folder/report inherits the
role assignments from further up the tree. So if you assign the role from
above
My guess is when they are on the server they are not logged in as themselves
but are logged in as the admin for the local machine.
If they log into the server as themselves and the website does not look the
same as when they try to access it from their computers then my reasoning
falls apart.
So, check the the following.
1. Do you have anonymous access turned on?
2. What happens if you log into the server as one of the developers that are
having difficulties.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> Bruce:
> Sorry for the misposting.
> I don't understand what you mean by "you haven't setup your roles for
> the developers on other machines." Once a user role (developer or
> otherwise) is set up on the server, shouldn't it be in effect no
> matter where a user logs in from?
> Jody
> "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > Your problem seems different. He was having a problem installing. Your
> > problem seems to be accessing it. It looks to me like you haven't setup
your
> > roles for the developers on other machines.
> Bruce L-C
> >"JodyT" <datagal@.msn.com> wrote in message
> >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> >> I'm having a similar problem...
> >>
> >> Enterprise and Developer set up on one server machine, Developer on
> 2
> >> other desktops. If you access Report Manager from the Server
> machine,
> >> everything looks fine. But Report Manager accessed from the
> >> non-server machines shows the top banner only... No tabs, no
> folders,
> >> nothing below the line, so a developer can't upload without
> switching
> >> over to the server, and even then there are often errors.
> >>
> >> Is there some configuration subtlety we missed?
> >>
> >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> >> local debugs that I know aren't too big.
> >>
> >> Ideas?
> >> Jody
> >>|||Actually I am the developer, with very minimal network learnin'. I
finally got the guy who installed to look at the research I've been
doing and he ended up reinstalling "paying closer attention to the
configuration options". He did have to do some monkeying around with
the anonymous thing, but he seems to have it working now. We'll see
how it goes if we ever put some actual users on it.
Thanks all for the input. It was a big help.
Jody
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<ur$lBPJgEHA.556@.tk2msftngp13.phx.gbl>...
> I suspect one of two things are happening. You have anonymous access on
> which ends up treating everyone as the same regardless of how they are
> logged in and they end up not having the permissions you wish them to have.
> Or, the developers are either not assigned to a role, or are assigned to a
> role that does not have the correct rights, or are assigned to a role with
> the correct rights but that role has not been applied to the appropriate
> part of the website. Unless you override it, any folder/report inherits the
> role assignments from further up the tree. So if you assign the role from
> above
> My guess is when they are on the server they are not logged in as themselves
> but are logged in as the admin for the local machine.
> If they log into the server as themselves and the website does not look the
> same as when they try to access it from their computers then my reasoning
> falls apart.
> So, check the the following.
> 1. Do you have anonymous access turned on?
> 2. What happens if you log into the server as one of the developers that are
> having difficulties.
> Bruce L-C
> "JodyT" <datagal@.msn.com> wrote in message
> news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> > Bruce:
> >
> > Sorry for the misposting.
> >
> > I don't understand what you mean by "you haven't setup your roles for
> > the developers on other machines." Once a user role (developer or
> > otherwise) is set up on the server, shouldn't it be in effect no
> > matter where a user logs in from?
> >
> > Jody
> >
> > "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > > Your problem seems different. He was having a problem installing. Your
> > > problem seems to be accessing it. It looks to me like you haven't setup
> your
> > > roles for the developers on other machines.
> >
> > Bruce L-C
> >
> > >"JodyT" <datagal@.msn.com> wrote in message
> > >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> > >> I'm having a similar problem...
> > >>
> > >> Enterprise and Developer set up on one server machine, Developer on
> 2
> > >> other desktops. If you access Report Manager from the Server
> machine,
> > >> everything looks fine. But Report Manager accessed from the
> > >> non-server machines shows the top banner only... No tabs, no
> folders,
> > >> nothing below the line, so a developer can't upload without
> switching
> > >> over to the server, and even then there are often errors.
> > >>
> > >> Is there some configuration subtlety we missed?
> > >>
> > >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> > >> local debugs that I know aren't too big.
> > >>
> > >> Ideas?
> > >> Jody
> > >>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/report...buy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/report...fulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:

> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?
Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/reporti...uy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/reporti...ulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:

> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>

Developers edition

Have developers edition of SQL Server - is there anywhere I can download
developers edition of reporting services ?Hi
Not downloadable unless you are a MSDN subscriber.
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
For media to be shipped to you:
http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.asp
Regards
Mike
"Michael Vardinghus" wrote:
> Have developers edition of SQL Server - is there anywhere I can download
> developers edition of reporting services ?
>
>

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/report...y/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:%23AjCbjKzF
HA.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/report...y/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> gl
sD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>

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...
>

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/reporting/howtobuy/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> ¼¶¼g©ó¶l¥ó·s»D:%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/reporting/howtobuy/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?
>>
>|||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>
> ¼¶¼g©ó¶l¥ó·s»D:%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/reporting/howtobuy/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?
>>
>>
>|||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> ¼¶¼g©ó¶l¥ó·s»D:%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/reporting/howtobuy/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?
>>
>>
>