Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

report

Posted on 2011-09-22
4
Medium Priority
?
262 Views
Last Modified: 2012-05-12
Can you please help me to know how to generate report using crystal report from oracle database a  simple one..
0
Comment
Question by:nobleit
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 2000 total points
ID: 36584888
0
 
LVL 23

Assisted Solution

by:OP_Zaharin
OP_Zaharin earned 2000 total points
ID: 36584935
- my last hands-on with crystal report is old, the simple setup would be like this:
1- create the ODBC connection via Windows ODBC data source to Oracle
2- in crystal report,  choose 'New Report' or 'Report Wizard'
3- choose the ODBC data source name when prompted and login. it will display list of Oracle tables that you can chose to work with. select any.
4- choose whether to write you own SQL or build the query using the GUI
5- and also start designing the report by placing and formatting the required fields, caption, title and etc.

- or use oracle native connection as per following tutorial:
http://www.bidw.org/crystal-reports/crystal-reports-tutorial-creating-a-standard-report/
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36998435
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month12 days, 5 hours left to enroll

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question