Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Object Size and Position 2

Status
Not open for further replies.

N11689

Programmer
Jan 29, 2002
113
US
I need to change the X coordinate of a field on a report based on the value of the field. I entered the following formula in the formula box for the X: coordinate:

IF {field.value} = n
Then 1.00
Else 1.50

So, if the {field.value} = 1 then I want to position the beginning of the field at 1.00 otherwise position the beginning of the field at 1.50

I've never used this feature before, and it doesn't seem to be working. I looked at the online help, and I believe what I have entered is correct, however, the field does not adjust its beginning position at all. It stays where I originally placed it on the report.

Can someone please help me and let me know if I am doing something incorrectly? I am using Crystal XI.

Thank you.
 
Digging deeper into the help section, I found that you must use "twips" in your formula (Never heard of them before!), and there are 1440 twips to an inch. So your formula should be:

IF {field.value} = n
Then 1440
Else 2160

-LB
 
Could you tell me where exactly 'deeper into the help section' you found this? I'll try and look myself, but since this was so helpful, it would be good to post it in this thread for future reference. Thanks very much.
 
In the index, go to "objects"->"changing X position conditionally."

This was not a subcategory of the obvious heading: Object Size and Position Dialog box, where conditional formatting is mentioned, but without reference to twips.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top