I want to know how to remove table from Data Field in Field Explore in crystal Report. becs i have to make crystal report as same desigen as earlier design but change of tables
That is very easy, You just go to datasource menu , that show dialoge with details of your database connection with your selected tables or stored procedure or views list.
This window have two block with arrow option between this two. Left side show current database objects and right side show your report's data i.e table or view or sp which you used. You just select table and use arrow to remove, and then press ok botton.
This will update your report's database object , also remove your fields and column in which you used this currently remove database object.
Member
12 Points
76 Posts
how to remove table from Data Field in Field Explore in crystal Report
Oct 23, 2013 03:25 AM|mohan singh mehra|LINK
hi team,
I want to know how to remove table from Data Field in Field Explore in crystal Report. becs i have to make crystal report as same desigen as earlier design but change of tables
Member
594 Points
385 Posts
Re: how to remove table from Data Field in Field Explore in crystal Report
Feb 28, 2014 01:22 AM|aspsak|LINK
Google Image Reference
http://stackoverflow.com/questions/2803209/crystal-reports-changing-the-data-source
Contributor
6622 Points
1742 Posts
Re: how to remove table from Data Field in Field Explore in crystal Report
Mar 04, 2014 12:31 AM|Ajay2707|LINK
Hi MohanSingh,
That is very easy, You just go to datasource menu , that show dialoge with details of your database connection with your selected tables or stored procedure or views list.
This window have two block with arrow option between this two. Left side show current database objects and right side show your report's data i.e table or view or sp which you used. You just select table and use arrow to remove, and then press ok botton.
This will update your report's database object , also remove your fields and column in which you used this currently remove database object.
http://resources.businessobjects.com/support/communitycs/TechnicalPapers/cr_database_menu.pdf in this link Search text ( In the Data tab of CR 9, you can add or remove tables and database connections from a report. )
This link good to understand menu reagarding database object
http://scn.sap.com/docs/DOC-41469
http://stackoverflow.com/questions/8128659/how-do-i-point-crystal-reports-at-a-new-database
http://stackoverflow.com/questions/16840532/can-you-update-a-data-table-without-losing-your-columns-in-your-report-in-cryst
http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.businessobjects.integration.eclipse.doc.crdesigner/reportdesigner/crtskchangingthedatasourcelocation.htm
http://victoriayudin.com/2010/07/20/renaming-tables-in-crystal-reports/