crystal reports viewers, crystal reports schedulers, view crystal reports, report analyzers, burst reporting, report scheduler
 
view crystal reports, rpt viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler
desktop viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler

Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 


Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
Analyzers
Bestsellers
CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs
ReCrystallizePro


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
 

CrystalReports
on Steroids

Crystal Reports: Hot to Use Trig Functions in a Formula

We have been using Crystal Reports since version 4, and had a need back then to use a trigonometric function in a report we were working on. All that high school mathematics was needed and has since been forgotten. Working out a sine or cosine of an angle seemed of little use at school and hasn’t been a major requirement recently.

But we now have those functions in our reports, so we would like to share with you a hint to help you use them properly.

We can all remember that there are 360 degrees in a circle. The major thing to remember is that the Crystal Trigonometric functions are all in radians. There are 2π radians in a circle.

Yes that is that irrational number we use on all sorts circular calculations. Thankfully, Pi is also a function in Crystal Reports.

So if you want to work out the sine of a value that is in degrees, use the formula

Sin( {table.value in degrees} * crPi / 180)

A value of 30 degrees will calculate the value as 0.50

Now if we can only remember why we wanted to use those.

 

See below for some trig tips.

 

 

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.
 
Has it been a while since you've worked with trigonometry? If so, below is some refresher information for your convenience. Enjoy!

Some Trigonometry Rules

  • In any triangle, all sides add up to 180.
  • In a right triangle, the hypotenuse is the long side. The side opposite the smallest angle is the short side.
  • If two angles are 45, then their opposite sides are equal.
  • SIN, COS, and TAN (sine, cosign, and tangent) are simply ratios between sides and/or angles within a triangle.

Some Trigonometry Principles

sin A = a/c , cos A = b/c , tan A = a/b
Remember, Oscar Had A House Of Apples:
sin = Opposite/Hypotenuse , cos = Adjacent/Hypotenuse , tan = Opposite/Adjacent

1. Given a and b, find A, B, and c
tan A = a/b = cot B , c = Sqrt of (a2 + b2) = a * sqrt (1+(b2/a2)

2. Given a and c, find A, B, and b
sin A = a/c = cos B , b = sqrt ((c + a) * (c – a)) = c * sqrt (1 – a2/c2

3. Given A and a, find B, b, c
B =n 90 – A , b = (a * cot A) , c = a / (sin A)

4. Given A and b, find B, a, c
B =n 90 – A , a = (b * tan A) , c = b / (cos A)

5. Given A an dc, find B, a, b
B =n 90 – A , a = (c * sin A) , b = c / (cos A)