+4
Hi All,
We are using IFS 9 and we have the following problem with reports:
In much description-fields the text will be formatted by the user using tab key.
These descriptions are "unreadable" in reports designed with IFS Report Designer or Crystal Reports:
The C#-forms shows us probably more spaces for a char(9) as the database?
How can I show a "nice" formatted text in the report?
Can anybody help me?
Best regards
Lucie
Best answer by CallumW
View originalHi,
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
+4
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.
BR, Lukasz
+4
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.
+15
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
+4
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!
With the spaces it works, but then there is often not enough storage for all the text.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.