Crystal Reports AND SQL Server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Crystal Reports AND SQL Server 2000

I’m looking for some information about the best way to connect a Crystal Report to a SQL Server 2000 db. I am being required to provide information on performance issues in order to decide on the process that will be implemented in an intranet environment. The 2 schools of thought are: 1. Use stored procedures that will take as parameters the values that the results will be filtered by. No dynamic SQL, temporary tables or cursors will be used. 2. Use Crystal’s built in filtering and connect directly to a view which will contain all of the fields that are required by the report. If anyone has any performance testing data or can provide links to information regarding this issue please post here. Thanks in advance.
hi,<br />we have tried both the option and , in my opinion sps with parameter is good rather Crystal Reports utility to filter or Crystal Query…<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards.<br /><br /><br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
Crystal Reports stores the data source properties within each report. Each data source can also have its own connection information. This gives you great flexibility for using different servers to generate data from, however when you want to deploy your reports from a development server to a production server you will have to remap the reports to the new server, unless you are using Crystal Reports Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
quote:Originally posted by campbellcanuck I’m looking for some information about
quote:the best way to connect
a Crystal Report to a SQL Server 2000 db. I am being required to provide information on performance issues in order to decide on the process that will be implemented in an intranet environment. The 2 schools of thought are: 1. Use stored procedures that will take as parameters the values that the results will be filtered by. No dynamic SQL, temporary tables or cursors will be used. 2. Use Crystal’s built in filtering and connect directly to a view which will contain all of the fields that are required by the report. If anyone has any performance testing data or can provide links to information regarding this issue please post here. Thanks in advance.
to connect to db from crystal report i preffered using DSN , because as if you have to modified in your connection string etc. DSN will be the better way but for that your support team has to go to client location or using VNC support team can do it remotely.
Regards.
hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

quote:Originally posted by satya Crystal Reports stores the data source properties within each report. Each data source can also have its own connection information. This gives you great flexibility for using different servers to generate data from, however when you want to deploy your reports from a development server to a production server you will have to remap the reports to the new server, unless you are using Crystal Reports Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
may i know how to remap the reports, satya?.. thanks regards
>>may i know how to remap the reports, satya?.. I think you need to map the Server thru Fron End Coding or open the Report; In the Menu Goto Database->Set Location and map the Server Madhivanan Failing to plan is Planning to fail
Hi,<br />their is a Menu DATABASE and from their select Set Location from where you can set a new server location , after that you need to select verify database from DATABASE to set / check it to update.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Try SQL 2000 Reporting Services which is far advanced than Crystal reports. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
quote:Originally posted by satya Try SQL 2000 Reporting Services which is far advanced than Crystal reports. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Satya, Somewhere I read that some features supported by Crystal are not supported by SSRS
May I know the advantages of SSRS over Crystal? Madhivanan Failing to plan is Planning to fail
I have used Crystal reports previously, I have started using RS recently and found few topics are really worthful. In Crystal Reports security is a major drawback, you can buy Crystal Enterprise or use Crystal RAS to help with security but depending on your requirements Active Directory or a front-end application should be able to handle all your needs. Crystal Reports doesn’t have facility to build views or SPs.
Again licensing issues to build their own reports.
A limited integration facilities to CR with other web environment.
It doesn’t have facility to schedule the reports. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
]]>