Crystal Export to Text

[DrSql]

While I am exporting a report to text there is space in front of each line my. Is there anyway i can delete that.
I have tried everything to the report but I didnt had any luck. Any suggestins will be great.
Thanks


Dr. Sql
vpathisseril@yahoo.com
Good Luck.

 

[MJRBIM]

If you left-justify all your fields and place your first field at the left edge of the report - then you will not get spaces before the first character.

However, you will still get spaces between your fields when you export to text.

EXAMPLE

ItemNumber Item Description
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1234 DOG
1235 CAT
1236 MOUSE
1237 BIRD
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Is that the export result you are looking for? If not, please show an example of what you need....

 

[IdoMillet]

I believe this issue was fixed in one of the recent hotfix releases.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[DrSql]

I have tried few updates that suggested by Crystal Decision.
We are working a Citrix environment. Still I am getting a space in front.

Here is a samlpe of my text output from export. I dont want any spaces in front of each line.
Thanks

DRS35500123365266020031114
0000030000000004140035500123365266011142
0000030001000004753735500123365266011142
0000030002000004453035500123365266011142
0000030003000001869435500123365266011142
0000030004000001399335500123365266011142
0000030005000005249535500123365266011142
0000030006000003399435500123365266011142
0000030007000003243935500123365266011142
0000030008000002580135500123365266011142


Dr. Sql
vpathisseril@yahoo.com
Good Luck.

 

[MJRBIM]

What is the Format of this field in the DataSource? All the leading zero's make me think it's a string...

Are you sure that the leading space is NOT in the field in the DataSource?

 

[DrSql]

Yes I am sure the data is fine... It works fine in ceratin workstations.
I have edited in the Registry "PromptAgain" to , as suggested by Crysstal report web site. Also they want to apply the latest U2ftext.dll Also applied all Service Pack1 and 2 for CR 8.5
Thanks


Dr. Sql
vpathisseril@yahoo.com
Good Luck.

 

[rhinok]

Exclusive of patch issues, there are very specific measures you should take in order to obtain good Text or Paginated Text output from Crystal Reports:[ol][li]This isn't required, but I recommend setting all margins to 0". Margins are irrelevent to Text output, so there's no reason to use them.[/li]

[li]Use the Courier 10 Regular (no italics, bolds, etc...) Font. Courier 10 Regular is the default Text font for Windows.[/li]

[li]When you export the report from Windows to either Text or Paginated Text you need to set the Characters per Inch to 12. With Char/inch at 12 provides 133 characters per line in an 11 1/2 inch Landscape page. If you don't have the option to set this size upon export then you need to check for the following registry keys:

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\Export\TextExport\PromptAgain - the DWORD Hexadecimal value should be set to '1'

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\Export\TextExport\CharPerInch - the DWORD Hexadecimal value should be set to 'c'[/li]

[li]Avoid using text-wrapping, if possible. Some text wrapping may work, but its inconsistent. Multi-line text boxes, column headers, etc.. should be broken into multiple text boxes.[/li]

[li]Check the Snap to Grid option (File|Options|Layout). This will help immensely.[/li]

[li]Avoid using Center and Right justification. Instead use Left Justification and position the field accordingly.[/li]

[li]Keep all fields as tight to the text as possible. For example, a text box with the value 'Part Number' should only be as wide as the text requires (11 characters)
If you're publishing these reports via Crystal Enterprise, there are a number of other issues you'll have to deal with, as well.[/li][/ol]Hope this helps,

~Kurt

 

[DrSql]

I have tried all your suggestions but I think my issues is PrmotAgain is not prompting. I have set up PromptAgain to 1 and CharPerInch to 12. Also I am using U2ftext.Dll version 8.5.0.98 to export.
Any suggestions.
Thanks



Dr. Sql
vpathisseril@yahoo.com
Good Luck.

 

[IdoMillet]

Since you are under Citrix, and since the registry settings are typically under the "Current User" registry branch, look into the question of who is the "Current User"...

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[DrSql]

Can you be more specific what you meant by "Current User"
I have added TextExport in the registry for HKEY_ "Current User" and "Users". Crystal Support KBase suggests that if I am using U2fText.dll version 8.6.0.99, but my version is using is 8.5.0.98.
Details available at Crystal KBase:
http:\\support.crystaldecisions.com/library/kbase/articles/c2020510.asp.
I have tried all suggested options from KBase.
Thanks


Dr. Sql
vpathisseril@yahoo.com
Good Luck.

 

[rhinok]

Just to be safe, I'd drill down into every user in the H_KEY_USERS key where these keys (promptagain and charperinch) are found and modify their values. The Default user is the first place to start.

 

[DrSql]

My deafult user in the Registry has Export option and when users log in they dont have that option. I have delated user profiles and logged back in still no luck.
Thanks
Varghese


Dr. Sql
vpathisseril@yahoo.com
Good Luck.