‘Crystal Reports functions’ Archives
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 [...]
