Hi,

Not a solution but workaround.  Have you tried “Document Text” instead of using so much information in ‘Desription’ field? Document text should look nice.

BR, Lukasz

Hi Lukasz,

Thank your for this idea.
I tried it now, but unfortunately  it’s the same result.
The IFS Application shows me much more space for a horizontal tab (more or less 14 spaces) then the database or the IFS Report Designer (4 spaces).

Best regards
Lucie

Are you sure it’s standard layout of PO printout?

On REF environment below I prerpared some example with many spaces.

• red - Desription Field - field area is too narrow
• blue - Document Text - looks fine

BR, Lukasz

I am sure, it was not :-)

But now I tried it with the original IFS layout of PO printout.

… same result…

And it’s not importand wich layout we uses, not only PO printout, and not only in the Report designer, also in Crytsal Reports. All shows the same behavor.

There’s probably a much better solution than this… but this is the best I could come up with:

IFS:

Crystal Reports:

Create a function cut down all of the tabs to just one (You may need to add more to cover all bases - I have only included up to 8 tabs in a row)

replace(replace(replace(replace(replace(replace(
{PURCHASE_ORDER_LINE_NOPART_A.DESCRIPTION}
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9),chr(9))

Add text object to the report

Drag the function into the text box and highlight the function inside the text box

RMB - Text formatting…

Set a tab stop position (you may need to adjust this value)

And….. tada!

Regards, Callum

There’s probably a much better solution than this… but this is the best I could come up with:

IFS:

Crystal Reports:

Create a function cut down all of the tabs to just one (You may need to add more to cover all bases - I have only included up to 8 tabs in a row)

 replace(replace(replace(replace(replace(replace(
{PURCHASE_ORDER_LINE_NOPART_A.DESCRIPTION}
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9)+chr(9),chr(9))
,chr(9)+chr(9),chr(9))

 

 

Add text object to the report

 

Drag the function into the text box and highlight the function inside the text box

 

RMB - Text formatting…

 

Set a tab stop position (you may need to adjust this value)

 

 

And….. tada!

 

 

Regards, Callum

Would go with this answer, remove all but one tab then you know where you stand and can format the field accordingly with repeated accuracy

Going back to Report Designer… Standard layout of PO printout should handle Document Text in a proper way using spacebar(s) in each row. I don’t think ‘Tab’ button is supported. It doesn’t let me use it while typing value. Here is APP 9 REGIONAL TEST LKP screen:

 Printout:

 BR, Lukasz

@CallumW : This is a nice way for Crystal Report!

Unfortunately we have a verry old Crystal-Version, so we can’t change the tab-format.
But I will think at that in future!

Thank you!

@IC-LukaszP : Tab does work with “ctrl + tab".

With the spaces it works, but then there is often not enough storage for all the text.