Print Page | Close Window

ChrW(9) displaying Space, not Tab.

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=20872
Printed Date: 26 Apr 2024 at 3:24pm


Topic: ChrW(9) displaying Space, not Tab.
Posted By: Erik
Subject: ChrW(9) displaying Space, not Tab.
Date Posted: 08 Jul 2014 at 7:24am
Crystal Thick Client: 11.5.10.1263

I have a formula I am using to concatenate some data that needs to be tab delimited. However when I use ChrW(9) it is inserting a Space instead of a Tab. Even if I do multiple instances, each one still just represents one space, so it's not just that the Tab happens to line up with a Space coincidentally.

I have tried concatenating with both + and &

Any suggestions on how to get the tab to come across?

Example snippet:
{Command.VEN_ITEM_DESC} & ChrW(9) & {Command.DESCRIPTION}


Replies:
Posted By: Erik
Date Posted: 08 Jul 2014 at 7:30am
Nevermind. This was due to the same trailing spaces issue I had in another thread. Apparently that setting was also truncating the tabs.

http://crystalreportsbook.com/forum/forum_posts.asp?TID=20868


Print Page | Close Window