Saturday May 27th 2017

Categories

Insider

Archives

‘Crystal Reports functions’ Archives

Using Parameters in Complex Record Selection and Grouping

Using Parameters in Complex Record Selection and Grouping

This an example based on Extreme Database and purpose is to show an example of Parameter functionality in Crystal Reports. Real-Life Reports often required a functionality of record selection not readily available in Crystal Reports. Your Client need a report that displays employee information. The client would like to display all employees or [...]

Evaluation Time Functions Crystal Reports

Evaluation Time Functions Crystal Reports

An Evaluation time function can be used in a formula to cause the formula to process sometimes after its default processing time. BeforeReadingRecords The BeforeReadingRecords evaluation time function causes the formula to be processed during prepass1 and BeforeReadingRecords should be the statement in formula. WhileReadingRecords The [...]

Crystal Reports Formula Workshop

I would like to share an interesting experience on Commissions and bonuses calculations. The contracts charges customers based on monthly/yearly as well as per visit basis. The issues were to calculate the Commission of the employees based on Services hours sold and the hourly rate both of these varied depending on the work employee accomplished. [...]

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to aggregate transnational data by phases if the information about phase is not stored in transactions table. Recently I encountered a scenario where I have to aggregate the information about Account holders spending transnational history by different phases, let's say there were 3 phases in which these transactions were falling. Transaction [...]

Use of Array function in Crystal Reports for producing comma delimited list of related orders

Use of Array function in Crystal Reports for producing comma delimited list of related orders

This example will demonstrate the very practical use of Array function in Crystal Reports. A client wants see the customer orders list in the comma delimited format in crystal report view used in a custom application. Customer name and related orders are stored in 2 different tables. Please figure 1 below report can be created by placing [...]

Using Day of week Function

Using Day of week Function

Day of week function is available in crystal report but we have to little code as below for obtaining the names of days. Begining day can be selected by changing the day name in this example CrMonday. Select DayOfWeek ({Table.Field}, crMonday) Case 1: "Monday" Case 2: "Tuesday" Case 3: "Wednesday" Case 4: "Thursday" Case [...]

Using Hour function for Hourly Time Brackets of the day for Date Ranges or selected dates

Using Hour  function for Hourly Time Brackets of the day for Date Ranges or selected dates

Hour Function is very useful if we want to, for example analyzing sales data for during certain times of the day. Use of hour function is given below; if hour({Table.field}) >= 00.00 and hour({Table.field}) = 4.01 and hour({Table.field}) = 8.01 and hour({Table.field}) = 12.01 and hour({Table.field}) = 16.01 and hour({Table.field}) = [...]

ToWords is resulting in as one hundred twenty three and 10 / 100

ToWords is resulting in as one hundred twenty three and 10 / 100

The subject query was posted by one of our visitor and he wants to write  as $123 and 10 cents. Following is the solution to that; local stringvar isNumber := cstr({SalesOrderDetail.UnitPrice}); local numbervar iswhole := ToNumber ({SalesOrderDetail.UnitPrice}); local numbervar ispos := instrrev(isNumber, ‘.’); local numbervar isdecimal [...]

Writing Indian Ruppees and Crore using towords

Writing Indian Ruppees and Crore using towords

This formula has been contributed by one of our valued visitor in response to querie posed by other users of Crystal Report numbervar RmVal:=0; numbervar Amt:=0; numbervar pAmt:=0; stringvar InWords :="Rupees "; Amt := tonumber({@Amount}); if Amt = 10000000 then RmVal := truncate(Amt/10000000); if Amt = 10000000 then RmVal := 1; if RmVal [...]

ToText formula example

ToText formula example

Totext is a formula in Crystal reports used to convert numeric value to text for example you want to write Your Salary is {StoredProcedure3_1;1.Salary} you will receive an error stating that string missing. So to write the same you need to use totext function as follows; "your salary is RS" + Totext({StoredProcedure3_1;1.Salary})

 Page 1 of 2  1  2 »