How do we connect to the database?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Explain the various components in crystal reports?
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..
Where can we find the log file genertaed when we run a crystal report?
How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)
Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?
Can we use our own SQL for creating a report?
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.
How do you add a subreport to a report in Crystal Reports?
What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?
Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?
Can we use Crystal report as a stand-alone application?
what is the "refresh" button suppose to do on the crystal report viewer?