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.

Answer / arvind gupta

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

Answer / rocky

Open Database Expert dialog window. get the sql server
connection and after that connect to the available 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.

Answer / kavya

useing sqldataprovider

Answer / rahul

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

How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format

3 Answers   Target,

hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.

0 Answers  

What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?

2 Answers  

Can we use stored procedure for creating the report?

11 Answers   Medreich,

How to print two details fields at the bottom of the page

5 Answers  

How to add Crystal Reports(Standalone) to my VB.NET project

2 Answers  

How to write a formula to change a font based upon data ?

2 Answers  

Explain basic steps required to display a simple report in crystal?

0 Answers  

Is there a way to export the report formulas, like totals to excel?

3 Answers  

Explain reporter footer contents are move depend the page footer values?

0 Answers  

How many .rpt files are be there in a main report having 2 sub reports?

17 Answers   Accenture, Cap Gemini, CTS,

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,