We have SQL 2000 as our database platform. I can't see any large scale
migration any time soon. However we would like to start using Reporting
Services. What are the options of using 2005 Reporting services and point
them at a 2000 server through e.g. linked servers etc. Is something like
this possible or am I going in the wrong direction."Chris" <nospam@.nospam.com> wrote in message
news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
> We have SQL 2000 as our database platform. I can't see any large scale
> migration any time soon. However we would like to start using Reporting
> Services. What are the options of using 2005 Reporting services and point
> them at a 2000 server through e.g. linked servers etc. Is something like
> this possible or am I going in the wrong direction.
>
You don't even need linked servers. Just install Reporting Services 2005,
and you can build reports that pull data from SQL 2000 databases.
David|||Additional Info:
Besides the database where data for the reports is stored, RS itself also
needs SQL Server to host its meta database, which may or may not be in the
same computer where RS runs. For RS2005, yes, you can use SQL Server2000 to
host RS2005 meta database. However, where the RS meta-database is in the
same computer as the RS or not, you need SQL Server2005 license to use
RS2005 (That is, if the SQL Server is in different computer as RS, you need
two licenses: one for RS (SQL Server2005, in your case); and one for the SQL
Server2000 (SQL Server2005 or 2000 license).
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ucaOUjSTHHA.1200@.TK2MSFTNGP04.phx.gbl...
>
> "Chris" <nospam@.nospam.com> wrote in message
> news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
> You don't even need linked servers. Just install Reporting Services 2005,
> and you can build reports that pull data from SQL 2000 databases.
> David
Showing posts with label platform. Show all posts
Showing posts with label platform. Show all posts
Tuesday, March 20, 2012
Reporting Services
We have SQL 2000 as our database platform. I can't see any large scale
migration any time soon. However we would like to start using Reporting
Services. What are the options of using 2005 Reporting services and point
them at a 2000 server through e.g. linked servers etc. Is something like
this possible or am I going in the wrong direction."Chris" <nospam@.nospam.com> wrote in message
news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
> We have SQL 2000 as our database platform. I can't see any large scale
> migration any time soon. However we would like to start using Reporting
> Services. What are the options of using 2005 Reporting services and point
> them at a 2000 server through e.g. linked servers etc. Is something like
> this possible or am I going in the wrong direction.
>
You don't even need linked servers. Just install Reporting Services 2005,
and you can build reports that pull data from SQL 2000 databases.
David|||Additional Info:
Besides the database where data for the reports is stored, RS itself also
needs SQL Server to host its meta database, which may or may not be in the
same computer where RS runs. For RS2005, yes, you can use SQL Server2000 to
host RS2005 meta database. However, where the RS meta-database is in the
same computer as the RS or not, you need SQL Server2005 license to use
RS2005 (That is, if the SQL Server is in different computer as RS, you need
two licenses: one for RS (SQL Server2005, in your case); and one for the SQL
Server2000 (SQL Server2005 or 2000 license).
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ucaOUjSTHHA.1200@.TK2MSFTNGP04.phx.gbl...
>
> "Chris" <nospam@.nospam.com> wrote in message
> news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
>> We have SQL 2000 as our database platform. I can't see any large scale
>> migration any time soon. However we would like to start using Reporting
>> Services. What are the options of using 2005 Reporting services and point
>> them at a 2000 server through e.g. linked servers etc. Is something like
>> this possible or am I going in the wrong direction.
> You don't even need linked servers. Just install Reporting Services 2005,
> and you can build reports that pull data from SQL 2000 databases.
> David
migration any time soon. However we would like to start using Reporting
Services. What are the options of using 2005 Reporting services and point
them at a 2000 server through e.g. linked servers etc. Is something like
this possible or am I going in the wrong direction."Chris" <nospam@.nospam.com> wrote in message
news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
> We have SQL 2000 as our database platform. I can't see any large scale
> migration any time soon. However we would like to start using Reporting
> Services. What are the options of using 2005 Reporting services and point
> them at a 2000 server through e.g. linked servers etc. Is something like
> this possible or am I going in the wrong direction.
>
You don't even need linked servers. Just install Reporting Services 2005,
and you can build reports that pull data from SQL 2000 databases.
David|||Additional Info:
Besides the database where data for the reports is stored, RS itself also
needs SQL Server to host its meta database, which may or may not be in the
same computer where RS runs. For RS2005, yes, you can use SQL Server2000 to
host RS2005 meta database. However, where the RS meta-database is in the
same computer as the RS or not, you need SQL Server2005 license to use
RS2005 (That is, if the SQL Server is in different computer as RS, you need
two licenses: one for RS (SQL Server2005, in your case); and one for the SQL
Server2000 (SQL Server2005 or 2000 license).
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ucaOUjSTHHA.1200@.TK2MSFTNGP04.phx.gbl...
>
> "Chris" <nospam@.nospam.com> wrote in message
> news:esUzl4RTHHA.1000@.TK2MSFTNGP05.phx.gbl...
>> We have SQL 2000 as our database platform. I can't see any large scale
>> migration any time soon. However we would like to start using Reporting
>> Services. What are the options of using 2005 Reporting services and point
>> them at a 2000 server through e.g. linked servers etc. Is something like
>> this possible or am I going in the wrong direction.
> You don't even need linked servers. Just install Reporting Services 2005,
> and you can build reports that pull data from SQL 2000 databases.
> David
Tuesday, February 21, 2012
Reporting for our HR application
We are about to create a new reporting platform for our HR application. We
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ERP like
transactional reports eg a list of Employee Loans and aggregated reports
showing salary information.
I also need to provide a model for end users, so they easily can create
their own reports.
We are using Reporting Services as our reporting solution.
1) Create OLAP cubes with all my tables as fact tables and dimensions
surrounding them.
2) Create a reporting services "Report Model".
3) Create all reports on the existing data model.
4) Create a Data Warehouse and create all reports on the new data model.
Thanks
Henrik.Hello Henrik,
SQL Reporting Services 2005 will suitable for your solution.
You could design a report to access your SQL database and generate the
transactional report.
Also, you could design a report to access the SQL Analysis Server.
From your description, my understanding is that you want to use the Report
Model to make end user could design the report.
Yes, you could build a report model based on a Analysis Cube. For more
detailed information about how to build a model, please refer the BOL
article:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/70f75784-6895-498e-8d15-
8732ef95621a.htm
Also, here are some BOL article for your reference:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d6ad529-7c80-4aed-a208-
339f12b27659.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/395a4f26-6401-4ee1-8658-b
e8b43cc70a8.htm
We would also like to introduce you to the CUSTOMER SERVICE AND SUPPORT
(CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ERP like
transactional reports eg a list of Employee Loans and aggregated reports
showing salary information.
I also need to provide a model for end users, so they easily can create
their own reports.
We are using Reporting Services as our reporting solution.
1) Create OLAP cubes with all my tables as fact tables and dimensions
surrounding them.
2) Create a reporting services "Report Model".
3) Create all reports on the existing data model.
4) Create a Data Warehouse and create all reports on the new data model.
Thanks
Henrik.Hello Henrik,
SQL Reporting Services 2005 will suitable for your solution.
You could design a report to access your SQL database and generate the
transactional report.
Also, you could design a report to access the SQL Analysis Server.
From your description, my understanding is that you want to use the Report
Model to make end user could design the report.
Yes, you could build a report model based on a Analysis Cube. For more
detailed information about how to build a model, please refer the BOL
article:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/70f75784-6895-498e-8d15-
8732ef95621a.htm
Also, here are some BOL article for your reference:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d6ad529-7c80-4aed-a208-
339f12b27659.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/395a4f26-6401-4ee1-8658-b
e8b43cc70a8.htm
We would also like to introduce you to the CUSTOMER SERVICE AND SUPPORT
(CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Reporting for our HR application
We are about to create a new reporting platform for our HR application. We
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ERP like
transactional reports eg a list of Employee Loans and aggregated reports
showing salary information.
I also need to provide a model for end users, so they easily can create
their own reports.
We are using Reporting Services as our reporting solution.
1) Create OLAP cubes with all my tables as fact tables and dimensions
surrounding them.
2) Create a reporting services "Report Model".
3) Create all reports on the existing data model.
4) Create a Data Warehouse and create all reports on the new data model.
Thanks
Henrik.Hello Henrik,
Thank you for posting here!
I notice that you have posted the same question in our reporting services
newsgroup, to which I have already responded. Please check my answer there,
and if you need any further assistance on this particular issue please
reply to me in that thread so I can follow up with you. In the future,
please don't cross-post the same question in multiple newsgroups. This
will help our engineers work on your question more efficiently. Your
understanding and cooperation is appreciated.
For your convenience, I have included my reply as follows:
Hello Henrik,
SQL Reporting Services 2005 will suitable for your solution.
You could design a report to access your SQL database and generate the
transactional report.
Also, you could design a report to access the SQL Analysis Server.
From your description, my understanding is that you want to use the Report
Model to make end user could design the report.
Yes, you could build a report model based on a Analysis Cube. For more
detailed information about how to build a model, please refer the BOL
article:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/70f75784-6895-498e-8d15-
8732ef95621a.htm
Also, here are some BOL article for your reference:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d6ad529-7c80-4aed-a208-
339f12b27659.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/395a4f26-6401-4ee1-8658-b
e8b43cc70a8.htm
We would also like to introduce you to the CUSTOMER SERVICE AND SUPPORT
(CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
Thank you and have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ERP like
transactional reports eg a list of Employee Loans and aggregated reports
showing salary information.
I also need to provide a model for end users, so they easily can create
their own reports.
We are using Reporting Services as our reporting solution.
1) Create OLAP cubes with all my tables as fact tables and dimensions
surrounding them.
2) Create a reporting services "Report Model".
3) Create all reports on the existing data model.
4) Create a Data Warehouse and create all reports on the new data model.
Thanks
Henrik.Hello Henrik,
Thank you for posting here!
I notice that you have posted the same question in our reporting services
newsgroup, to which I have already responded. Please check my answer there,
and if you need any further assistance on this particular issue please
reply to me in that thread so I can follow up with you. In the future,
please don't cross-post the same question in multiple newsgroups. This
will help our engineers work on your question more efficiently. Your
understanding and cooperation is appreciated.
For your convenience, I have included my reply as follows:
Hello Henrik,
SQL Reporting Services 2005 will suitable for your solution.
You could design a report to access your SQL database and generate the
transactional report.
Also, you could design a report to access the SQL Analysis Server.
From your description, my understanding is that you want to use the Report
Model to make end user could design the report.
Yes, you could build a report model based on a Analysis Cube. For more
detailed information about how to build a model, please refer the BOL
article:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/70f75784-6895-498e-8d15-
8732ef95621a.htm
Also, here are some BOL article for your reference:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d6ad529-7c80-4aed-a208-
339f12b27659.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/395a4f26-6401-4ee1-8658-b
e8b43cc70a8.htm
We would also like to introduce you to the CUSTOMER SERVICE AND SUPPORT
(CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
Thank you and have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Subscribe to:
Posts (Atom)