‘Crystal Reports functions’ Archives
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})
how many else if statements can crystal report have
This post is in response to recent query - how many else if statements can crystal report have? We are re-referencing our previous post as follows; This example is based on customer table in Northwind database The “if then else works well when condition leads to one of two settings”. Although it can handle multiple potential settings [...]
Changing a Traditional information system to adapt new technologies for effective decision making
This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new [...]
Change in business rule and its impact on Data model.
This post explains the extension in data model resulting from change in business rule. A Prime Group is a steel rolling mills and Export Company having its offices in Dubai and Pakistan. This project was to create /upgrade database and creating Crystal Reports to facilitate changes in business rules and expansion in manufacturing [...]
Business Intelligence – Layout-led and Data-led discovery
Layout-led discovery When we know the questions we want answered and have a good idea where that answer is going to be found, we can use the printed reports to deliver our business intelligence. This is the most common form of business intelligence. For example we want to know employee productivity for bonus calculations we know where to [...]
SQL Language Cross-Tab query
The query below is very useful for making for making Crystal reports in cross-tab format. We actually utilized the SQL query below for creating Crystal reports. We found this query more flexible than cross-tab query through wizard in Crystal reports. However it greatly depends on what is actually being accomplished. Simple Cross-tab query in [...]
Crystal Reports – Select Case statement and If then else statement
This post is explain to different approaches to testing multiple conditions and returning appropriate results; Select Case provide simpler approach to testing for multiple conditions and returning appropriate results than complex if-then-else statements. Select case statements are more readable and easy to maintain logic. We used an example in [...]
Crystal Reports ToText and ToWards function
ToText Function An very important built function in in Crystal Reports required in strig formulas. ToText function coverts other datatypes to string data type enabling these to be used in concatenation or comparison. Dates, numbers or any datatypes you need in string used to text. Towords function ToWords is a very useful function in [...]
