Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: formating a detail section Post Reply Post New Topic
Author Message
figgy
Newbie
Newbie


Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Quote figgy Replybullet Topic: formating a detail section
    Posted: 18 Jan 2016 at 10:34am
In the detail section of my report there is a table field that is called "level".  I would like the row to indent 3 spaces based on the "level".  For example:
Name        Level        descriptioh
abc              1            grapes
  def               2             peach
  hij                2             pear
    klm              3              orange    
  nop              2             apple

I hope this is making sense?  Thanks!


Edited by figgy - 18 Jan 2016 at 10:34am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 19 Jan 2016 at 4:14am
I am not sure when it was introduced, but at least in Crystal Reports 2011, you can use a formula in the x position value in the size and position dialog box.
IP IP Logged
figgy
Newbie
Newbie


Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Quote figgy Replybullet Posted: 19 Jan 2016 at 6:50am
I am using Crystal 2008, I am not sure I understand what you mean by using a formula in the size and position dialog box?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 19 Jan 2016 at 11:33am
The text below copied from http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12697.

Right click on the field there is a size and position option
this gives you x and y in inches so you can multiply it by twips to get the position but the formula moves the field left (negative value) and right positive value relative to it's original starting position.

So it appears that if you use an if statement (probably the easiest way to go).  I am not sure what the translation between the width of a space and twips are but I would do something like this.

if {level} = 2 then 100
   else if {level} = 3 then 200
else 0
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.016 seconds.