Print Page | Close Window

How to change the field column position

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4211
Printed Date: 28 Apr 2024 at 9:01pm


Topic: How to change the field column position
Posted By: FerdieBanu
Subject: How to change the field column position
Date Posted: 10 Sep 2008 at 2:57am
Hi guys, I'm a newbie in Crystal.
 
Here's my question:
 
I need to reposition my field 'Qty' and "Selling Price" if my item has different value.
ex. pseudocode:
 
if Item = 'L' then
 
Display
Name Description Qty  Selling Price Net Amount
 
If Item = 'P' Then
 
Display
Name Description Selling Price  Qty  Net Amount
 
Any ideas where should I change it. Sample code will be much appreciated.
 
Many Thanks!
 
Ferdie Banu


Replies:
Posted By: Savan
Date Posted: 10 Sep 2008 at 4:45am
create two formulas   like display1 & display2
for e.g for display1 the formula contains
if item = "L" then
  qty
else
  selling price;
 
in same for display2 the formula contains
if item = "L" then
 selling price
else
  qty;
 
then place the fields
 
name discription @display1 @display2 net amount
 
i hope this may workout for you.
 
 


-------------
Thanks
Savan

Posted By: FerdieBanu
Date Posted: 11 Sep 2008 at 7:03am
Hello, thanks for the suggestion. Its now working!
 
Many thanks again. God Bless!


Print Page | Close Window