I'm trying to make a report that will show a constant string for one condition and a field in a table for another condition.

Here is a example of the formula i'm using:

If {table1.Always} = 1 then "Always"
else
{table2.description}

The problem I come with is that i get the result but only for one of the condition. I run the report and get only the result that correspond to the else part. If i remove the else part, I get the result that correspond to the line that have 1 in the table1.always. I can never come up with the result i would like to appear:

Result1     Always
Result2     Description1
etc

Can someone help me please?

Thanks

I would like to print both depending of what is inside the field of the first table. If there is a certain value it will print the string. For other value in the first table it will print information from a second table.

do you have NULL values in the always field when it is not=1? If so change the formula to use default values for NULLs

Edited by DBlank - 09 Jun 2011 at 4:00am

when you add your line to get data from value 2 is the first use of any field from that table?