Home > Crystal Report > Crystal Set Datasource Location Not Working

Crystal Set Datasource Location Not Working

Contents

If you expand the properties of each table you will see that it's still pointing at the old data source. Most Crystal Reports designers are in the same boat. I have two identical environments, one is TST and the other is PRD. probably not a good idea either... http://haiteq.com/crystal-report/crystal-setdatasource-not-working.php

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Back to top vadivelmothiSenior MemberJoined: 03 Nov 2008Posts: 49 Posted: Wed Apr 01, 2009 3:53 amPost subject: Re: Unable to update the datasource thro Set Datasource Loca what is the result Select the database and then updating doesn't update the source of every table. MDD99 replied Nov 27, 2008 Did anyone solve this problem? my response

Crystal Report Change Data Source

IP Logged keithme Newbie Joined: 19 Jan 2013 Online Status: Offline Posts: 2 Posted: 22 Jan 2013 at 12:20pm Looking at: http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=13766 I found the second entry said: Click on EMA Research Report: Demystifying Cloud MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Set datasource location for a command findu_2005 asked Sep 4, 2007 | Replies (20) Hi, I developed a report using a command pointing to a test sql server. share|improve this answer answered Nov 14 '11 at 22:00 craig 14.6k1363110 1 Just tried this, the report is still querying DB_A.

When the wizard is complete, you'll be presented with a status screen. Now how do I point the report to a production sql server? Some subreports will continue to point to the original database (e.g. Crystal Reports Change Data Source Programmatically Back to top amit.sawjiForum MemberJoined: 30 Mar 2009Posts: 27 Posted: Tue Mar 31, 2009 4:11 amPost subject: Re: Unable to update the datasource thro Set Datasource Loca Thank you for the

What is the more appropriate adjectival form of Trump? Once you've selected all the reports you want the wizard to work with, click on the NEXT button. Worked for me anyway.. This works for changing the location of a database, changing to a new database, and changing the location or name of an individual table being used in your report.

if possible try with ODBC connection and let me know the status . Crystal Reports Database Connection And update my CR using "Set Datasource Location" and point to the new DB. Screenshot http://i.imgur.com/gzGYVTZ.png) It's possible to rename the old table name to the new name from the context menu in Database Expert -> Selected Tables. I never qualify the table names, but the command is drawn from the datasource.

  1. Cheers!!
  2. Just wait until you have 50 or so reports with 40 odd tables that you have to swap around.
  3. The new database identifier will be placed into the command.
  4. All product names are trademarks of their respective companies.
  5. Is an Empowered Magic Missile more missiles or more damage per missile?
  6. Go to ‘Database’ menu | ‘Verify Database’ 2.
  7. Right click to reveal additional options such as SELECT ALL (Ctrl A).
  8. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
  9. Try updating the data source for each table one by one.
  10. Join them; it only takes a minute: Sign up Unable to change data source in Crystal reports 9 up vote 2 down vote favorite I have a report set up on

Crystal Reports Set Datasource Location

Can you tell me what exactly is the problem if I have the MDAC version 2.7? http://stackoverflow.com/questions/8128659/how-do-i-point-crystal-reports-at-a-new-database On Tate's "Endomorphisms of Abelian Varieties over Finite Fields", sketch of proof of main result? Crystal Report Change Data Source Wonderful!! Crystal Reports Set Datasource Location Does Not Update Example: TestDB.Table1 gets edited to Table1.

Select the reports you want to work with in the lower left pane and click on ADD TO SELECTION button. http://haiteq.com/crystal-report/crystal-report-viewer-not-working.php Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. It takes forever. –user159335 Feb 9 '11 at 14:35 Someone just marked this up, so an addendum. Once done click on the NEXT button. How To Change Crystal Report Database Connection

You will need to do this for the 'Subreports' nodes as well. Function to find all occurrences of substring Has a movie ever referred to a later movie? crystal-reports asp-classic share|improve this question asked Feb 8 '11 at 11:39 Dai 1,1931712 1 How did you change the data source? More about the author Development).It's very frustrating for us!  We use the Set Datasource Location for Crystal Reports design and testing.Anyone see this before?  Any ideas on how to fix or workaround it?Thank you,Eric Kenney

Crystal report is always full of trouble. –teapeng Mar 19 '15 at 1:30 | show 1 more comment Your Answer draft saved draft discarded Sign up or log in Sign Verify Database In Crystal Reports An example: in the command you see testdb.table1. The key is to change the datasource connection first, then any tables you need to update, then the other stuff.

Close Yeah, keep it Undo Close This video is unavailable.

IX. None of the above seems to help. It will open the menu to select the server and the database. Crystal Reports Change Data Source Without Losing Fields Loading...

Do you mean by Database->Set Datasource location or through code? –user159335 Feb 8 '11 at 11:43 Database -> Set Datasource location –Dai Feb 8 '11 at 13:58 add a Proving convergence of real sequence Why do most microwaves open from the right to the left? Find a limit without l'Hospital. http://haiteq.com/crystal-report/crystal-report-toolbar-not-working-asp-net.php Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Mimsy were the Borogoves - why is "mimsy" an adjective? share|improve this answer edited Jun 10 '15 at 3:58 Matthew Lock 5,99754772 answered Apr 10 '13 at 20:56 Todd Walton 42748 +1. Autoplay When autoplay is enabled, a suggested video will automatically play next. In the Field Explorer pane on the right, right click any SQL Expressions.

>