How do we connect to the database?

Answers were Sorted based on User's Feedback



How do we connect to the database?..

Answer / hema

Most data sources can be chosen through the Database Expert
dialog box. The Database Expert appears when you create a
report from scratch using Blank Report, or when you choose
Database Expert from the Database menu.

Note: You also select a data source in the Report
Creation Wizards. The Data screen in all of the Report
Creation Wizards, except the OLAP Report Creation Wizard, is
much like the Database Expert dialog box.

To select a data source
Choose Database Expert from the Database menu.
The Database Expert dialog box appears.

Use the tree view in the Available Data Sources list of the
Data screen to select your data source:
Current Connections
Favorites
History
Create New Connection
Repository

Some popular choices in the Create New Connection folder are
described here:

Access/Excel (DAO),Database Files,ODBC (RDO),OLAP
OLE DB (ADO)

Note: The data source options available in the Create New
Connections folder depend on the data access components
selected during installation.

Is This Answer Correct ?    10 Yes 0 No

How do we connect to the database?..

Answer / arvind gupta

Create a new report it will ask for database and objects or
go through menu database ==> Add to database .

Is This Answer Correct ?    1 Yes 1 No

How do we connect to the database?..

Answer / rocky

Open Database Expert dialog window. get the sql server
connection and after that connect to the available database

Is This Answer Correct ?    1 Yes 1 No

How do we connect to the database?..

Answer / neeraj

through the import wizard and from databases like
oracle,inframtica ............ etc
by the way of entering into the blank report then go to new
there it will the data base source then we will import.

Is This Answer Correct ?    0 Yes 0 No

How do we connect to the database?..

Answer / kavya

useing sqldataprovider

Is This Answer Correct ?    0 Yes 3 No

How do we connect to the database?..

Answer / rahul

1. Use crystal report built in query.
2. Use the tool Crystal SQL Designer provided by crystal
report.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Crystal Reports Interview Questions

What all performance improvement techniques used in crystal reports? (Particularly cr xi)?

0 Answers  


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,


How to open subreport in new ie window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report?

0 Answers  


Can we add any database field once we have chosen ?Close? button?

2 Answers  


to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report

2 Answers  






Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers

3 Answers   Wipro,


Why is Excel Report preferred over crystal reports?

3 Answers   Atos Origin, Collabera, Lighthouse Technologies,


If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?

0 Answers   IBM,


How can i normalize a Crystal Report..??

0 Answers   HCL,


reporter footer contents are move depend the page footer values...........

2 Answers  


How to "Print" in Crystal Reports while using ASP DOT NET Platform?

3 Answers  


One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita

5 Answers   Barclays,


Categories