 |
| Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
September 23rd, 2003, 05:37 AM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Convert Crystal reports from access to sql server
I have developed a software in VB6 (backend Access). Now I have changed the backend as SQL Server. This software contains near about 150 reports. which I developed in Crystal Reports (Backend Access). Can anybody help me to change the backend of crystal reports (i.e. from Access to SQL Server) because this is very lengthy process for me to develop all the reports again in SQL. Thanks in advance.
|
|
September 23rd, 2003, 07:35 AM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi
You need to change the database driver (see ConvertDatabasedriver method) of every report and logoninfo and location (see Setlogoninfo and Location methods) of every table of each report. You can write a small VB or VBA procedure to do this programatically using Crystal Report Objects. See Crystal Report Developer's Guide. If you need further help, please let me know.
Niaz
|
|
September 30th, 2003, 04:42 AM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Dear Niaz,
Please note that I am using crystal reports 4.6.1.0 version and not found any convertdatabasedriver option in it. I am very thankfull to you if you tell me step by step. I was not well thatswhy I was on leave and saw your mail today. Again thanks in advance.
|
|
September 30th, 2003, 05:34 AM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Dear Sunbagga
You need to have Seagate Crystal Report 8.0 or later. I can help you with a VB procedute that uses Crystal Report 8.5 Objects. I am sure this will also run on Crystal Report 8.0. If you can manage Crystal Report 8.0 or later, Let me know.
Good luck
Niaz
|
|
July 16th, 2004, 10:15 AM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I am using cr 8.5 and I am lunching reports with PEOpenPrintJob and s.o. IPA functions. I am trying to convert DB drivers from access to SQL Server. I am using PELogOnServer, PESetNthTableLogOnInfo, PESetNthTableLocation and I am getting err. msg "Unable to open database." on execution StartPrintJob API function. Is any body had same problem?
Thank you in advance.
|
|
September 22nd, 2004, 08:23 AM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
quote:Originally posted by sunbagga
I have developed a software in VB6 (backend Access). Now I have changed the backend as SQL Server. This software contains near about 150 reports. which I developed in Crystal Reports (Backend Access). Can anybody help me to change the backend of crystal reports (i.e. from Access to SQL Server) because this is very lengthy process for me to develop all the reports again in SQL. Thanks in advance.
|
I have the same problem! Did you manage to solve it?
Help would be highly appreciated.
Thanks.
|
|
November 15th, 2005, 08:52 PM
|
|
Registered User
|
|
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Just in case anyone, based on the subject, is looking to convert Crystal Reports templates to Microsoft SQL Server Reporting Services, I recommend checking out rpttosql.com. They offer a service that does it.
|
|
December 12th, 2005, 05:06 PM
|
|
Registered User
|
|
Join Date: Dec 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
quote:Originally posted by sunbagga
I have developed a software in VB6 (backend Access). Now I have changed the backend as SQL Server. This software contains near about 150 reports. which I developed in Crystal Reports (Backend Access). Can anybody help me to change the backend of crystal reports (i.e. from Access to SQL Server) because this is very lengthy process for me to develop all the reports again in SQL. Thanks in advance.
|
Hi, Still using VB4.1.6 and unable to change it by something better (and maybe expensive), do you still have the crystal reports key? I still hold the VB5 key but unable to remenber the other number.
|
|
January 30th, 2006, 10:05 PM
|
|
Registered User
|
|
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Check out http://www.rpttordl.com to convert Crystal Reports RPT to Reporting Services RDLs.
|
|
July 16th, 2007, 05:57 AM
|
|
Registered User
|
|
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi!, I have tried Convert Database Driver Option. It converts the Access driver to Sql Server (pdssql.dll). But the problem is Relationship between the tables is merged.
Example : If my table Accbal is Linked to AcMaster with two links Accbal.AcCode with AcMaster.AcCode and Accbal.AcsubCode with AcMaster.AcSubcode, after te conversion, both fields of AccBal table links to AcCode field of AcMaster.
Few of the reports have more than 8 tables, so it is very difficult to re-do the relationships.
Can anyone help me resolve this.
Thanks
Pranav Kapadia
|
|
|
