Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How to change the field column position Post Reply Post New Topic
Author Message
FerdieBanu
Newbie
Newbie
Avatar

Joined: 07 Sep 2008
Location: Singapore
Online Status: Offline
Posts: 13
Quote FerdieBanu Replybullet Topic: How to change the field column position
    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
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet 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
IP IP Logged
FerdieBanu
Newbie
Newbie
Avatar

Joined: 07 Sep 2008
Location: Singapore
Online Status: Offline
Posts: 13
Quote FerdieBanu Replybullet Posted: 11 Sep 2008 at 7:03am
Hello, thanks for the suggestion. Its now working!
 
Many thanks again. God Bless!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.