![link tables in idatabase link tables in idatabase](https://i.stack.imgur.com/t6MtD.jpg)
![link tables in idatabase link tables in idatabase](https://i.ytimg.com/vi/GtubQMXxi5A/maxresdefault.jpg)
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.