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.

Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?

4 Answers   IBM,

hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....

0 Answers  

Can we use our own SQL for creating a report?

5 Answers  

hi ... i've created one crystal report in windows form and one crystalreportviewer .. the following is my code.. in form1.cs file try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net- informations.pdf"; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } the above code is saving the file into pdf into specified path.. but i dont want to save a file i should get direct print preview and have a option to print .. As we do in web application using crystal report viewer clicking print and report will be opened in pdf.. and the click print.. i want the same function as we do in web application... i'm writing code in c#.net hope the above explaination will be understood clearly..

0 Answers  

Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,

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

5 Answers  

What are Crystal Reports and Crystal Reports Explorer?

1 Answers  

How many sections are there in the report

6 Answers  

Can we use stored procedure for creating the report?

11 Answers   Medreich,

Can we export data of reports into other format like in world doc etc?

5 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 to write a formula to change a font based upon data ?

2 Answers