Auto-generate Flow Chart from Java/C++ Codes:

Raptor Flowchart Tutorial For Beginners

Wednesday, December 19, 2012

A Note On Crystal Report and Pervasive Server - Create Connection by www.notarazi.com


Steps

1) Go to START/All Programs/Crystal Report 2011

Notice that there is a shortcut “ODBC Data Source Administrator”

2) “ODBC Data Source Administrator”.

- Click the “ODBC Data Source Administrator”.
- Go to “System DSN” tab.
- If Pervasive Server has been installed correctly, DEMODATA should appear in the list of System Data Sources. This indicates that connection would be ok.

3) Run Crystal Report

4) Go to Start Page Tab/ Start a new report Section/ click Blank Report.

5) Select Database

- Select ODBC(RDO) Connection.
- Select DEMODATA. (Make sure the Data Source Name is clicked i.e highlighted)
- click Finish.

6) Select Person Table

7) Insert fields to Details Section

- Press and hold [CTRL] key
- Click ID, First_Name and Last_Name
- Release [CTRL] key
- Drag the items to the Details Section

8) View the SQL query

9) Copy the SQL code

10) Create another new report

Go to File/New

11) “Add Command” Option

- Click “Add Command”
- Paste SQL code
- Click OK

12) A Query-based data connection

- Go to Field Explorer
- Notice that the Database Fieds contain an item “Command” which is comprised of three sub-items ID, First_Name, Last_Name

A Note On Crystal Report - Installing Crystal Report 2011 by www.notarazi.com


Preparation

Steps

1) Start Windows

2) Create Setup folder

Copy setup files for Crystal Report to here.

3) Install

1) Choose language

2) Pre-requisite Check

3) Installation Wizard

4) Accept license agreement

5) Specify Destination Folder

6) Enter user information

7) Choose Language Pack

8) Choose Install Type

9) Start Installation

10) Setup complete

A Note On Pervasive SQL - Installing Pervasive SQL 2000i Server by www.notarazi.com


Preparation

1) Pervasive Server Installer Files (downloadable from http://www.4shared.com/rar/7GWgZbuV/Pervasive_SQL_Server_CD.html 
2) Windows XP OS (Optionally you may use VirtualBox Setup)

Steps

1) Start the Windows

2) Create the setup folder.

Copy setup files for Pervasive Server to here.

3) Install

1) Welcome to the Pervasive SQL 2000i Setup program.

2) Read software license agreement

3) Choose Setup Type

4) Select Installation Directory

5) Pervasive System Analyzer

6) Searching for existing Pervasive files

7) Analyzer Results

8) Copying Pervasive SQL Files

9) Setup User Count License

10) Transactional Engine Test

11) Transactional Engine Test Results

12) Relational Engine Test

13) Relational Engine Test Results

14) Pervasive SQL Setup complete

Tuesday, December 18, 2012

A Note On Crystal Report 2011 - Getting Started


A Note On Crystal Report 2011- Getting Started

1. What is Crystal Report?

SAP Crystal Reports is designed to work with your database to help you analyze and interpret important information. Crystal Reports makes it easy to create simple reports, and, it also has the comprehensive tools you need to produce complex or specialized reports.

2. What is the benefit of Crystal Report?

Create any report you can imagine

Crystal Reports is designed to produce the report you want from virtually any data source. Built-in report experts guide you step by step through building reports and completing common reporting tasks. Formulas, cross-tabs, subreports, and conditional formatting help make sense of data and uncover important relationships that might otherwise be hidden. Geographic maps and graphs communicate information visually when words and numbers are simply not enough.

Extend reporting to the Web

The flexibility of Crystal Reports doesn't end with creating reports — your reports can be published in a variety of formats including Microsoft Word and Excel, E-mail and even over the Web. Advanced Web reporting lets other members of your workgroup view and update shared reports inside their web browser.

Incorporate reports into applications

Application and web developers can save time and meet their users needs by integrating the report processing power of Crystal Reports into their database applications. Support for most popular development languages makes it easy to add reporting to any application.
Whether it's the web master in IT, the promotion manager in marketing, the database administrator in finance or the CEO, Crystal Reports is a powerful tool designed to help everyone analyze and interpret the information that's important to them.

3. A starting point to learn Crystal Report

The recent version of Crystal Report (at the time of this writing) is Crystal Report 2011. You can download the 30-days evaluation program fromftp://78.129.251.58/SAP-Crystal-Reports/SAP-Crystal-Reports-2011-SP04.ZIP  or http://downloads.businessobjects.com/akdlm/crystalreports/51041020.ZIP 
Unzip the file and install it into Windows Platform.

4. Crystal Report’s User Interface

Application Window

Toolbar and Start Page

Menu Bar
Basic Toolbar
Formatting Toolbar
Reportting Toolbar

Start Page Items

5. Starting A New Blank Report Wizard

1) Click On “Blank Report” Link In the section “START A NEW REPORT” on the “Start Page”.
2) A new report with the title “Report1” is created.
- A Database Expert Dialog Window pops up.
- Notice a new Design Tab “Report1” and Field Explorer panel appear on the application window.

7. Database Expert Wizard

Database Expert Wizard Dialog Window pops up when a new report is created through the  clicking of Blank Report item on the Start Page.
1) Click On My Connections. If this is the first time you run the Crystal Report application, you may get “no items found” message.
2) Click “Create New Connection”. Click “Access/Excel (DAO) Connection.
3) The file browser pops up. Browse for the sample database “extreme.mdb”. Click Finish.
4) After the database file is located, the connection is established and you may now choose the table to work with the report.
Working with Customer Table
Crystal Report User Guide Tutorial starts with the Customer Table connection.
1) Refer User Guide Book (crystal-report-xi-xir2_cr_usergde_en.pdf, if you have):
2) Select Customer table and click OK.
3) Customer table is now loaded into the Field Explorer panel. If it is not visible, check that the Database Fields icon is exploded.

8. Design Tab

Report Section

The Design tab is divided into five sections: Report Header (RH), Page Header  (PH), Details (D), Report Footer (RF), and Page Footer (PF).

Short Section Names

If the Short Section Names check box is selected in the Design View area of the Options dialog box, then the Report Header, Page Header, Details, Report Footer and Page Footer section names will appear as RH, PH, D, RF and PF respectively. If this check box is not selected, follow these steps:
1. On the Filemenu, click Options.
The Options dialog box appears with the Layout tab active.
2. In the Design View area, select the Short Section Namescheck box.
3. Click OK to return to the report. Notice that the Section Name displays only Section Codes.

9. Browse Field Data

1) Highlight a field name by clicking the name once.
2) When you highlight a field name, you can review a subset of the values for that field as well as the field type and size by right-clicking the field and selecting Browse Data from the shortcut menu

10. Insert Field To The Report

1) Click the Customer Name field and drag it into the Details section of the
report. An object frame appears with the Arrow cursor as you drag the field onto
the report:
The Design tab should look similar to this:

11. Insert Multiple Fields To The Report

1) Selecting Multiple fields.
a. Click City
b. press [CTRL] key
c. Click Country
d. release [CTRL] key
2) Drag the fields to place them on the report. Notice the Multiple Field Mouse Icon
3) Multiple Fields will be automatically arranged on the report

12. Select Item on the report

1) Hover the mouse over the Customer Name Heading. The help label displays “Field Heading”.
2) Click Customer Name Heading. Notice that the status bar shows the name of the selected item.
3) Hover the mouse over the Customer Name Field. Notice that the help label displays the TABLENAME.FIELDNAME (FIELD DATA TYPE)
4) Click Customer Name Field. The status bar shows the description of selected field.
5) To deselect the item on the report, click the mouse pointer anywhere on the white area of the report.

13. Print Preview Report

1) Click on Print Preview Button on the Standard Tool Bar.
2) A new tab “Preview” appears.