cystal reports if s...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] cystal reports if statements

2 Posts
2 Users
0 Reactions
60 Views
 mrmo
Posts: 10687
Free Member
Topic starter
 

I seem to be getting no where fast on what i am sure is a really easy thing,

Problem basically this

I got it working on one line, but i thought i would try and reduce the number of lines i needed by trying to nest the if statements.

IF product =a then
If colour =b then "hello"
if colour =c then "bye"
If product is d then
if colour is a then "bonjour"
if colour is b then "...."

The above is what i am trying to do. but can't get it to work.


 
Posted : 19/02/2009 3:59 pm
Posts: 251
Full Member
 

can you do 'and's?

If product = a and colour = b then...


 
Posted : 19/02/2009 4:03 pm
 mrmo
Posts: 10687
Free Member
Topic starter
 

i can do and's but the whole problem is

if material is a and colour is b and if profile is c,

Where there are 5 materials, 50 colours and 12? profiles.

I could see me writing the same line a lot of times and missing combinations. I was hoping that there was a way of nesting so i could write if material is a then if colour is b then profile is c. Just something to try and reduce the number of lines of code for me to screw up.


 
Posted : 19/02/2009 4:10 pm

6 DAYS LEFT
We are currently at 95% of our target!