|
|
You're in the
sql server reporting services
group:Converting from Crystal to SQL Server Report Services
sql server reporting services:
http://www.rpttosql.com/index.html I don't think there is a free tool (yet) that can do it. Examine other options though before putting all of your eggs in the RS basket. I was a huge fan at first but continue to be disappointed. [quoted text, click to view] "Jim Underwood" wrote:
> Due to lisencing issues and the fact that crystal is a CPU/memory hog > (mainly the latter), we are looking to convert to SQL Server Reporting > Services. We have two issues to address: > > 1. Converting all existing crystal reports to SQL Server Reports > Does anyone know of a tool that does this, or do we just start from > scratch with each report? > > 2. We need business users to be able to continue to be able to desing > reports, but we do not want to install VS.Net for each of them. > Is there a stand alone tool for developing SQL Server Reports, that does > not require VS.Net? > > Any advice would be much apreciated. > >
Due to lisencing issues and the fact that crystal is a CPU/memory hog
(mainly the latter), we are looking to convert to SQL Server Reporting Services. We have two issues to address: 1. Converting all existing crystal reports to SQL Server Reports Does anyone know of a tool that does this, or do we just start from scratch with each report? 2. We need business users to be able to continue to be able to desing reports, but we do not want to install VS.Net for each of them. Is there a stand alone tool for developing SQL Server Reports, that does not require VS.Net? Any advice would be much apreciated.
RS might be as much a CPU/memory hog, I don't know. I have heard of people
that have done lots of Crystal reports but I think it is more of a redesign rather than a convert. RS 2005 comes with an end user tool that does not require VS called Report Builder. I suggest checking out the documentation on the MS web site about that and see if it meets your needs. If you approach the matter as wanting to have RS do exactly what Crystal does then you will be disappointed. If you want to be able to design and keep the same techniques then you will be disappointed. How you design and solve problems is different. Some things that are easy in Crystal is hard to do in RS and vice versa. Another big issue is whether you will be using the portal that ships with RS (report manager) or it you will be integrating with your own web app. With RS 2003 this was harder than Crystal. VS 2005 ships with two new controls for RS 2005 that make integration with your own apps much much easier. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:e9AtO2rbGHA.3908@TK2MSFTNGP02.phx.gbl... > Due to lisencing issues and the fact that crystal is a CPU/memory hog > (mainly the latter), we are looking to convert to SQL Server Reporting > Services. We have two issues to address: > > 1. Converting all existing crystal reports to SQL Server Reports > Does anyone know of a tool that does this, or do we just start from > scratch with each report? > > 2. We need business users to be able to continue to be able to desing > reports, but we do not want to install VS.Net for each of them. > Is there a stand alone tool for developing SQL Server Reports, that > does > not require VS.Net? > > Any advice would be much apreciated. > >
Could you elaborate on the shortcomings of RS? This is a directive coming
from higher up, and I want to make sure we know what to expect going forward. [quoted text, click to view] "chicagoclone" <chicagoclone@discussions.microsoft.com> wrote in message news:FFADBBBB-37C3-4FA8-A4AB-8B10B263985B@microsoft.com... > there are some companies who can do this pretty inexpensively. > > http://www.rpttosql.com/index.html > > I don't think there is a free tool (yet) that can do it. Examine other > options though before putting all of your eggs in the RS basket. I was a > huge fan at first but continue to be disappointed. > > > > "Jim Underwood" wrote: > > > Due to lisencing issues and the fact that crystal is a CPU/memory hog > > (mainly the latter), we are looking to convert to SQL Server Reporting > > Services. We have two issues to address: > > > > 1. Converting all existing crystal reports to SQL Server Reports > > Does anyone know of a tool that does this, or do we just start from > > scratch with each report? > > > > 2. We need business users to be able to continue to be able to desing > > reports, but we do not want to install VS.Net for each of them. > > Is there a stand alone tool for developing SQL Server Reports, that does > > not require VS.Net? > > > > Any advice would be much apreciated. > > > > > >
Thanks for the advice so far. Someone else was able to track down a free
(more or less open source) report designer that works with 2000 and 2005, where as report builder appears to only be for 2005. Since we are on 200 atm, this seems like it may be a valid option. Here is the link, in case anyone is curious. http://www.fyireporting.com/download.html We are still looking into other options. [quoted text, click to view] "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:e9AtO2rbGHA.3908@TK2MSFTNGP02.phx.gbl... > Due to lisencing issues and the fact that crystal is a CPU/memory hog > (mainly the latter), we are looking to convert to SQL Server Reporting > Services. We have two issues to address: > > 1. Converting all existing crystal reports to SQL Server Reports > Does anyone know of a tool that does this, or do we just start from > scratch with each report? > > 2. We need business users to be able to continue to be able to desing > reports, but we do not want to install VS.Net for each of them. > Is there a stand alone tool for developing SQL Server Reports, that does > not require VS.Net? > > Any advice would be much apreciated. > >
Thanks,
We dont need it to work just like crystal. Personally, I would not want it to. Some folks (mainly IT) will require some retraining, while others will be trained on this as their first report design tool, so the differences should not be too bad. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:Oj2z%23zsbGHA.2396@TK2MSFTNGP02.phx.gbl... > RS might be as much a CPU/memory hog, I don't know. I have heard of people > that have done lots of Crystal reports but I think it is more of a redesign > rather than a convert. > > RS 2005 comes with an end user tool that does not require VS called Report > Builder. I suggest checking out the documentation on the MS web site about > that and see if it meets your needs. > > If you approach the matter as wanting to have RS do exactly what Crystal > does then you will be disappointed. If you want to be able to design and > keep the same techniques then you will be disappointed. How you design and > solve problems is different. Some things that are easy in Crystal is hard to > do in RS and vice versa. > > Another big issue is whether you will be using the portal that ships with RS > (report manager) or it you will be integrating with your own web app. With > RS 2003 this was harder than Crystal. VS 2005 ships with two new controls > for RS 2005 that make integration with your own apps much much easier. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > news:e9AtO2rbGHA.3908@TK2MSFTNGP02.phx.gbl... > > Due to lisencing issues and the fact that crystal is a CPU/memory hog > > (mainly the latter), we are looking to convert to SQL Server Reporting > > Services. We have two issues to address: > > > > 1. Converting all existing crystal reports to SQL Server Reports > > Does anyone know of a tool that does this, or do we just start from > > scratch with each report? > > > > 2. We need business users to be able to continue to be able to desing > > reports, but we do not want to install VS.Net for each of them. > > Is there a stand alone tool for developing SQL Server Reports, that > > does > > not require VS.Net? > > > > Any advice would be much apreciated. > > > > > >
Thanks for the link. It sounds like they charge $25 per report, which is
pretty cheap, although they offer a service rather than an application. We will need to look into that. [quoted text, click to view] "chicagoclone" <chicagoclone@discussions.microsoft.com> wrote in message news:FFADBBBB-37C3-4FA8-A4AB-8B10B263985B@microsoft.com... > there are some companies who can do this pretty inexpensively. > > http://www.rpttosql.com/index.html > > I don't think there is a free tool (yet) that can do it. Examine other > options though before putting all of your eggs in the RS basket. I was a > huge fan at first but continue to be disappointed. > > > > "Jim Underwood" wrote: > > > Due to lisencing issues and the fact that crystal is a CPU/memory hog > > (mainly the latter), we are looking to convert to SQL Server Reporting > > Services. We have two issues to address: > > > > 1. Converting all existing crystal reports to SQL Server Reports > > Does anyone know of a tool that does this, or do we just start from > > scratch with each report? > > > > 2. We need business users to be able to continue to be able to desing > > reports, but we do not want to install VS.Net for each of them. > > Is there a stand alone tool for developing SQL Server Reports, that does > > not require VS.Net? > > > > Any advice would be much apreciated. > > > > > >
If your users desire to create their own reports without having to bother IT
all the time, then I suggest you look at Report Builder in depth. This one tool alone is worth the price of admission with SQL 2005. Actually everything in 2005 is just better than 2000. My $0.02 worth. [quoted text, click to view] "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:OqKfyOtbGHA.4604@TK2MSFTNGP02.phx.gbl... > Thanks for the advice so far. Someone else was able to track down a free > (more or less open source) report designer that works with 2000 and 2005, > where as report builder appears to only be for 2005. Since we are on 200 > atm, this seems like it may be a valid option. > > Here is the link, in case anyone is curious. > > http://www.fyireporting.com/download.html > > We are still looking into other options. > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > news:e9AtO2rbGHA.3908@TK2MSFTNGP02.phx.gbl... >> Due to lisencing issues and the fact that crystal is a CPU/memory hog >> (mainly the latter), we are looking to convert to SQL Server Reporting >> Services. We have two issues to address: >> >> 1. Converting all existing crystal reports to SQL Server Reports >> Does anyone know of a tool that does this, or do we just start from >> scratch with each report? >> >> 2. We need business users to be able to continue to be able to desing >> reports, but we do not want to install VS.Net for each of them. >> Is there a stand alone tool for developing SQL Server Reports, that > does >> not require VS.Net? >> >> Any advice would be much apreciated. >> >> > >
Hi. I run the website RptToRdl.Com (we used to be known as RptToSQL.Com), a service that converts reports from Crystal Reports into Reporting Services. At this time, we only charge $25 per report. We are a recommended ISV from Microsoft now for converting your RPT templates into RDLs. http://www.rpttordl.com From http://developmentnow.com/g/115_2006_5_0_0_749669/Converting-from-Crystal-to-SQL-Server-Report-Services.htm Posted via DevelopmentNow.com Groups
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 |