Introduction to Crystal Reports
Crystal Reports is a business insight application used to make custom reports from an assortment of information sources. This particularly incorporates the significant features required for a business to make a database announcing condition, for example, information get to, report configuration/arranging, report survey, and application joining.
This Crystal Reports is a well known Windows based report composing application which permits an engineer to make reports. When you have availability to your information source you plan your reports by including the fields from the database which are shown from your information source and adding them to the report. SAP Crystal Server (as Named User or Concurrent Access) empowers mechanized dissemination, self-administration access to reports, dashboards, and information investigation inside a safe foundation.
Essential things you will Study in this Tutorial:
Steps for making a Crystal Report
Benefits of Using Crystal Reports
Installation Requirements for Crystal Reports
Technical Specifications
Main Features
Steps for making a Crystal Report
- Create a table in the database.
- Create a VIEW in your database to show representative information data.
- Go to Visual Studio.
- Go to the Solution Explorer and right-click on your venture name and seelct Add – > New Item.
- Add New Item-> Crystal Report.
- Click the Ok Button.
Benefits of Using Crystal Reports
Flexible and redone report : You can rapidly make profoundly organized, pixel-impeccable reports utilizing SAP Crystal Reports with significant level plan interface and effective work processes.
Powerful report conveyance alternatives : You can convey customized reports to your business end-clients in their favored language and arrangement.
Data source availability : You can associate with data sources legitimately. Information sources include: Native, ODBC, OLE DB, and JDBC network to social, OLAP, web administrations, XML, endeavor information sources, and salesforce.com.
Expanded support for Excel : You can exploit the Excel document position by permitting more information to be traded to a solitary worksheet, without spreading over various worksheets.
Windows working framework similarity : SAP Crystal Reports programming 2013 is ensured perfect with Microsoft Windows 7.
Mobile similarity : You can likewise open intelligent reports through your cell phones.
SAP Crystal Reports, Adobe Flash and HTML 5 mix : It empowers SAP Crystal Reports engineers to deliver incredible “concoction” pulling information from different sources.
Establishment Requirements for Crystal Reports
PC with AMD or Intel based processors, Dual Core CPU, 2 GB RAM
Approximately 4GB accessible hard drive space (for English just, 8 GB for all dialects)
Microsoft Windows 7 SP1, Windows 8, Windows Server 2008 SP2, Windows Server 2008 R2 SP1, Windows Server 2012.
Technical Specifications
Hardware Requirements – Intel Pentium III or comparable processor, least 512 MB RAM suggested
Disk Space – 2 GB for default establishment with English language, 4 GB for default establishment with all dialects introduced.
Primary features of SAP Crystal Reports
- Powerful information blend.
- Intuitive plan condition.
- Design increasing speed highlights.
- Field adventurer to oversee report fields.
- Wizards and specialists for report creation.
- Database master for graphical table connecting.
- Editable see window.
- Drill down in runtime.
Crystal Report can associate with various information sources that incorporates
- Universe
- SAP BEx Query
- Relational Connection
- HANA view
- Excel Spreadsheets
To interface with a Data source, go to File → New → From Data Source .
Sorts of filters that can be utilized in Crystal Reports
- Predefined Filters
- Custom Filters
Predefined Filters
These are inbuilt channels in inquiry board made by the admin. Predefined filters are made at the Universe level and are legitimately utilized in the report from the Universe. Drag an item on which you need to apply channel to inquiry channel sheet and drag predefined channels as well. At the point when you run the inquiry information regarding the question channel will be returned in the report.
Custom Filters
These channels are made with the inquiries in the question board. Custom channels are made in the Query board under the question channel tab. Drag the item to the inquiry channel sheet and utilize different social administrator to pass the channel condition. Then, we can put a steady worth or a rundown of qualities in the channel.
Report Viewing and Interaction
Crystal Reports gives adaptable alternatives that let end clients see and collaborate with data in natural organizations and by means of recognizable situations.
Multiple trade designs : Furnish end clients with reports in the arrangement they like. Fare reports to well known organizations, including Excel, PDF, XML, HTML, RTF, and that’s only the tip of the iceberg.
Customizable report watchers : Look over an assortment of server-side and meager customer report watcher controls, including DHTML page (WebForms) watcher, .NET WinForms watcher, Java watcher, ActiveX, and Report Part watcher (versatile watcher), to render reports into different yield positions without extra coding. End client report intuitiveness choices including page forward/back, drill up/down, fare, and print are naturally included and can be modified dependent on your necessities.
Parameters : Let clients see similar information in various manners without making numerous reports. End clients can choose predefined parameters in a solitary report to get a subset of tweaked information.
Alerting : Feature explicit data for your end clients with report cautions client characterized messages that show up when certain conditions are met by the information in a report. Utilize this component with Crystal Enterprise so alarms can be conveyed to end clients with direct connections back to the first report.
Guided route : Characterize explicit route ways between report protests inside the equivalent or various reports for simpler end client route.
Hyperlinks : Use hyperlinks to transform reports into intelligent web records that associate with related data, including sites and different reports. Drill-down Without extra coding, make reports that permit end clients to bore down on social and OLAP information to reveal subtleties that may some way or another go unnoticed.
Report parts : Repurpose existing reports for use with remote gadgets and corporate entryways. Give end clients access to outlines, rundown tables, explicit records, and other key report data by means of entrances, WML telephones, RIM Blackberry, and Compaq iPAQ devices.