how to use between in crystal formula

Question

0.00/5 (No votes)

See more:

CrystalReports

i wan if qty is between 300 to 500 then show rate

like that

how to use it pls advice

thx in advance

Posted 10-Dec-14 19:25pm

Master Vinu

Updated 10-Dec-14 19:27pm

v2

Add a Solution

Comments

DamithSL 11-Dec-14 1:30am

what is rate and qty? are they columns of your table? what are the data types of those columns?

Master Vinu 11-Dec-14 1:30am

yes qty and rate is column data type is int

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2014-12-10T20:25:00

Solution 2

If qty >= 300 && qty <= 500 THEN showRate = 1 else showRate = 0 where showRate is shared variable.

I'm not sure I understand the question though this seems too easy...

Posted 10-Dec-14 20:25pm

Sinisa Hajnal

Master Vinu · Answer 2 · 2014-12-10T20:18:00

Solution 1

<pre>{FactoryProductionRateReport.Mouldqty}in 300 to 500 then {FactoryProductionRateReport.Points}*75/100</pre>

Posted 10-Dec-14 20:18pm

Master Vinu

how to use between in crystal formula

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

how to use between in crystal formula

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us