|
|
You're in the
sql server reporting services
group:SQL Reporting services (2005) versus Crystal
sql server reporting services:
I was wondering if SQL Reporting services is a viable replacement for Crystal
Reports? We currently use Crystal Reports 11 with our application and distribute the runtime files to our customers. Over have of our customers use MSDE instead of the full licensed copy of SQL. For our next version, we are moving to SQL 2005 and are wondering if SQL Reporting services would work for us. For the customers running SQL Express 2005, what kind of limitations would this create? Your opinions and thoughts are much appreciated. Thanks in advance!
you can use Reporting Services with SQL Express I believe; but I
believe that it's referring to a RDLC instead of the ReportServer interface. I would reccomend just sticking with Crystal; Microsoft SQL Server Reporting Services is too buggy for real world use. -Aaron [quoted text, click to view] Mike wrote:
> I was wondering if SQL Reporting services is a viable replacement for Crystal > Reports? We currently use Crystal Reports 11 with our application and > distribute the runtime files to our customers. Over have of our customers use > MSDE instead of the full licensed copy of SQL. For our next version, we are > moving to SQL 2005 and are wondering if SQL Reporting services would work for > us. For the customers running SQL Express 2005, what kind of limitations > would this create? Your opinions and thoughts are much appreciated. > > Thanks in advance! > > Mike
There are two versions of Express so they would need to get the version with
RS. Also, this version of RS only reports against local data. So if the data is in Express then no problem but they can't use it to report against data on a different server. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Mike" <Mike@discussions.microsoft.com> wrote in message news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... >I was wondering if SQL Reporting services is a viable replacement for >Crystal > Reports? We currently use Crystal Reports 11 with our application and > distribute the runtime files to our customers. Over have of our customers > use > MSDE instead of the full licensed copy of SQL. For our next version, we > are > moving to SQL 2005 and are wondering if SQL Reporting services would work > for > us. For the customers running SQL Express 2005, what kind of limitations > would this create? Your opinions and thoughts are much appreciated. > > Thanks in advance! > > Mike
So if all there data is on that instance of SQL Express, all workstations on
the network can use report on the data? All of our clients have one database and it is on just one instance of SQL. Are you telling me just the machine with the instance can report on the data? [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> There are two versions of Express so they would need to get the version with > RS. Also, this version of RS only reports against local data. So if the data > is in Express then no problem but they can't use it to report against data > on a different server. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Mike" <Mike@discussions.microsoft.com> wrote in message > news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... > >I was wondering if SQL Reporting services is a viable replacement for > >Crystal > > Reports? We currently use Crystal Reports 11 with our application and > > distribute the runtime files to our customers. Over have of our customers > > use > > MSDE instead of the full licensed copy of SQL. For our next version, we > > are > > moving to SQL 2005 and are wondering if SQL Reporting services would work > > for > > us. For the customers running SQL Express 2005, what kind of limitations > > would this create? Your opinions and thoughts are much appreciated. > > > > Thanks in advance! > > > > Mike > >
Have a look at integrating the ReportViewer control within your application.
Get the data and pass the dataset to the ReportViewer control and let it render the report for you. You can check out Brian Weckler demonstrating it at http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml You may also find "MSDN Webcast: Migrating Your Crystal Reports to SQL Server 2005 Reporting Services (Level 100)" of interest (Event ID: 1032298257). Larry [quoted text, click to view] "Mike" wrote:
> I was wondering if SQL Reporting services is a viable replacement for Crystal > Reports? We currently use Crystal Reports 11 with our application and > distribute the runtime files to our customers. Over have of our customers use > MSDE instead of the full licensed copy of SQL. For our next version, we are > moving to SQL 2005 and are wondering if SQL Reporting services would work for > us. For the customers running SQL Express 2005, what kind of limitations > would this create? Your opinions and thoughts are much appreciated. > > Thanks in advance! >
I thought that the SQL Express edition didn't come with Report
Manager???? I thought that it only support RDLC I could never get Report Manager setup correctly; and I formatted a couple of times wiht a couple of different operating systems; no luck -Susie [quoted text, click to view] Bruce L-C [MVP] wrote:
> Seems to me that if the data is in SQL Express then all the workstations can > use the report on the data via Report Manager. You have to use integrated > security (not forms based). That is my interpretation of the following > feature matrix: > > http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Mike" <Mike@discussions.microsoft.com> wrote in message > news:0688D1C6-2821-49CC-91BB-CCE1A3976EC3@microsoft.com... > > So if all there data is on that instance of SQL Express, all workstations > > on > > the network can use report on the data? All of our clients have one > > database > > and it is on just one instance of SQL. Are you telling me just the machine > > with the instance can report on the data? > > > > "Bruce L-C [MVP]" wrote: > > > >> There are two versions of Express so they would need to get the version > >> with > >> RS. Also, this version of RS only reports against local data. So if the > >> data > >> is in Express then no problem but they can't use it to report against > >> data > >> on a different server. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Mike" <Mike@discussions.microsoft.com> wrote in message > >> news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... > >> >I was wondering if SQL Reporting services is a viable replacement for > >> >Crystal > >> > Reports? We currently use Crystal Reports 11 with our application and > >> > distribute the runtime files to our customers. Over have of our > >> > customers > >> > use > >> > MSDE instead of the full licensed copy of SQL. For our next version, we > >> > are > >> > moving to SQL 2005 and are wondering if SQL Reporting services would > >> > work > >> > for > >> > us. For the customers running SQL Express 2005, what kind of > >> > limitations > >> > would this create? Your opinions and thoughts are much appreciated. > >> > > >> > Thanks in advance! > >> > > >> > Mike > >> > >> > >>
Seems to me that if the data is in SQL Express then all the workstations can
use the report on the data via Report Manager. You have to use integrated security (not forms based). That is my interpretation of the following feature matrix: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Mike" <Mike@discussions.microsoft.com> wrote in message news:0688D1C6-2821-49CC-91BB-CCE1A3976EC3@microsoft.com... > So if all there data is on that instance of SQL Express, all workstations > on > the network can use report on the data? All of our clients have one > database > and it is on just one instance of SQL. Are you telling me just the machine > with the instance can report on the data? > > "Bruce L-C [MVP]" wrote: > >> There are two versions of Express so they would need to get the version >> with >> RS. Also, this version of RS only reports against local data. So if the >> data >> is in Express then no problem but they can't use it to report against >> data >> on a different server. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Mike" <Mike@discussions.microsoft.com> wrote in message >> news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... >> >I was wondering if SQL Reporting services is a viable replacement for >> >Crystal >> > Reports? We currently use Crystal Reports 11 with our application and >> > distribute the runtime files to our customers. Over have of our >> > customers >> > use >> > MSDE instead of the full licensed copy of SQL. For our next version, we >> > are >> > moving to SQL 2005 and are wondering if SQL Reporting services would >> > work >> > for >> > us. For the customers running SQL Express 2005, what kind of >> > limitations >> > would this create? Your opinions and thoughts are much appreciated. >> > >> > Thanks in advance! >> > >> > Mike >> >> >>
Susie understands that... she's sitting right here a cubicle down from
me does the version of Express that 'comes with RS' come with a web interface??? does the version of Express that 'comes with RS' come with a web interface??? does the version of Express that 'comes with RS' come with a web interface??? I sure didn't get a reports or reportServer interface.. or ReportManager interface.. I didn't have jack shit from using that Sql 2005 Express with Reporting Services.. i figured it came with libraries; but not the web interface. Is it supposed to come with the web interface?? [quoted text, click to view] Bruce L-C [MVP] wrote:
> There are two versions of SQL Express. One with RS and one without. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > <susiedba@hotmail.com> wrote in message > news:1161284308.764251.310320@h48g2000cwc.googlegroups.com... > >I thought that the SQL Express edition didn't come with Report > > Manager???? > > > > I thought that it only support RDLC > > I could never get Report Manager setup correctly; and I formatted a > > couple of times wiht a couple of different operating systems; no luck > > > > -Susie > > > > > > > > > > > > Bruce L-C [MVP] wrote: > >> Seems to me that if the data is in SQL Express then all the workstations > >> can > >> use the report on the data via Report Manager. You have to use integrated > >> security (not forms based). That is my interpretation of the following > >> feature matrix: > >> > >> http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Mike" <Mike@discussions.microsoft.com> wrote in message > >> news:0688D1C6-2821-49CC-91BB-CCE1A3976EC3@microsoft.com... > >> > So if all there data is on that instance of SQL Express, all > >> > workstations > >> > on > >> > the network can use report on the data? All of our clients have one > >> > database > >> > and it is on just one instance of SQL. Are you telling me just the > >> > machine > >> > with the instance can report on the data? > >> > > >> > "Bruce L-C [MVP]" wrote: > >> > > >> >> There are two versions of Express so they would need to get the > >> >> version > >> >> with > >> >> RS. Also, this version of RS only reports against local data. So if > >> >> the > >> >> data > >> >> is in Express then no problem but they can't use it to report against > >> >> data > >> >> on a different server. > >> >> > >> >> > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > >> >> > >> >> "Mike" <Mike@discussions.microsoft.com> wrote in message > >> >> news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... > >> >> >I was wondering if SQL Reporting services is a viable replacement for > >> >> >Crystal > >> >> > Reports? We currently use Crystal Reports 11 with our application > >> >> > and > >> >> > distribute the runtime files to our customers. Over have of our > >> >> > customers > >> >> > use > >> >> > MSDE instead of the full licensed copy of SQL. For our next version, > >> >> > we > >> >> > are > >> >> > moving to SQL 2005 and are wondering if SQL Reporting services would > >> >> > work > >> >> > for > >> >> > us. For the customers running SQL Express 2005, what kind of > >> >> > limitations > >> >> > would this create? Your opinions and thoughts are much appreciated. > >> >> > > >> >> > Thanks in advance! > >> >> > > >> >> > Mike > >> >> > >> >> > >> >> > >
There are two versions of SQL Express. One with RS and one without.
-- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] <susiedba@hotmail.com> wrote in message news:1161284308.764251.310320@h48g2000cwc.googlegroups.com... >I thought that the SQL Express edition didn't come with Report > Manager???? > > I thought that it only support RDLC > I could never get Report Manager setup correctly; and I formatted a > couple of times wiht a couple of different operating systems; no luck > > -Susie > > > > > > Bruce L-C [MVP] wrote: >> Seems to me that if the data is in SQL Express then all the workstations >> can >> use the report on the data via Report Manager. You have to use integrated >> security (not forms based). That is my interpretation of the following >> feature matrix: >> >> http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Mike" <Mike@discussions.microsoft.com> wrote in message >> news:0688D1C6-2821-49CC-91BB-CCE1A3976EC3@microsoft.com... >> > So if all there data is on that instance of SQL Express, all >> > workstations >> > on >> > the network can use report on the data? All of our clients have one >> > database >> > and it is on just one instance of SQL. Are you telling me just the >> > machine >> > with the instance can report on the data? >> > >> > "Bruce L-C [MVP]" wrote: >> > >> >> There are two versions of Express so they would need to get the >> >> version >> >> with >> >> RS. Also, this version of RS only reports against local data. So if >> >> the >> >> data >> >> is in Express then no problem but they can't use it to report against >> >> data >> >> on a different server. >> >> >> >> >> >> -- >> >> Bruce Loehle-Conger >> >> MVP SQL Server Reporting Services >> >> >> >> "Mike" <Mike@discussions.microsoft.com> wrote in message >> >> news:5C78FFD8-5049-42D0-9176-687FBAF1F512@microsoft.com... >> >> >I was wondering if SQL Reporting services is a viable replacement for >> >> >Crystal >> >> > Reports? We currently use Crystal Reports 11 with our application >> >> > and >> >> > distribute the runtime files to our customers. Over have of our >> >> > customers >> >> > use >> >> > MSDE instead of the full licensed copy of SQL. For our next version, >> >> > we >> >> > are >> >> > moving to SQL 2005 and are wondering if SQL Reporting services would >> >> > work >> >> > for >> >> > us. For the customers running SQL Express 2005, what kind of >> >> > limitations >> >> > would this create? Your opinions and thoughts are much appreciated. >> >> > >> >> > Thanks in advance! >> >> > >> >> > Mike >> >> >> >> >> >> >
I got caught in this trap. One SQL Express advanced version download does come with Reporting Services alright, BUT, you then have to purchase the Business Inteligence module. I even called Microsoft thinking it was a mistake. If you plan on using Visual Studio to do the developement you'll be purchasing the Standard SQL 2005 version.
EggHeadCafe.com - .NET Developer Portal of Choice
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |