WebJan 2, 2014 · Update Properties for tables with Alias name in Crystal Report 9. I am having reports created with ODBC [with SQL Authentication] which is having 2 tables used for Self Join. So both tables are having alias name for it. Now, I have updated the ODBC (Change in Database name and Changed SQL Authentication to Windows Authentication). WebCrystal Reports provides a single menu function for changing the connection to the database (database driver), recognizing a change to the physical location of a database or table, or changing the actual database …
Crystal Reports Change Source of Field
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5511 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20514 how many trash bins can i put out
Crystal Reports Change Field Source on Report
WebJan 30, 2012 · Point it to the DataView. This should bring up a box that shows any field differences and allow you to map them to the new fields. If that doesn't work, try selecting "Verify Database" from the Database menu. It should come up with a message that the database has changed and it's "proceeding to fix up the report". WebSelect or type in the name of the SQL server and choose a database to replace the current database. Click the Finish button. Back in the ‘ Set Datasource Location ’ window; make sure the correct database is selected in the ‘ Current Data Source ’ list. Select the newly created database connection in the ‘Replace with’ list. Click the Update button. WebOct 7, 2024 · Answers. It will work for both I am using for Stored procedure purpose try to used it and 100% it will solve the problem bascially anything in crystal report is table even if you bind with storedprocedure .Just you define the connection string in web.config file it will get the connection from web.config then set the logoninfo in crystal report. how many trans youths are there