#CREATE LINK IN IDATABASE PASSWORD#

Use this option to rename an existing SQL command in the Business Objects Enterprise Repository. Use this option to delete an existing SQL command from the Business Objects Enterprise Repository. Use this option to delete a data source in the Favourite Folder. Use this option to rename a data source in the Favourite Folder. Use this option to obtain detailed information on the selected item. This option is also available by clicking the < arrow on the Database Expert. Use this option to remove a table or stored procedure from your report. Use this option to add a selected data source to the Favourites folder. This option is also available by clicking the > arrow on the Database Expert. Use this option to add a table or stored procedure to your report. When you right click any item in the Available Data Sources list of the Database Expert, a shortcut menu appears with the following options. Multiple tables can be selected together.

#CREATE LINK IN IDATABASE PASSWORD#

Then the user will be prompted to enter server name, database name, user name and password to log on to the chosen data source.Īfter finishing the database connection, the user can select the database tables from the connected data source. The Create New Connection folder contains subfolders for the following data sources.įor example, if the user opts for ODBC connection then either he can choose a data source from the list of available data sources or he can open a file dsn from the browse button. Click Make New Connection to open the Business Objects Enterprise Explorer from this dialog box, you can select an existing SQL command or Business View This folder shows you the contents of your repository through the Business Objects Enterprise Explorer.

This folder shows subfolders for various data sources you can connect to. The last five data sources used are displayed. This folder shows a list of data sources you have used recently. This folder shows a list of data sources you commonly use and have maintained in your Favorites list. This folder shows a list of data sources you are currently connected to. The Data tab of the database expert shows a tree view of possible data sources you can select when creating a new report. Ø Any other data source accessible through a web service, ODBC, JDBC or OLAP. Ø SAP: BW, Info Sets, Tables, and Business Objects Universes Ø Groupware applications as Lotus Notes, Microsoft Exchange and Novell GroupWise Ø Databases such as PostgreSQL, Sybase, IBM DB2, Ingres, Microsoft Access, Microsoft SQL Server, MySQL, Interbase and Oracle Ø An SQL command that has been saved to the Business Objects Enterprise Repository In the Database Expert, you can select from the following as a data source for your report:.Data tab and Link Tab of Database Expert helps the user to select the database fields and also to link them together.The Database Expert provides a tree view of all data sources you can use with Crystal Reports.Rather than having to sift through an entire database to find the data you requested, Crystal Reports lets the server do the sifting and gets back a much smaller set of data, thus reducing the time and resources your workstation must use in order to finish the report. This SQL query is a representation of the SQL statement that Crystal Reports sends to the SQL server.īy interpreting as much as possible from the report design into an SQL query, Crystal Reports can off-load much of the report processing onto the server machine.

This query can be seen by choosing Show SQL Query from the Crystal Reports menu. When you design a report that accesses SQL data, Crystal Reports builds an SQL query. When you connect to an SQL database, Crystal Reports acts as an SQL client application, connecting to your SQL server through your network. In the Database Expert, users can select and link tables from a wide variety of data sources, including Microsoft Excel spreadsheets, SQL, Oracle databases, Business Objects Enterprise business views, and local file system informationįor example, if the user wants to display the product details from product table residing in SQL database, then an ODBC connection needs to be established thru Database Expert. Database Expert dialogue box in crystal reports allows the user to select data sources and database fields/ tables in a simple and easier way.

ScenarioĬrystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. The author has been working on Business Objects projects for the last four years. This article describes about Database Expert in Crystal Reports.

Create link in idatabase