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

How can we improve the performance of a crystal report?

0 Answers  


When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From

3 Answers  


Can we use Crystal report as a stand-alone application?

4 Answers   Covansys,


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,


What are the sections that we have in Crystal reports?

11 Answers  






Kindly Help for this Below Scenario, I am going to implement Power BI into our internal software. I’m familiar with the fact that each user can pay $9.99 a month to build and view reports but what I need to know is how can we embed Power BI into our application so that any users that log into our application can see the reports without the monthly fee. I’ve researched enough that it can be done. What I am not familiar with is how to do it or the pricing of embedding it into an application. I think they do pricing on how many renders you do or something. Would you be able to look into how we could embed it into our software and the cost?

0 Answers   Cognizant,


how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema

0 Answers   CSC,


How do we connect to the database?

6 Answers  


Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainty if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all the reports at run time?

0 Answers  


How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)

9 Answers   CSC, ERS, Jupiter,


I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,


What are Crystal Reports and Crystal Reports Explorer?

1 Answers  


Categories