Crystal Reports help setting fixed width output

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: help setting fixed width output

Post Reply

Post New Topic

Author	Message
nitrotech Groupie Joined: 30 Jan 2013 Location: United States Online Status: Offline Posts: 42	Topic: help setting fixed width output Posted: 07 Oct 2013 at 11:52am
	How does one format the cells in Crystal to out put a fixed length for example cell one start at postion 1 and has a length of 6 Cell two starts at postion 7 and has a length of 1 cell 3 starts at postion 8 and has a lenght of 8 ECT so I want my cells to be a fixed length and start in certain postions. Thanks
	IP Logged


kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 07 Oct 2013 at 12:08pm
	If the field is not a sting, first convert it to a string, then you can do the following: {somefield}&space(5-lenght({somefield}). If the field can be null or empty, you may need an if statement to 'fill' the space (if len({somefield}) then space(5)). I hope this helps.
	IP Logged

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