Crystal Report Vesion Crystal Report 4 6 Crystal

  • Slides: 105
Download presentation

Crystal Report Vesion • Crystal Report 4. 6 • Crystal Report 7 • Crystal

Crystal Report Vesion • Crystal Report 4. 6 • Crystal Report 7 • Crystal Report 8. 5 • Crystal Report 9 • Crystal Report 10 • Crystal Report 11 • Crystal Report 2008 • Crystal Report 2011

http: //www. crystalreports. com/default. asp Crystal Report 4. 6 Crystal Report 7 Crystal Report

http: //www. crystalreports. com/default. asp Crystal Report 4. 6 Crystal Report 7 Crystal Report 8. 5 Crystal Report 4. 6

http: //www. crystalreports. com/default. asp SAP Crystal Reports Viewer SAP Crystal Reports Server (OEM

http: //www. crystalreports. com/default. asp SAP Crystal Reports Viewer SAP Crystal Reports Server (OEM Edition) SAP Crystal Server for Mobile (add-on) SAP Crystal Reports for Visual Studio. NET SAP Crystal Reports for Eclips SAP Crystal Presentation Design SAP Crystal Interactive Analysis, Desktop Edition SAP Business. Objects (BI On. Demand Embed) SAP Crystal Dashboard Design (Departmental Edition) SAP Crystal Dashboard Design (Personal Edition)

Crystal Report ��������� (Database) + �������� Crystal Report

Crystal Report ��������� (Database) + �������� Crystal Report

Crystal Report Connect to Database ODBC Database Native Crystal Report

Crystal Report Connect to Database ODBC Database Native Crystal Report

Crystal Report and Programming

Crystal Report and Programming

����� Crystal Report

����� Crystal Report

Crystal Report Progrm Program API File

Crystal Report Progrm Program API File

Section

Section

Crystal Report ������� ������ (Section) - Report Header - Page Header - Detail -

Crystal Report ������� ������ (Section) - Report Header - Page Header - Detail - Report Footer - Page Footer

������� (Section) ������ 5+ ���� Report Header RH Page Header PH Detail D Report

������� (Section) ������ 5+ ���� Report Header RH Page Header PH Detail D Report Footer PF Page Footer RF

�������� ��� Page 1 Page 2 Page 3 RH PH PH PH D D

�������� ��� Page 1 Page 2 Page 3 RH PH PH PH D D D D D RF D D D PF PF PF

Section : Expert Section

Section : Expert Section

Fields

Fields

������������ (Fields) -Database Fields ����� Database {table. Name. field. Name} - Formula Fields ���������

������������ (Fields) -Database Fields ����� Database {table. Name. field. Name} - Formula Fields ��������� {@formula. Name} - Parameter Fields ��������� {? parameter. Name} - Running Total Fields ��������� � {#running. Name} - SQL Expression Fields ��������� SQL {%sql. Name} - Group Name Fields ��������� � ��������� (���� Function) - Special Fields ������� �

Fields : Database Fields

Fields : Database Fields

Fields : Formula Fields

Fields : Formula Fields

Fields : Format

Fields : Format

Field : Running Total Fields

Field : Running Total Fields

Field : Parameter Fields

Field : Parameter Fields

Section : Group Section

Section : Group Section

Object : Cross-tab

Object : Cross-tab

Object : Chart Expert

Object : Chart Expert

Object : Chart Option

Object : Chart Option

Object : Sub Report

Object : Sub Report

Crystal Report + Programming

Crystal Report + Programming

Application VB, JAVA, Delphi Web Application ASP, JSP, PHP Database Access, DB 2, ….

Application VB, JAVA, Delphi Web Application ASP, JSP, PHP Database Access, DB 2, …. Crystal Report Version….

Crystal Report + Programming Project Database Crystal Report Program

Crystal Report + Programming Project Database Crystal Report Program

Crystal Report �������� Database Run SQL Database Crystal Report Call Report Program Add Data

Crystal Report �������� Database Run SQL Database Crystal Report Call Report Program Add Data to Report Program Crystal Report

Crystal Reports Progrm

Crystal Reports Progrm

. 2���������� (Fields) ������ (����������� ) Comment Variable Declaration Scope Local, Global, Shared Operator

. 2���������� (Fields) ������ (����������� ) Comment Variable Declaration Scope Local, Global, Shared Operator Expression Statement Control Statement

. 2������������ (Fields) ������ (��������� ) Variable Declaration scope type var_name Scope Local �������

. 2������������ (Fields) ������ (��������� ) Variable Declaration scope type var_name Scope Local ������� Formula �������� Global ����� Formula ���������� Shared ����������� type Boolean. Var Number. Var Currency. Var Date. Var Time. Var Date. Time. Var

. 2���������� (Fields) ��������� Operator Arithmetic Operators Relational Operators Logical Operators

. 2���������� (Fields) ��������� Operator Arithmetic Operators Relational Operators Logical Operators

. 2���������� (Fields) ������ Operator : Arithmetic Operators + * /  mod ^

. 2���������� (Fields) ������ Operator : Arithmetic Operators + * / mod ^ % $

. 2������������ (Fields) ������ Operator : Logical Operators and t t = t, t

. 2������������ (Fields) ������ Operator : Logical Operators and t t = t, t f = f, f t = f, f f = f or t t = t, t f = t, f t = t, f f = f eqv t t = t, t f = f, f t = f, f f=t imp t t = t, t f = f, f t = t, f f =t xor t t = f, t f = t, f t = t, f f = f not t = f, f = t

. 2������������ (Fields) ������ (��������� ) Control Statement condition if-then-else select case loop for

. 2������������ (Fields) ������ (��������� ) Control Statement condition if-then-else select case loop for loop while loop do while loop

. 2���������� (Fields) ������ (����������� ) Control Statement condition : if-then-else if condition then

. 2���������� (Fields) ������ (����������� ) Control Statement condition : if-then-else if condition then statement; else statement;

. 2������������ (Fields) ������ (��������� ) Control Statement condition : select case select var_name

. 2������������ (Fields) ������ (��������� ) Control Statement condition : select case select var_name case value 1 : statement; case value 2, value 3 : statement; default : statement;

. 2���������� (Fields) ������ (����������� ) Control Statement loop for loop while loop do

. 2���������� (Fields) ������ (����������� ) Control Statement loop for loop while loop do while loop

. 2���������� (Fields) ������ (����������� ) Control Statement for loop for var_name : =

. 2���������� (Fields) ������ (����������� ) Control Statement for loop for var_name : = start to end do ( statement; ); for i : = 1 to 10 do ( a : = a + i; ); for i : = 10 to 1 step -1 do ( a : = a + i; );

. 2���������� (Fields) ������ (����������� ) Control Statement loop while loop do while loop

. 2���������� (Fields) ������ (����������� ) Control Statement loop while loop do while loop while condition do ( statement; ); do ( statement; ) while condition; Exit While ������ Loop While

Function abs(number) �������� abs(number) int(number) ) ����� int(number fix(number) ����� fix(number) fix(number, dex) �������������

Function abs(number) �������� abs(number) int(number) ) ����� int(number fix(number) ����� fix(number) fix(number, dex) ������������� fix(number, dex) round(number) ������������� round(number) round(number, dec) ��������������� round(number, dec) truncate(number) ) �������������� truncate(number, dec) ������������������� truncate(number, dec) remainder(������� , ������ ) mod remainder(������� sum(field) sum(field, condtion) average(filed) average(field, condtion) count(filed) count(field, codition) distinctcount(field) distinctcount(field, condtion) Maximum(field) Maximum(field, condition) Minimum(field) Minimum(filed, condition) percentofsum(field,

Function Length(x) trimleft(x) trimrigth(x) lowercase(x) uppercase(x) strreverse(inputstring) numeric(x) tonumber(x) totext(x, d) replicatestring(x, n) space(x)

Function Length(x) trimleft(x) trimrigth(x) lowercase(x) uppercase(x) strreverse(inputstring) numeric(x) tonumber(x) totext(x, d) replicatestring(x, n) space(x) instr(str 1, str 2) instrrev(str 1, str 2) strcmp(str 1, str 2) mid(str, start, length) left(str, length) right(str, length) val(str) chr(x) asc(str)

Function currentdate currenttime currentdatetime year(d) month(d) dayofweek(x) date(y, m, d) dateserial(y, m, d) dateadd(interval,

Function currentdate currenttime currentdatetime year(d) month(d) dayofweek(x) date(y, m, d) dateserial(y, m, d) dateadd(interval, num, date) datediff(interval, date 1, date 2) datepart(interval, date) today