how to change access db to sql db in crystal report ?

Question

0.00/5 (No votes)

See more:

Hai

I have a modification in website for database,actually it will create with access(.mdb) file,i will change to sql server and i change coding ,but in report fields or still in access database,i need to change sql sever without changing the link ,if i remove access(.mdb)connection all fields are removed form crystal reports,so i need to change Access connection to SQL server connection without removing fields in crystal report.

if i remove access and change connection to sql and again drag and drop fields into report it works,but it have more 10 crystal reports and use more than 5 tables in each reports and also i am not create crystal report with access database , so i don't know table links and fields for each reports.

The only way is remove access connection and connect sql server and need to redesign crystal report with dragging fields ? ? ?

Regards
Aravind

Posted 5-Mar-14 19:59pm

Aravindba

Add a Solution

2 solutions

Solution 1

This is why should go with PUSH method[^] which is independent of backend

I never tried this but check this solved thread
Changing datasource location and type at runtime in a Windows Forms app[^]

Posted 5-Mar-14 20:18pm

thatraja

Comments

Aravindba 6-Mar-14 2:32am

Hai
thank u for ur reply push method link used for create report in 2 way,second link is change the server side coding for crystal report,actually i already did,now i want in crystal report design time,bcz if i remove database connection form crystal reports all dragged fields are erased.so if change sql connection i don't know which table and is fields are dragged into crystal report?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

$*Developer - Vaibhav*$ · Accepted Answer · 2014-03-05T20:27:00

Solution 2

Hi
http://www.softwareforces.com/Support/Learning-Center/Step-by-Step/rpt-Inspector/Changing-Data-source-and-Database-Crystal-Reports-Dev-to-QA-to-Production[^]

or

http://scn.sap.com/docs/DOC-41469[^]

Posted 5-Mar-14 20:27pm

$*Developer - Vaibhav*$

Comments

Aravindba 6-Mar-14 2:40am

thanx a lot,first link work what i expect.....thanx a lot