Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports 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
 
Old July 19th, 2004, 07:35 AM
Registered User
 
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Changing a Table Name

Hi,

I have a problem, where I did a Report on a table which now I want to rename, but as soon as I rename the table (access DB) the report fields just disappear.

Is there any workaround, or do I have to start the report from scratch?


 
Old July 19th, 2004, 10:14 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

I guess its Normal but I have a suggestion:
Copy ur .mdb file with another name, & then set ur Connection in ur Report to new file name.

HTH.

Always:),
Hovik Melkomian.
 
Old July 24th, 2004, 04:41 AM
Registered User
 
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Thanks for Your Help.

I solved the Problem, by Creating a new Table with the correct name, and then in the report I set the Database Location to the new Table.

To change the Location, you right click on the report goto Database -> set Location and you replace the current DataSource with a new DataSource.

Regards
Mark






Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically changing table location csloanATYC BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 November 6th, 2008 02:32 PM
Table row background colour changing meetravig Java GUI 0 September 21st, 2007 05:06 AM
dynamically changing the destination table premaanand SQL Server DTS 1 April 10th, 2006 03:37 PM
Changing every character in a table whiffin SQL Language 1 November 4th, 2004 05:54 PM
Changing Table structure on the fly Tallon Wolle Pro VB 6 1 January 21st, 2004 10:36 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.