Crystal Report Vesion Crystal Report 4 6 Crystal









































































































- Slides: 105
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 8. 5 Crystal Report 4. 6
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 Connect to Database ODBC Database Native Crystal Report
Crystal Report and Programming
����� Crystal Report
Crystal Report Progrm Program API File
Section
Crystal Report ������� ������ (Section) - Report Header - Page Header - Detail - Report Footer - Page Footer
������� (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 D D D RF D D D PF PF PF
Section : Expert Section
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 : Formula Fields
Fields : Format
Field : Running Total Fields
Field : Parameter Fields
Section : Group Section
Object : Cross-tab
Object : Chart Expert
Object : Chart Option
Object : Sub Report
Crystal Report + Programming
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 �������� Database Run SQL Database Crystal Report Call Report Program Add Data to Report Program Crystal Report
Crystal Reports Progrm
. 2���������� (Fields) ������ (����������� ) Comment Variable Declaration Scope Local, Global, Shared Operator Expression Statement Control Statement
. 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 + * / mod ^ % $
. 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 loop while loop do while loop
. 2���������� (Fields) ������ (����������� ) Control Statement condition : if-then-else if condition then statement; else statement;
. 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 while loop
. 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 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) ������������� 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) 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, num, date) datediff(interval, date 1, date 2) datepart(interval, date) today